Clarity Service Management

MS SQL Server Migration 

05-14-2015 07:09 PM

Do you need change your server?

 

For a new MS SQL Server, after a restore a back-up, you cannot connect?

 

How are doing your MS SQL users

 

To detect Orphaned users:

USE <database_name>;

GO;

sp_change_users_login @Action='Report';

GO;

To Resolved:

USE <database_name>;

GO;

sp_change_users_login @Action='Report';

GO;


-- Associando a um login existente:

EXEC sp_change_users_login 'Update_One', 'nome do usuário', 'nome do login'

 

-- Associando a um login existente:

EXEC sp_change_users_login 'Update_One', 'servicedesk', 'servicedesk'



Troubleshoot Orphaned Users (SQL Server)  English


https://msdn.microsoft.com/pt-br/library/ms175475.aspx   Brazilian Portuguese

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

07-14-2015 10:48 AM

I recently had to migrate from one server to another server. Very useful command.

05-15-2015 05:57 PM

Thank you for sharing this with the community Tiago!

MS SQL Server Migration

Related Entries and Links

No Related Resource entered.