Hi, I'd like to connect to SQL Server 2008 CTP Nov 07 using Management Studio 2005 (SP5 + Cumulative Update 4). I got an error message "This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)". Using Query Analyzer (SQL Server 2000 tools) works OK. How come Management Studio 2005 cannot connect and how to fix this? Thanks very much in advance for any help.
Check the following... FIX: You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008 http://support.microsoft.com/kb/946127 Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview http://www.microsoft.com/downloads/...ef-1aa2-408d-aa0f-9df094f993bf&displaylang=en
Confirmed, After installing SQL Server 2005 SP2 Cumulative Update #5. I can now use Management Studio 2005 to connect to SQL Server 2008. Thanks for your help.
Are you using SQL Server 2005 and SQL Server 2008 in same server. Even though latest version of SQL Server 2008 you can have both versions, there are few issues with SSIS packages.
use this: Cumulative update package 6 for SQL Server 2005 Service Pack 2 support.microsoft.com/kb/946608 you need to get your local SQL server to version SQL Server 9.0.3228 or higher, then it works. I myself used this file: SQLServer2005-KB946608-x86-ENU.exe, but i think its that upgrade )
Hi I had this issue recently (3 years after Zirco post) and I installed SP4 on client machine. I am Now able to connect to 2008 from SSMS 2005. Thanks MohammedU, Thank you all