problem with visual studio 2008 databases

Discussion in 'Visual Studio' started by Izzy123, Sep 19, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Izzy123

    Izzy123

    Hi, I'm new to VS 2008. And as a uni project, we had to create a doctor surgery databases as a group. However, when one of my group member sent me part of her work and when I tried to open it in my VS 2008, I failed to open the database she created. The error was : " [the database] cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported."

    I did some research on the Internet and found out that I have SQL server 2005 installed and my friend is probably using SQL server 2008. So I download the SQL server 2008 from the Internet and it was successfully installed in my computer. So now I have both SQL server 2005 and 2008. However when I tried to open the database again, another error occured saying : "This server version is not supported. Only server up to MS sql server 2005 are supported." again I did some research on the Internet and people are saying I have to install the SQL server 2008 SP1 for it to work. But when I'm about to proceed to the installing process, an error appear saying: "there are no sql server instances or shared features that can be updated on this computer". Then my friend emailed me and said she can download SQL server 2005 and send the file again, so I removed the SQL server 2008, but then my Visual Studio 2008 won't open any databases, not even the ones i created with SQL server 2005.

    The error is: "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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)". Anyone please help?
     
    Izzy123, Sep 19, 2010
    #1
  2. PJ2010

    PJ2010

    That sounds nasty. I'm no expert, and double check with others, but I think you should remove the SQL server 2005 and reboot, keeping only SQL server 2008. I notice different versions of Microsoft products (including Visual Studio) don't play nice with one another.
     
    PJ2010, Oct 15, 2010
    #2
  3. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    Some suggestions

    It's been a while since I've used VS2008, but here are a couple of things to try:

    1) In the Database Explorer window, under Data Connections, clear all entries involving the database in question. You may have an invalid connection string. Try setting up a new connection.

    2) Make sure the SQL server instance is running. You can check this in Administrative Tools -> Services.
     
    RayH, Jan 10, 2011
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page