I can't believe that I am writing this blog entry on SQL Server. I am not a hard-core Db guy, more of one of those engineering types who looks on the Database Administrators with some scepticism and occasional bouts of devout worship when I am really in trouble with some deep, dark and scary SQL query.
I wanted to comment on a few things that seem to break when moving from SQL Server 2005 to SQL Server 2008. I was really surprised to discover that the latest version of Microsoft's SQL Server (2008) breaks some applications - particularly upon connection to the server. There are a number of security changes, which should be expected and can be found here: http://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-security.aspx
But, I was surprised to find that my existing/installed version of SQL Server Management Studio would not connect to a fresh install of SQL Server 2008.
A quick scan of the net, and there appears to be a few issues with compatibility of the new SQL server release including;
and for a great BLOG on the topic, visit the Scalability Experts tremendous effort located at: http://blog.scalabilityexperts.com/
If you are looking for a solution to the Management Studio connection issue, Microsoft has released a helpful KB article on the topic (http://support.microsoft.com/kb/946127/ ) and subsequently have released a hotfix; http://hotfixv4.microsoft.com/SQL%20Server%202005/latest/Yukon_SP2_CU5/9.00.3215.00/free/335088_intl_i386_zip.exe
I recommend that you install Service Pack 2 as well. SQL Server 2005 SP2 can be found here:
No comments:
Post a Comment