Re: fix logins

From: Adam (anonymous_at_discussions.microsoft.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 09:06:21 -0800

Thanks Tibor,

Does sp_change_users_login work for non-windows accounts?
What about adding the login and fix the user's sid? How
does that work for non-windows, how do I keep the
passwords from the database?

>-----Original Message-----
>Either specify the SID that the user has in the database
in your sp_addlogin call, or just add the login and
>fix the user's sid using sp_change_users_login, or use
the KB article to export the logins from the source
>server (search KB for sp_help_revlogin).
>
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>
>"Adam" <anonymous@discussions.microsoft.com> wrote in
message news:12ade01c41874$f63ca8e0$a001280a@phx.gbl...
>> How do you create the logins with the same password,
when
>> you backup and restore a database to a seperate server
and
>> those logins do not exist at the server level?
>>
>> Adam
>
>
>.
>

Relevant Pages

  • Re: NT > 2003 domain name changes
    ... Can't use the DTS option as it doesn't retain the SID, ... -restore database to SQL2K ... - cut out logins that do not apply to the database at hand ... >> windows authentication over to a new sql server on a new ...
    (microsoft.public.sqlserver.security)
  • Re: NT > 2003 domain name changes
    ... >> Can't use the DTS option as it doesn't retain the SID, ... >> I should have ended up with database users and logins ... >> are the same, retain the correct permissions, have the ...
    (microsoft.public.sqlserver.security)
  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: transfering logins
    ... has their name, password, and a SID, among other attributes. ... In <your database>.dbo.sysusers, you will notice that each database user has ... database not a server object), but since the SIDs are generated at random, ... do not have this problem with Windows logins (hint: ...
    (microsoft.public.sqlserver.security)