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 (http://www.SQLAuthority.com)
pinaldave
Thanks for Link, But there is one problem. Its download the installer in seconds, but installing needs much time, as its downloading 4GM from live site, which is I believe not good. Any other link where I can get the exe?
Imran
[MCTS]
Hello Imran,
I have tried to look for other link where complete SP can or other patch can be downloaded but I found none.
If any body know solution about this please post it here.
Kind Regards,
Pinal
Hi Imran,
Here is the URL for Visual Studio 2008Sp1 in iso format, so you don’t need to wait until it gets downloaded. Hope this will help you.
http://www.microsoft.com/downloads/details.aspx?FamilyID=27673c47-b3b5-4c67-bd99-84e525b5ce61&displaylang=en
Vidya Vrat Agarwal.
MCPD, MCTS, MCT, MCSD.NET, MCAD.NET and MCSD
hi there!
maybe i’ve found another issue:
said that: debugging T-SQL SP without parameters works properly, then all the security issues etc. .. are OK.
said that thanks in advance if you will answer ..
said that this time I want to call into question whether some MVP is listening ..
this is the problem and steps to reproduce the behavior:
1. Visual Studio 2008 SP1 connected to a database that runs on SQL Server 2008 in a machine other than mine (level 8.0 compatibility, as it is plugged into a db in 2000)
2. click on a sp with parameters (of any user defined types) and as usually select the “step into stored procedure”
3. debugging of stored procedures does not start, and in the output appears :
Running [dbo]. [RRintracciaDatiDaDocumentoPM31] … (@ UserName = admincapa, @ PWD = admincapa, @ IDDocumento = 262155, @ IDTestata = -1).
Incorrect syntax near the keyword ‘SET’.
Incorrect syntax near ‘,’.
Incorrect syntax near ‘,’.
Incorrect syntax near ‘,’.
Incorrect syntax near ‘,’.
Declare the scalar variable “@ param1″;.
(0 rows returned)
@ = RETURN_VALUE
Running [dbo]. [RRintracciaDatiDaDocumentoPM31] complete.
The thread ‘hydrogen \ idrogeno2008 [64]‘ (0xbd8) ended with code 0 (0×0).
The program ‘[2268] [SQL] hydrogen hydrogen \ idrogeno2008′ ended with code 0 (0×0).
Note that I did not @ None Var1 in my stored.
so, is it a bug in visual studio??
have a nice day!
[...] 5, 2008 by pinaldave I previously wrote article SQL SERVER - 2008 - Fix Connection Error with Visual Studio 2008 - Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 [...]