Tag Archives: sql server 2005

Transferring logins and passwords between SQL Server 2005 and SQL Server 2008

This link is very useful and details how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. – Microsoft Knowledge Base: #246133

Posted in Software, computers, microsoft, sql server, windows, windows server 2008 | Tagged , , , , , , | Leave a comment

Microsoft Sql Server Administration…

Useful commands I’ve found from various sources for Microsoft Sql Server 2005/2008 include: EXEC sp_configure GO –Instance level principals. SELECT * FROM sys.asymmetric_keys SELECT * FROM sys.certificates SELECT * FROM sys.credentials SELECT * FROM sys.linked_logins SELECT * FROM sys.remote_logins SELECT … Continue reading

Posted in General, Security, Software, computers, internet, sql server, windows server 2008 | Tagged , , , | Leave a comment

Dealing with permissions on Sql server reporting services

If you have issues related to security while setting up SSRS 2008 or 2005, you might want to check out this MSDN tutorial for steps you might have missed. http://msdn.microsoft.com/en-us/library/aa337491.aspx

Posted in Software, computers | Tagged , , , , , | Leave a comment