Ok I'm am going through a rather painful experience of installing Reporting Services on:
Windows 2000 SP4
MDAC 2.8
.Net Framework 2.0
IIS 5.0
SQL Server 2005 Developer
I have installed RS 2005 on Windows 2003, and seen it installed on XP no problems. However this is a nightmare.
RS goes ahead and installs - note that there is no Network/Local service option on the service accounts just Local system or the domain account option. I have tried using the Local system and tried using the NT AUTHORITY/SYSTEM.
After the installation I go to the Reporting Services Configuration Tool, where I have crosses on:
- Server Status
- Report Server Virtual Directory
- Report Manager Virtual Directory
- Web Service Identity
- Database Setup
I- nitialization
So I go to report server/manager and click on "New.." on each to create the virtual directories and check "apply default settings" and click "Apply", all goes well
Web Service Identity I cannot change so I go to:
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config
and change the web service account to:
<WebServiceAccount><<MACHINE NAME>>\ASPNET</WebServiceAccount>
When I restart the reporting services service I no longer see a warning in the reporting services log file about the WebServiceAccount
I go back to the Reporting Services Config Tool, where I have crosses on the following:
Web Service Identity
Database Setup
Initialization
The Web Service Identity stays greyed out...
I go to Database Setup:
connect to the server
select the reportingserver database
leave it set as service credentials
Click "Apply"
and I get the most vague of all error messages:
"There was a failure applying your change
A virtual directory must first be created before performing this operation"
What virtual directory, where?
I look in the log files..nothing. I look in the event viewer...and...nothing.
I look on here...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=628231&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682492&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=493194&SiteID=1
Either unanswered or there is the one answer but it is not relevant in this case.
Can someone please provide some advice before I lose my sanity?
Thanks in advance
Ok since I got no responses, after trial and error I found that the following process worked....
1. run SQLSERVER2005 setup from the command line with setup SKUUPGRADE=1
2. Install RS
3. open the RS config tool, create the virtual directories for server/manager
4. run rsconfig -c -s <SQLSERVERNAME> -d <<RS DB Name>> -a Windows from the command line (for a service account) see http://msdn2.microsoft.com/en-us/library/ms162837.aspx for more.
5. Edit the rsreportserver.config file add the WebServiceAccount <WebServiceAccount><<MACHINE NAME>>\ASPNET</WebServiceAccount>
6. Add ASPNET to the group SQLServer2005ReportingServicesWebServiceUser$<<INSTANCE_NAME>>
7. Give ASPNET or the above group acess to the RS DB
8. Add administrators as Content Managers via either the browser localhost/reports or in SQL Server Management Studio
9. Reboot
I have no idea why the RS configuration tool does not perform in the same way as the command line rsconfig? But running it from the command line fixes the problem
No comments:
Post a Comment