Re: Lost Login Name on Backup-Thanks

From: Don Miller (nospam_at_nospam.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 13:42:21 -0500

That did it!

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:OtP72AlTEHA.1472@TK2MSFTNGP12.phx.gbl...
> 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)