Browse by Tags

09 April 2010
Copying logins to another server

I'm busy setting up a new server to replace our main live server and part of that is to get the logins copied over. The database users will come over when I restore the databases but I wanted to get the logins they relate to, with the same SIDs, passwords and other properties as they have on the... Read More...

3 comment(s)

Filed under: Tips and Tricks, Security

01 December 2009
Reporting security audit

Today I set out to produce a list of who has access to each report so I could get this audited by the business management. I didn't think it would take long. Download a couple of scripts, evaluate them, pick a good one, execute it, and on with the next job. After all, this is crucial stuff. There's... Read More...

1 comment(s)

Filed under: SQL Server 2005, Reporting Services, SQL Server 2008, Security