none
Visual Studio 2005 and 2008 connecting to SQL SERVER 2008

    Question

  • Hi,

    I have been experiencing a problem with connecting to SQL SERVER 2008 (running on a Windows Server 2008 R2 enviroment) from Visual Studio 2005 and 2008 (running either on XP or Windows 7, both tested). Everytime i need to connect a or create a sqldatasource i get an error saying " This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later". I first noticed that in the "New Connection" wizard on Visual Studio the database instance name is no longer giving me "MYSERVERNAME" but it is now giving me "MYSERVERNAME\SQLEXPRESS" which was not the case before. Please hel me with this as i have tried installing services packs but none of them work.

    Thursday, April 12, 2012 2:01 PM

Answers

All replies

  • Open the Services MMC snap in and scroll down to SQL Server Database Engine in the list.  Is there more than one entry?  If so, you might have both express and standard installed. 

    Thursday, April 12, 2012 2:05 PM
  • Hi MFunkshins,

    The SQL Server 2008 support update for Visual Studio 2005 has the prerequisites of Visual Studio 2005 SP1 and .NET Framework 2.0 SP1 being installed. The SQL Server 2008 support update CTP for Visual Studio 2005 can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf.   

    The SQL Server 2008 support update CTP for Visual Studio 2008 is no longer available. SQL Server 2008 support is available in Visual Studio 2008 Service Pack 1.

    Connecting to Microsoft SQL Server 2008 from Microsoft Visual Studio 2005 and 2008: http://msdn.microsoft.com/en-us/library/cc440724(v=VS.90).aspx.


    Thanks,
    Maggie

     


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    Monday, April 16, 2012 4:30 PM
    Moderator