cannot be opened because it is version 655. This server supports 612 and earlier

Question

cannot be opened because it is version 655. This server supports 612 and earlier

ssurekha2000

SSCommitted

Points: 1860
More actions
January 31, 2014 at 8:48 am

#303968

i had version 2008 r2 in which i had create the db
i had to uninstall and then resinstall , when installing i saw it was 2008 r2 version
when i am trying to attach the same db i get the above error
i reinstalled it twice still the same
any solution

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Keith Tate SSCrazy Eights Points: 9938 More actions · Answer 1

Are you sure that you didn't install 2005 by mistake? Seems like you are trying to open a 2008 mdf file in 2005. Run this command to verify your instance: select @@VERSION

Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Lowell SSC Guru Points: 323518 More actions · Answer 2

you can never restore a higher version db to a lower version;

looks like your db is 2008 but you are installing/using SQL2005. check to see if you installed an isntance, but connected to the default server instead.

The internal database versions for SQL aren't documented in the Books Online. However, thanks to Paul Randal (@PaulRandal) and his Q&A article in TechNet we have the following list:

SQL Server 7.0 databases have version number 515

SQL Server 2000 databases have version number 539

SQL Server 2005 databases have version number 611/612

SQL Server 2008 databases have version number 655

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ssurekha2000 SSCommitted Points: 1860 More actions · Answer 3

i have 2005 also installed

and 2008 r2 both

when i am trying to connect i get 2 server names in the dropdown

1) local

2) systemanme/sqlexpress which is 2005

when i use systemanme/sqlexpress i am able to connect

but when i use local i am not able to connect

error

TITLE: Connect to Server

------------------------------

Cannot connect to (local).

------------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

ssurekha2000 SSCommitted Points: 1860 More actions · Answer 4

sql2008r2 instance was installed as a network server

when selected the 2008r2 from network server and attached the db it worked

how do i make it as a local server

on a standalone system whts the difference between local & network

does it make any difference