Re: Lost Login Name on Backup

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 20:33:09 +0200

Read about sp_change_users_login in Books Online. Also search KB for sp_help_revlogin. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Don Miller" <nospam@nospam.com> wrote in message news:eJ1xH5kTEHA.3664@TK2MSFTNGP12.phx.gbl...
> I moved a DB from one server to another using a backup/restore file. When I
> restored the DB the user that I used to create the DB, and is the owner
> therefore, does not have a Login Name when I select Users. I can't delete
> the user (because it owns objects). I can't find a way to give the user a
> login name. Without this login I can't get an ASP application to work.
>
> So, how do I add a Login Name for an existing user that can't be deleted?
>
> Thanks.
>
>

Relevant Pages

  • Re: setup a sql login which can only reset password
    ... I couldn't test it right now, because if I login as helpdesk, i reset the ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: setup a sql login which can only reset password
    ... Tibor Karaszi, SQL Server MVP ... I tried and it gives the helpdesk the same error saying ... "Cannot alter login ' xxx', because it doesn't exist or you do not hav ...
    (microsoft.public.sqlserver.server)
  • Re: setup a sql login which can only reset password
    ... My thinking is that you might have to specify the old password when changing password, if you have ALTER ANY LOGIN permissions. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How many objects are owned by schema
    ... CREATE USER no_login WITHOUT LOGIN ... Schema and objects must be owned by a valid database principal but the database principal doesn't necessarily need to be associated with a login for ownership purposes. ... Tibor Karaszi, SQL Server MVP ... ALTER AUTHORIZATION ON OBJECT::dbo.testtable TO myself; ...
    (microsoft.public.sqlserver.programming)
  • Re: restoring dB and login to new server
    ... Tibor Karaszi, SQL Server MVP ... that looks like it would simplify things a bit...but I still need to create the login manually? ... databases between servers by doing a full backup, then restoring on the new ... database, I get an error that the "user or role already exists". ...
    (microsoft.public.sqlserver.tools)