While attending conference SQLAuthority Author Visit – Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are not compatible. When trying myself I got the same error.
SQL Server 2008 when connected to Visual Studio 2008 gives the error that “This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported“.
This error can be easily resolved by just installing Service pack. Download Visual Studio Service Pack 1 and install. Once service pack installed it will connect just fine.
Reference : Pinal Dave (https://blog.sqlauthority.com)
72 Comments. Leave new
Thank you for sharing, that is very useful when you stuck with such message and don’t know what to do.
Having an issue with SQL server 2008 R2
Getting this error “This server version is not supported.Only Up To Microsoft SQL server 2005 are supported” after I create a data connection in Visual Studio 2008 SP1 and SQL server 2008 R2. Any ideas would be great.
No other version of SQL server Installed.
The error occurs after I select server, then database. Just as I click OK I get that message.
Thanks VERY MUCH! I have VS 2008 and VS 2010 installed, was really not looking forward to troubleshooting with multiple installations.
I appreciate this post, will try to remember it in case my student and programming peers run into this problem.
Thanks a lot.
I was so disturbed having this problem and even I reinstalled VS and sql twice,
Once again thanks for the post.
tanweer,
Hi,
I experienced the posted issue, and downloaded and installed the service pack. When trying to add SQL server connection from the Server Explorer,I got the following error:
Unable to add data connection .
The IDBToolsOptionProvider service could not be found.
I cannot find information about this service.
Can you please help?
Thanks,
Shani
Hi,
I experienced the posted issue, and downloaded and installed the service pack. When trying to add SQL server connection from the Server Explorer,I got the following error:
Unable to add data connection .
The IDBToolsOptionProvider service could not be found.
I cannot find information about this service.
Can you please help?
Thanks,
Shani
(Added e-mail notification)
solution to error server explorer unable to add data connection[ tutorial]
Thank you!! Great help…. Worked for me!!!
You ROCK man, never seen any one mastering SQL like you before.
I am a developer, Whenever face any SQL issue and end up in your pages I assure a sigh of relief for myself. I m not surprised today, bcoz this is not the first time ur platinum suggestions have helped. Your suggestions help me without getting much into the details and that is the key for me. For a regular DB guy, it is a tiny thing may be but for the aliens like we developers, it is a nightmare. Bow to the TRUE SQL guru.
I get the same message in visual web developer 2008 express “this server version is not supported only servers up to microsoft sql server 2005 are supported”
any help
Hi
I was previously working on Visual studio 2010. which was having sql server 2008.
but now i want to switch myself to sql server 2005 and want to use Visual studio 2008 with .net framework 2.0.
I installed VS2008(didnt uninstall 2010). but when i try to add database.mdf file in my web application an error occurs which say
“This server version is not supported. Only servers up to Microsoft SQL server 2005 are supported “…
I did check at the time of installation of VS2008 that the setup was installing MS SQL SERVER 2005…
Later i uninstalled VS2008 and VS2010 and reinstall VS2008 and created a new website and try to add database.mdf file but still same problem occurs…..
please, Tell me what should i do…
HI
SIR
i have problem while establish a connection,whenever i used to create database it give an error i.e-
“A network-related or instance specific error occurred while establishing a connectiob to SQL server,the sever was not accessable verify that the instance name is correct and that SQL server is configured to allow remote connections”
plz help me……..
I have a problem while connecting SQL Server, even after entering localhost\SQLEXPRESS it is showing an error-
“Login failed for user ‘-‘.The user is not associated with a trusted SQL Server Connection.”
Can u plz tell me whats the problem?
sir i already downloaded your SP1 upgrade that you recommended but still the error still remains, what should i do??
For which edition of SQL Server 2008 this is applicable ?
Has anyone figured out how to connect visual Studio 2008 to Sql Server 2012?
it doent work for me my visual studio is 2008 and my project is in 2005 my sql server is 2012
hello sir….. when i tried to connect service-base database it shows a error msg that” login failed for user “bhandari\vipin”… plz help me how i can fixed thet problem.. im using win8 and vs 10 and sql 2008
I installed Visual Studio 2008, Service Pack 1 and it didn’t help. Still getting the error
Thank you it’s work :)