Assign database user to Login Name

If you have migrated your database, it is likely that the user will not be functional or cannot login. In this case, create a new login on Server Level and issue the following stored procedure to attached database user to login name.


Sp_change_users_login @Action= 'Update_One', @UserNamePattern= 'UserName',

@LoginName= 'LoginName' 

Reference : Add Database User to Login Name – Microsoft

Advertisements
This entry was posted in Software Development. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s