SQL Server 2008 & VS 2005 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

SQL Server 2008 & VS 2005

Author

Topic

godistop1
Starting Member

14 Posts

Posted - 2011-08-23 : 17:34:06

I am trying to add a report to ASP.Net application. The data is coming a SQL Server 2008 and using VS 2005. I keep getting this message when trying to create data connection.

quote:
Failed to open a connection to the database

"This server version is not support. You must have Microsoft SQL Server 2005 Beta 2 or later."

Check the connection and try again.

I do not understand since I am using SQL Server 2008.

Thanks for any help!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-24 : 01:53:51

you might be using only sql 2008 client tools. run below query and post the result

SELECT @@VERSION

EXEC sp_dbcmptlevel 'your dbname'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

godistop1
Starting Member

14 Posts

Posted - 2011-08-24 : 09:58:35

Here is the result of the above query

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   
Mar 29 2009 10:11:52   
Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) (VM)

Kristen
Test

22859 Posts

Posted - 2011-08-24 : 10:50:44

EXEC sp_dbcmptlevel 'your dbname' ??

You should get something like:

"The current compatibility level is 100."

godistop1
Starting Member

14 Posts

Posted - 2011-08-24 : 11:07:50

I solve the problem, went to this website and download the update for VS 2005.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15680

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-24 : 12:23:00

cool

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources