Re: SQL user with no login name

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/22/04 

Date: Wed, 21 Jul 2004 20:46:09 -0500

If the reported LoginName is NULL or mapped to the wrong login, you can
create a new login with the desired password and then map the orphaned user
to that login with sp_change_users_login: Orphaned users may occur after a
database is restored to a different server.

See the Books Online <tsqlref.chm::/ts_sp_ca-cz_8qzy.htm> for more
information on sp_change_users_login. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Jeremy Pond" <jpond@railcu.org.au> wrote in message
news:1a9f01c46f81$433779f0$a601280a@phx.gbl...
> hi,
>
> I'm trying to reset the password of an SQL login.
> However it doesn't have a login name. It only has a
> username. and hence when i use the Tsql command
> sp_password it doens't recognise the user as it has no
> login name.
>
> How can i assign a login name to the user ?
>
> thank you

Relevant Pages

  • Re: Login name is <none>
    ... I understand that you create a login in SQL ... >user in the database does not match any logins. ... This problem is known as an orphaned user. ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Re: Cannot create a SQL user logon
    ... Tibor Karaszi, SQL Server MVP ... >>> Login to Query Analyzer and execute the below query to check if login ...
    (microsoft.public.sqlserver.setup)
  • Re: who is the owner..
    ... GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.tablename TO myuser ... SQL Server MVP ... > 1> if using SQL Authentication then instead of using the sa login to ... > 3> that the owner of the database is the user who created it. ...
    (microsoft.public.sqlserver.msde)
  • Re: Back up on remote computer.
    ... >>Do the Administrator account have the same password on ... >>Tibor Karaszi, SQL Server MVP ... The error says that location of the (backup) ... Create a login on the SQL host computer. ...
    (microsoft.public.sqlserver.server)