July 10, 2007 at 2:51 pm
We have a sql 2000 server where, over the years, 100's of users (both windows and sql) have been created. Is there a way to "script" those user logins and their permissions, both to capture the current settings and also to re-create those accounts in case of a Disaster Recovery or server consolidation effort?
TIA,
Barkingdog
July 10, 2007 at 3:40 pm
I found a free tool (caled Sqlpermissions) from Idera that looks like it could do the trick:
http://www.idera.com/freetools/
Case closed.
Barkingdog
July 10, 2007 at 3:42 pm
If you are looking at scripting the logins, such that the SIDs are maintained in the event of a database restore, see the following KB article:
How to transfer logins and passwords between instances of SQL Server (246133)
There is also a KB for SQL Server 2005. It's referenced in the KB article I've linked to.
K. Brian Kelley
@kbriankelley
July 11, 2007 at 2:51 am
The URL for 2005 is given below.
http://support.microsoft.com/kb/918992/
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply