October 19, 2008 at 3:58 pm
Hi all,
This is driving me nuts and I can't figure it out. I'm installing a new instance of SQL 2005 (there's currently one instance installed) on Windows Server 2008. For some reason, the reporting services option is greyed out meaning I can't install it. I went and checked the existing instance and noticed it wasn't installed on there either. Did some surfing on the net and the articles I came across stated I needed II7 and IIS 6 compatibility tools installed. Ok so I do that and still the same thing. Another article stated I needed Service pack 2. Went to MS site and downloaded that and still the same.
Can anyone tell if I missed anything?
Also, I have SQL 2008 on this server as well. Don't think this is affecting the install but thought I'd state that in case it is.
Thanks,
Strick
October 20, 2008 at 2:46 am
Here are some instructions for configuring IIS:
Before installing Reporting Services, you must enable ASP.NET and IIS. To enable these features, configure a server role:
Click Start.
Click Server Manager at the top of the Start menu.
Right-click Roles, and select Add Roles.
On the Select Server Roles page, click Web Server (IIS). Selecting the Web Server role also selects File Server as role dependency. Click Next.
In the Role Services page, keep all the items that are selected by default, and then add the following additional items:
In Common HTTP Features, select all the items in this section.
In Application Development, select ASP.NET. You will be prompted to enable dependent services. Click OK to add the required role services.
In Security, select Windows Authentication.
In Management Tools, in IIS 6 Management Capability, select all the items.
Click Next, and then click Install.
This is taken from http://msdn.microsoft.com/en-us/library/bb839480(SQL.90).aspx?ppud=4.
I think the key element is having Windows Authentication enabled, because this is where I tripped up in trying to install SSRS on Vista (I have the Premuim edition which doesn't have this option, so I can't install it). Once IIS is configured as above you should be able to work through the wizard to install Reporting Services. The article above should help with that too.
October 20, 2008 at 7:15 am
Hi all,
Figured it out. IIS was installed but server 2008 is very picky about which options need to be checked marked. Once I checked marked these options, I was the reporting services option wasn't greyed out.
Thanks,
Strick
October 20, 2008 at 7:29 am
Actually, it is not very picky... It is simply running IIS7 and does not know if you want it to run IIS6 compatability mode without checking these options 🙂
Glad you could figure it out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply