Visual studio - Data connection issue

Hi,

I have VS2005, and making a crystal report.

I am trying to create a Data Connections in VS, when i add connection and put the login, everything works fine, i can see the SQL server name etc.

But when i click on 'OK', VS gave me error:
"This server version is not supported. You must have Microsoft SQL Server 2005 Beta2 or later"

Please advise,
Tommy
hongclubAsked:
Who is Participating?
 
rgn2121Connect With a Mentor Commented:
Also, do you have Standard or Professional VS?  Looks like you might need the following, although I don't know the versions of software you are using yet.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en
0
 
rgn2121Commented:
What version is the SQL Server?
0
 
rawinnlnx9Commented:
Get the latest service pack for SQL Server 2005 (I believe it's SP2.) and install that on your SQL Server. Then make sure you have the latest service pack for Visual Studio as well.

It's sounds to me like you have incompatible versions of tools that you are using. So update both Visual Studio and SQL Server. That should fix it.
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
hongclubAuthor Commented:
i have vs 2005 professional, and i have SQL server 2008 R2 in the production server.

I can't upgrade that SQL server, it is my company server, everyone is using it.
any suggestion ?

Tommy
0
 
rgn2121Commented:
Sounds like what I posted above...Here is the KB...
http://support.microsoft.com/kb/954961
0
 
hongclubAuthor Commented:
hi rgn2121,

your solution rocks, after i installed this update:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en

it works!!!

Tommy
0
 
rgn2121Commented:
Great news!  Happy to help...!  Please close this when you get the chance...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.