Solved

Visual studio - Data connection issue

Posted on 2011-02-15
7
383 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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