>>Install Management Studio Express 2008
>>
>>>I recently installed Visual Studio 2010, which included some SQL 2008 components.
>>>
>>>Now when I try to connect to SQL 2005 I get:
>>>
>>>"This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)"
>>>
>>>If I try to browse for servers, there are none listed under the Local Servers tab, yet the services console show SQL Express running.
>>>
>>>Before the VS2010 install, I had no problems with SQL.
>>>
>>>Anyone?
>
>
>I had SQL 2005 Express installed. I removed it and installed SQL 2005. Now I get the message:
>
>"The database 'Spares' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported. Could not open new database 'Spares'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
>
>This is upsurd. Both are SQL 2005. Is there any way top attach this DB???
I suggested to install SQL Server 2008 Express. I believe 655 is SQL Server 2008 database.
If it's not broken, fix it until it is.
My Blog