Geek Answers Handbook

Visual Studio 2005 does not support Sql Server 2008

I am developing Reporting Services on VS2005 and must connect to SQL Server 2008. The following error occurred: "This version of the server is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."

I found a patch for it on the network, but it does not work ( link to the patch )

"The update patch cannot be installed by the Windows Installer service because there is no update to the program, or the update may update another version of the program."

what else can i do ?: (

+6
sql sql-server reporting-services
source share
6 answers

Reporting Services is very different between 2005 and 2008. You will need to use the 2008 tools to develop the 2008 reports. You can simply use the Business Intelligence Studio that ships with SQL Server 2008 — it uses Visual Studio 2008 anyway. I am sure that the patch does not support SQL Server Reporting Services 2008.

If you need to use reports from Visual Studio 2005, you need to use SQL Server Reporting Services 2005 (in fact, this can be installed with SQL Server 2008). I had a separate issue, which means that my reports will not work in SSRS 2008, but I switched to SQL Server 2008. I successfully run SSRS2005 connecting to the SQL2008 database.

+4
source share

Just got this error message and was able to get rid of it by clicking the Generic Query Designer button: enter image description here

+8
source share

I wanted to add to this a convenient workaround that I found if you are in a specific situation. In fact, you can use Visual Studio 2005 and generate SSRS 2005 reports and still retrieve SQL 2008 data. You can do this as long as you have one server in the environment where SQL 2005 is running.

You just need to create a linked server for 2008 servers. Then, in SSRS, you create one data source on your 2005 server, but refer to the 2008 server associated with it in your request, and it will work. For example, if you had an SQL 2008 server called Chicago and an SQL 2005 server called Detroit, you would create a linked server in Detroit for Chicago, and you would create a data source in Visual Studio 2005 for your report that would point to Detroit. Then, in your query, you will only have something like SELECT * FROM Chicago.Database.dbo.Table, and it should work.

Obviously, you probably want to completely switch to the 2008 environment, but this is a good thing to know for the conversion phase.

Hope this helps.

+1
source share

You may want to reinstall

0
source share

Finally, I installed SQL Server 2005

0
source share

Just in case, when someone encounters this, my problem was that the user software that runs ssrs reports only supports ssrs 2005 reports and also uses sql 2008 database, so I could not upgrade to BIDS 2008 .

I managed to run the patch in the ops link after I installed Visual Professional 2005 Professional and then installed 2005 on it.

It seems that sql 2008 patch does not select rates for 2005.

0
source share

More articles:


All Articles