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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-09-03 : 19:23:25
|
| Hi thereWe've an environment that is using the Reporting Services. The reporting services was installed into dedicated database box and the web was installed into the application server.Now I want to have another web installed (totally different from the current one) and want to utilise the current database server. So my question is:* I heard from the instructor that you can have another databases for ReportingServices and ReportServiceTempDb? If this one is possible, that will be great cause I don't want to have a seperate instance of Reporting Services.* If this one can't, what my option is?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 21:50:57
|
| You can use same sql server, but should create another set of dbs for new RS service. |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-09-03 : 22:00:37
|
| So you could do the having another set of database for reporting services in the same box as original reporting service. Just want to confirm. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 22:04:31
|
| Yes. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-05 : 16:46:00
|
Also, multiple reporting services is not supported for standard edition. Just FYI.
Future guru in the making. |
|
|
|
|
|
|
New Reporting Services