Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / September 2008

Tip: Looking for answers? Try searching our database.

relink orphane user - windows login

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sg - 30 Sep 2008 16:10 GMT
Hi,

How do I link the orphane user if it is a windows login like domain\user?
sp_change_users_login 'update_one', 'domain\user','domain\user'
it doesn't work, saying domain\user doesn't exist...

Thanks
sg
Russell Fields - 30 Sep 2008 16:44 GMT
sg,

The stored procedure is only for SQL Server logins, not Windows logins.  It
is used to synchronize names to update the user SID to match a login SID,
since these can differ across machines for SQL Server logins.

For Windows logins, the SIDs do not change across machines since they are
defined by the domain.

Therefore, if you have an orphaned user 'domain\user' one question is, does
the server have a login with the same name and SID?  If not (and it should
not or you would not have a problem) can you add the login to the server.
If the SIDs match, the user should automatically be reconnected.

RLF

> Hi,
>
[quoted text clipped - 4 lines]
> Thanks
> sg
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.