{"id":945,"date":"2013-05-27T13:40:22","date_gmt":"2013-05-27T03:40:22","guid":{"rendered":"http:\/\/howden.net.au\/thowden\/?p=945"},"modified":"2013-05-27T13:40:22","modified_gmt":"2013-05-27T03:40:22","slug":"adding-ssrs-reporting-services-to-an-existing-sql-2008-instance","status":"publish","type":"post","link":"https:\/\/howden.net.au\/thowden\/2013\/05\/adding-ssrs-reporting-services-to-an-existing-sql-2008-instance\/","title":{"rendered":"Adding SSRS Reporting Services to an existing SQL 2008 Instance"},"content":{"rendered":"

Trying to add Reporting Services to an existing database instance and when I select the instance in the SQL installer Reporting Services is not an option.<\/p>\n

http:\/\/stackoverflow.com\/questions\/6987741\/cannot-add-reporting-services-to-an-existing-instance-of-sql-express-2008<\/a><\/p>\n

3 Years ago this question was raised and there is still no answer. Why? Because there is a trick to all of this.<\/p>\n

So what is the issue that prevents an instance of SQL Server Express 2008 from having Reporting Services added as a feature?<\/p>\n

Simple. The installed instance is not the same version as the installing version being used to add the feature.<\/p>\n

Using, for example as I was, a server with multiple instances, SQL Express 2008 R2 Advanced, the Reporting Services feature was not available for the instance that I wanted to add it to.<\/p>\n

Installing a new instance worked fine as I tested this to make sure. This meant that it was not a service prerequisite that was missing.<\/p>\n

Using http:\/\/stackoverflow.com\/questions\/141154\/how-can-i-determine-installed-sql-server-instances-and-their-versions<\/a>\u00a0to get the following query:<\/p>\n

[text]<\/p>\n

<code>SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)<\/code><\/p>\n

[\/text]<\/p>\n

Check each instance for its version. In my case I got<\/p>\n

Original instance that will not accept Reporting Services\u00a0showed as 10.50.4000.0\u00a0SP2\u00a0Express Edition (64-bit)<\/p>\n

and<\/p>\n

The newly installed instance with SSRS showed as 10.50.1600.1\u00a0RTM\u00a0Express Edition with Advanced Services (64-bit)<\/p>\n

Checking at http:\/\/blog.sqlauthority.com\/2013\/01\/18\/sql-server-a-list-of-various-sql-server-rtm-and-service-pack-number\/<\/a>\u00a0for the list of SQL editions I get:<\/p>\n\n\n\n
SQL Server 2008 Service Pack 2<\/td>\n10.00.4000.00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

and<\/p>\n\n\n\n
SQL Server 2008 R2 RTM<\/td>\n10.50.1600.1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ok, so what to do about it?<\/p>\n

Upgrading a single instance of SQL does not appear to be an option, at least I could not find a way to do so, when the server already had other instances with the later version.<\/p>\n

In any case, the outcome was to install a fresh instance for the application with Reporting Services.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Trying to add Reporting Services to an existing database instance and when I select the instance in the SQL installer Reporting Services is not an option. http:\/\/stackoverflow.com\/questions\/6987741\/cannot-add-reporting-services-to-an-existing-instance-of-sql-express-2008 3 Years ago this question was raised and there is still no answer. Why? Because there is a trick to all of this. So what is the issue […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-945","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/comments?post=945"}],"version-history":[{"count":0,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/945\/revisions"}],"wp:attachment":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/media?parent=945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/categories?post=945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/tags?post=945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}