question

NCjuggler avatar image
NCjuggler asked

Scripting groups & permissions from SQL 2000 to SQL 2005

I have an upgrade project that involves installing Microsoft SQL 2005 I have several Microsoft SQL 2000 database that I have backup and restored to a Microsoft SQL 2005 database and am concerned that the groups & permissions will not carry over properly. Some permissions are set with Windows domain authenticification and others are set individually on the server.

Is there a method to script out restore groups/permissions to the new server?

Thanks in advance for any answers or suggestions.

sql-server-2005sql-server-2000security
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
graz avatar image
graz answered

You need to transfer the logins from the old server to the new. This KB article describes a pretty good process: http://support.microsoft.com/kb/246133.

After that the restore will bring over all the permissions included in the database. As long as the logins are created using the same SID as on the old server the user and login will match up. The KB article describes how to do this.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.