Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

Connect to SQL Server 2005 using Managment Studio 2008

When using SQL Server Management Studio 2008 to connect to a SQL Server running SQL Server 2005, there is a slight compatibility issue to address. The Management Studio 2008 edition is programmed to try to obtain more database information than SQL Server 2005 allows by default. To get around this and to manage your 2005 database using Studio 2008, simply follow these instructions.

Step 1

Open SQL Server Management Studio 2008, and connect to your database as you normally would.

You should receive the following error:

kb-sql2k5-mngmt-2k8-1

Step 2

Click OK to close the error.

Double-Click on the “Databases” folder in the left window.

Click on the “View” menu, and Click on “Object Explorer Details“. Or simply hit the F7 key.

kb-sql2k5-mngmt-2k8-2

Step 3

Right Click on the “Name” column header, and Click on “Collation” to Unselect it.

kb-sql2k5-mngmt-2k8-3

Step 4

Right Click on the “Databases” folder in the Left Window Pane, and Click “Refresh“. You should now be able to view your database in the database list.

kb-sql2k5-mngmt-2k8-4

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.