x

Migrating Persmissions along with Logins to new SQL Server Instance...

I am migrating a set of databases to a new SQL Server instance. Backing up and restoring the databases worked just fine, as did migrating logins with sp_help_revlogin however none of the permissions for the logins were preserved. Is there a way to migrate the permissions along with the logins?

more ▼

asked Nov 24, 2009 at 07:04 PM in Default

avatar image

noblethraher
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

The permissions should be with the databases. Perhaps you've lost the association between the server logins and the database users. See if their SIDs are different. If so you can fix them with

ALTER USER <user> with login = <associated login>            

or

exec sp_change_users_login (check books online for how to use this)            

http://technet.microsoft.com/en-us/library/ms174378.aspx

more ▼

answered Nov 24, 2009 at 07:27 PM

avatar image

TG
1.8k 3 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2017
x124
x103
x80

asked: Nov 24, 2009 at 07:04 PM

Seen: 2756 times

Last Updated: Nov 24, 2009 at 07:04 PM

Copyright 2016 Redgate Software. Privacy Policy