Have Geek Brain

Can't create new VS data connection in Server Explorer

I have a local instance of SQL Server 2008 Express running on my development PC. I am trying to create a new data connection via Visual Studio Server Explorer.

The following steps are listed below:

  • Right click the "Data Connections" node => Select Data Source.
  • I chose "Microsoft SQL Server" as the data source.
  • The Add Connection dialog box appears. I select the local server instance => "Test Connection" works fine.
  • I choose "AdventureWorks" because the database name => "Test Connection" works great.
  • Then I click OK => Error message: "This server version is not supported. Only servers up to MS SQL Server 2005 are supported."

I am using Visual Studio 2008 Professional Edition. The target application framework is ".NET framework 3.5". I have a reference to System.Data (framework v2.0) and cannot find another version of the assembly on my system.

Am I referencing the wrong assembly? How can I fix this problem?

+2


a source to share


1 answer


I didn't think about submitting a bug to try and find a fix for this issue. It turns out that it can be easily fixed by installing SP1 for SQL Server 2008.



+2


a source






More articles:


All Articles