Tag Archives: server configuration

Moving Database Logins

Posted on March 21, 2011 by Matt

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

Posted on October 30, 2010 by Matt

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

Posted on May 25, 2010 by Matt

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