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 |
|
LoriM
Starting Member
29 Posts |
 Posted - 2005-03-30 : 10:09:44
|
| Hi,I got an EVAL version of RS installed on a test machine with sql server and iis on it. Works great when they're both together.I now want to install it on our ReportServer, which only has iis on it, and point it to our sql server. During the install, when I come to the Report Server Database screen, I choose Domain Account, put in a sql server admin name and password and get the error:"The setup account doesn't have sysadmin rights for the SQL Server instance that hosts Report Server Database." But the logins I'm trying DO have sysadmin rights to sql server.From what I understand, I need to do/have three things:1. Use the built-in account, NT Authority\System for the RS service (suggested in a book I'm using), and ASPNET for the RS Web service2. Sysadmin rights on the sql server box, which I do, and the domain account I want to use to run the services does.3. A domain account that can run the services (ReportServer service and RS Web service)#1 and #3 are where I am confused.The book says if I don't use the built in accounts, I will have to set up sql logins, which I don't want to do.Does this ASPNET built-in account have to be a domain account?What am I misinterpreting!?!?! Please help if you can!Thanks, |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-03-30 : 10:15:09
|
| I may be wrong here, but I am almost convinced that the RS License agreement insists that RS Must be installed on a machine with SQL Server installed on it.It was a long time ago since I was evaluating the product, so I may be wrong, maybe just confirm that first.Duane. |
 |
|
|
LoriM
Starting Member
29 Posts |
Posted - 2005-03-30 : 10:27:38
|
| OK! Now I'm getting somewhere...I've thought of that, but when I run through the prerequisites on the sql server, it says I don't have IIS installed or not configured for a server component installation. I don't want to install iis on this sql server.I'm just diving into IIS configuration, so it's all new to me. I can't find out info on how to configure iis for a 'server component installation'.Does anybody know? I shouldn't have to install IIS directly on my sql server box for the correct licensing, or should I? |
|
|
|
LoriM
Starting Member
29 Posts |
Posted - 2005-03-30 : 11:55:58
|
| OK. I've got it installed on the IIS server.I have local admin rights to the Report Server, given to me by our network administrator.I just added the other user as a local admin on this same machine. I then logged in as this other user and was able to install with that account or from my account.So- it was a just a rights issue from the top down.Thanks! |
|
|
|
Lenham
Starting Member
6 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-30 : 15:55:49
|
| Yep if you install ReportServer on a different server than the SQL Server, you must purchase a SQL Server license for the ReporServer. RS is only free when they are both on the same machine. This isn't an option for larger corporations as having IIS on the database server is a no no.Tara |
|
|
|
|
|
|
|
|
Install Rights questions