I've received an error message when connecting to my SQL 2005 database with SQL 2008 Management Studio.

Language

Home>Knowledge Base>Web Hosting>Databases>I've received an error message when connecting to my SQL 2005 database with SQL 2008 Management Studio.

Information

Article ID	108
Created On	4/24/2009
Modified	4/24/2009

Actions

Print this Page

Add Favorite

I've received an error message when connecting to my SQL 2005 database with SQL 2008 Management Studio.

This is an annoying bug in SQL 2008 Management Studio. Luckily there's an easy fix. After you receive the error message click okay. Then, in the right hand pane of Management Studio right click on the name column and clear 'collation'. Go back to the left pane, click on databases and hit F5 to refresh the listing. That should fix the problem for you. If this doesn't resolve your issue please let us know.

There are two bugs logged with Microsoft regarding this issue. If you're interested you can read more about the issue at the following URLs:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354291
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=321565