Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2012-10-23 : 06:49:29
|
| Hi , I tried to create SSRS using VS 2008 professional edition, but while trying to connect to sql server 2012 database i not able to build a query.getting error like "This server version is not supported. Only servers up to Microsoft server 2005 are supported"what I needs to do to rectify this? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-23 : 07:31:38
|
| See if this blog will help you: http://blog.sqlauthority.com/2008/09/21/sql-server-2008-fix-connection-error-with-visual-studio-2008-server-version-is-not-supported/ |
 |
|
|
Anteneh
Starting Member
4 Posts |
Posted - 2012-10-27 : 06:47:29
|
| subhaoviya, I think the most probable cause for this is incompatibility problem of the VS 2008 with SQL Server 2012. U can not even connect to a SQL Server 2008 database. Even that requires you to have VS 2008 with a service pack. It's like trying to open an MS-Office 2007 document on a PC with MS-Office 2003. I am sure it will solve your problem if you upgrade your VS 2008 to VS 2012. Otherwise you'll need to degrade the SQL Server 2012 to SQL Server 2008, even after having VS 2008 with a service pack.URL for VS 2008 SP1 (if you don't have it already): http://www.microsoft.com/en-gb/download/details.aspx?id=10986 (.exe format) http://www.microsoft.com/en-us/download/details.aspx?id=13276 (.iso format)Good Luck! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-27 : 21:20:37
|
| you can create a procedure in SQL 2012 and use it in your 2008 report though so that you dont have to use query builder from SSRS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
query making issue for SSRS