Trail Blazer Knowledge Base:


Home : MS SQL Server : How to Fix orphaned SQL Account

Knowledge Base







User:

Password:



Article ID: KB73
Keyword Name:
Created: November 03, 2011
Viewed: 6025

How to Fix orphaned SQL Account

1>USE dbname

2>go

First, make sure that this is the problem. This will lists the orphaned users:

1>EXEC sp_change_users_login 'Report'

2>go

If you already have a login id and password for this user, fix it by doing:

1>EXEC sp_change_users_login 'Auto_Fix', 'username'

2>go

 

http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm

 



Find our more information about Trail Blazer Campaign Services Inc. [click here]


Powered by: ClickCarts KnowledgeBase