July 19, 2011 at 7:14 am
We already have a robust SQL cluster, and we do not want anything else unnecessary installed on those machines, such as SSRS. But we do want to put the SSRS databases onto the cluster.
We also have another server dedicated to Reporting Services. So we want to install the SSRS services on the stand-alone server, and the SSRS databases on the cluster.
Can this be done?
July 19, 2011 at 7:15 am
yes
---------------------------------------------------------------------
July 19, 2011 at 7:23 am
george sibbald (7/19/2011)
yes
Thanks! Care to share how?
July 19, 2011 at 7:37 am
jpSQLDude (7/19/2011)
george sibbald (7/19/2011)
yesThanks! Care to share how?
open reporting services configuration manager and when setting the SSRS instance details a set of database connection options are there, simply point to an accessible remote server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2011 at 8:06 am
Perry Whittle (7/19/2011)
jpSQLDude (7/19/2011)
george sibbald (7/19/2011)
yesThanks! Care to share how?
open reporting services configuration manager and when setting the SSRS instance details a set of database connection options are there, simply point to an accessible remote server
what perry said, just specify the virtual SQL cluster name when you configure the databases.
You didn't ask how, just if it was possible. 🙂
---------------------------------------------------------------------
July 19, 2011 at 8:29 am
Furthermore, please see my attached WIKI (in .doc format) detailing how to install, patch and configure an SSRS2005 instance 😉
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2011 at 10:32 am
OK, that worked, with some issues, of course...
I got a couple of test servers. On Server 1 I installed SQL 2005 database engine, and upgraded to SP4.
On Server 2 I could not install SSRS because IIS was not installed. So I installed IIS, then SSRS, then upgraded to SP4.
The configuration was as y'all said -- during the SSRS configuration there is the option to point to a SQL server, so I just pointed to Server 1, and that worked great.
Until I tried to browse the website and got this error...
The current identity zzzzzzz does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files'.
After much googling, it turns out if you install IIS after the .NET Framework is installed, permissions get messed up. Here are a couple of relevant articles...
How to repair IIS mapping after you remove and reinstall IIS
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306005
You cannot install SQL Server 2005 Service Pack 2 on a computer that is running SQL Server 2005 Reporting Services after you install the .NET Framework 2.0
http://support.microsoft.com/kb/934652
The fix looks something like this...
C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -iru
All seems to be working now...
July 19, 2011 at 3:33 pm
good stuff, thanks for posting back
---------------------------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply