January 7, 2009 at 12:14 pm
Hey guys!!
I was wondering if someone knows how to configure the virtual directories of reporting services in a different server where the sql server was installed.
Doing my test I already created all the steps and my Reporting Services is up and running in my development enviroment, but my problem is that for production enviroment I need to separate the database from IIS service for security issues in the company I work for.
Can any one help me!
I already searched in different sql books and forums without success, they only explain how to configure with the default website.
Thanks!
January 7, 2009 at 12:35 pm
If I am following you correctly, you want to run reporting services an one server and have the ReportingServices and ReportingServicesTempDB databases on another server.
This is pretty easy, actually. On the server you want to run reporting services, run the SQL installation and just install the reporting services component. Once installed, you can go to the reporting services configuration and open the database section. From here, you can configure the server on which it should create the RS databases.
Look at the second topic listed here:
http://msdn.microsoft.com/en-us/library/ms143757(SQL.90).aspx
January 7, 2009 at 1:49 pm
🙂 Thanks!!
As you said it's easy, I did it and It's working now
Thank you again Michael
Joe
January 7, 2009 at 4:52 pm
Make sure you license it correctly. You need to buy the appropriate MSSQL Server licenses for BOTH servers.
January 7, 2009 at 7:00 pm
Thanks for the advise, so if I only install the reporting services on a server do I need a full sql server license?
Joe
January 8, 2009 at 4:32 am
Yes.
Read the licensing information on the MSDN website.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply