Solved

Visual studio - Data connection issue

Posted on 2011-02-15
7
381 Views
Last Modified: 2013-11-26
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
0
Comment
Question by:hongclub
  • 4
  • 2
7 Comments
 
LVL 12

Expert Comment

by:rgn2121
ID: 34899499
What version is the SQL Server?
0
 
LVL 9

Expert Comment

by:rawinnlnx9
ID: 34899516
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
 
LVL 12

Accepted Solution

by:
rgn2121 earned 500 total points
ID: 34899585
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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:hongclub
ID: 34899705
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
 
LVL 12

Expert Comment

by:rgn2121
ID: 34899813
Sounds like what I posted above...Here is the KB...
http://support.microsoft.com/kb/954961
0
 

Author Comment

by:hongclub
ID: 34899890
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
 
LVL 12

Expert Comment

by:rgn2121
ID: 34906117
Great news!  Happy to help...!  Please close this when you get the chance...
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now