The SQL Server 2005 management studio need to be at least SP1 or above. Recommend to upgrade to SP3 (by running SQL Server 2005 SP3 installer) Because there are common issue fixed by CU5 for SP2.
You can use Cumulative update package 5 for SQL Server 2005 Service Pack 2 to upgrade SQL Server 2005 management studio to fix the connection problem of connect to SQL Server 2008.
Reference:
FIX: 50002151 946127 (http://support.microsoft.com/kb/946127/) 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
Remark:
One of the problem of using 2005 management studio to connect to SQL Server 2008
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335534&wa=wsignin1
No comments:
Post a Comment