Tag Archives: server configuration

Moving Database Logins

Recently we had a database issue, that necessitated us moving logins. Here’s an article I used from Microsoft to help script the logins. The KB is specifically for 2005 -> 2008, but it will also get you login’s out of … Continue reading

Posted in SQL Toolbox | Tagged , , , | Leave a comment

Enable CLR

This is just one of those things that I always forget how to do. EXEC sp_CONFIGURE ‘SHOW ADVANCED OPTIONS’ , ‘1’ — Let me change it GO RECONFIGURE GO EXEC sp_CONFIGURE ‘CLR ENABLED’ , ‘1’ GO RECONFIGURE GO EXEC sp_CONFIGURE … Continue reading

Posted in SQL Toolbox | Tagged , | Leave a comment

Windows Server 2008 & SQL Server 2005

It seems that Windows Server 2008 and/or SQL Server 2005 doesn’t automatically add a firewall exception to the OS for access to the database. As a result, an exception needs to be added, by following instructions found here.

Posted in SQL Toolbox | Tagged , | Leave a comment