Link to home
Start Free TrialLog in
Avatar of Malog
Malog

asked on

MSSQL 2005 report services configuration

HELLO.
I spend on the following problem three days (downloaded more than 100MB of hints,instructions, many installations, trials etc).

I have in my PC the following configuration:
WIN XP SP3- MSSQL 2005 SP2- IIS 5.1

At MSSQL 2005 reporting services configuration all items are green except INITIALIZATION which is RED.
WHEN I TRY TO MAKE THE INITIALIZATION I GET AN ERROR MESSAGE ABOUT SERVER INTERNAL ERROR.

INFO_1: WHEN I USE THE URL :
http://localhost ; I HAVE THE CORRECT RESPONSE (THE USUAL HELP FILES) means that IIS is OK.

INFO_2: WHEN I USE THE URL :http://localhost/reportserver I get the following error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) : At C:\WINDOWS\system32\Logfiles\W3SVC1 at the Log file the two last lines are:19:53:34 127.0.0.1 GET /reportserver 401
19:53:34 127.0.0.1 GET /reportserver 500

INFO_3: At windows event viewer I see the following message:Event ID:      107
User:            N/A
Computer:      KIKA-34F6BFEA0A
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
 
ANY HELP?
Avatar of QPR
QPR
Flag of New Zealand image

what windows account has been assigned to the reporting services "service"?
Does this account have DB access?
Avatar of Chris McGuigan
I also found that despite the green lights, I had an issue once where the Virtual Directories didn't exist. Pressing the "New" button fixed the issue.

You may have the same sort of issue with the ReportServer database. Just double check it does exist.
Avatar of Malog
Malog

ASKER

Thanks QPR for your response. According your message I tried to connect to ReportServer database thru Database Setup option but without success. Do you think that make Database 'connectable' would help  solving the problem ?
Malog
Avatar of Malog

ASKER

Thnks chrismc . The database exists and there are three users:
KIKA-34F6BFEA0A\ASPNET

NT AUTHORITY\SYSTEM

DBO
Not sure what point you are at but can you connect to the sql server and look for the reportserver database?
Avatar of Malog

ASKER

YES  QPR I CAN connect ... and look for the report server database.
ok now go to control panel - admin tools - services and look for the reporting services service.
Which windows account is it set to run under?
When you find this out, look inside SQL and see if this account has a login and has access rights to the DB.
Avatar of Malog

ASKER

QPR at Services the SQL Server Reporting Services (MSSQLSERVER) has  logon as: local system

AT THE  SQLSERVER the LOGINS are :
BUILTIN\Administrators
KIKA-34F6BFEA0A\ASPNET
NT AUTHORITY\SYSTEM
sa

at DB ReportServer there are the users:
dbo
 KIKA-34F6BFEA0A\ASPNET
NT AUTHORITY\SYSTEM

Thanks for the support
Is the service started?

ok next thing to try is to right click on "my computer" and select "manage"
Go down to services and application and then go to "internet information services"
Expand this and then expand default web site. is there a directory underneath called report server?
If so, can you right click on it and select "browse"?
Avatar of Malog

ASKER

QPR everything was OK until i selected browse: I got the message:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'KIKA-34F6BFEA0A\ASPNET'. Reason: Not associated with a trusted SQL Server connection
Thanks again
ok then you may need to add the asp account to the server/database
CREATE LOGIN [KIKA-34F6BFEA0A\ASPNET] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]

change the default database and language to suit and run this in SQL
Avatar of Malog

ASKER

QPR.
I am cursed:
It keeps sending the message :Incorrect syntax near 'LOGIN'.
Maybe using the Server Management Interface?? (Server-->Security--> Logins..)
ok right click logins (in SQL Server management Studio) and select new login.
Click "search" and then "locations" and select the domain and then type aspnet and then click ok
Avatar of Malog

ASKER

QPR
The Server Login 'KIKA-34F6BFEA0A\ASPNET' already exists (as a windows identification). It's default database is ReportServer.
and the windows service has started?

what users have you got in the report server database?
also, check that tcp/ip protocol is enabled in the sql config
Is this acting as a Domain Controller?
I had a similar problem a while back installing SSRS on a DC!

We did get it working and it was entirely down to the system account ASPNET not being setup automatically.
We set it up by hand in the end but it was tricky.
I can't remember the steps we used.

Here's a start;
http://msdn.microsoft.com/en-us/library/ms159152%28SQL.90%29.aspx

Or try this as it tells you what to do with the ASPNET account;
http://www.informit.com/articles/article.aspx?p=357694
the relevant snippet is;
           
"Installing Reporting Services on Domain Controllers When installing Reporting Services on a Windows 2003 server that is also a domain controller, no manual configuration is necessary for Reporting Services to install and run properly. However, on a domain controller on Windows 2000 Server, while Reporting Services installs properly it is not automatically activated. In this case, you'll need to perform the following steps, either before or after running Setup, in order to properly configure Reporting Services to run on a domain controller:                              
Grant Impersonate Privilege to the IWAM_<machine>account. For more information, see the Knowledge Base Article "IWAM Account Is Not Granted the Impersonate Privilege for ASP.NET 1.1 on a Windows 2000 Domain Controller with SP4" (KB 824308).
             
Remove the IWAM_<machine>account from the Guest group. Guest users cannot store or maintain encrypted content. For more information, see the Knowledge Base Article "Roaming Profiles Cannot Create Key Containers" (KB 265357). Then reboot the computer. "
 
Avatar of Malog

ASKER

QPR at Windows Services the SQL Server Reporting Services (MSSQLSERVER) has  logon as: local system and running

AT THE  SQLSERVER the LOGINS are :
BUILTIN\Administrators
KIKA-34F6BFEA0A\ASPNET
NT AUTHORITY\SYSTEM
sa

at DataBase  'ReportServer'  there the users are:
dbo
 KIKA-34F6BFEA0A\ASPNET
NT AUTHORITY\SYSTEM


About TCP/IP:
SQL Server Configuration Manager (Local)-->SQL Native Client Configuration-->
 Client Protocols-->TCP/IP  Order 2 Enabled

Thanks for the efforts QPR
Avatar of Malog

ASKER

chrismc I do not use the PC as domain controller. It is a PC with WIN XP SP2.
Thanks
True but the fact your ASPNET account was missing, I thought the last bit might help.

Cheers
Chris

Avatar of Malog

ASKER

chrismc
I am wandering how can I know in advance what is the user name who tries to make the connection.
I.E. Where can i find that the user 'KIKA-34F6BFEA0A\ASPNET' will run the browse command at KIKA-34F6BFEA0A-->DEfaultWebSite  -->ReportServer ?
Thanks
ASPNET is used to run some of the background stuff, I'm not sure exactly what though.

This is not much help to you I know.

You really need someone with good Networking/Security knowledge to help here.

ASKER CERTIFIED SOLUTION
Avatar of Malog
Malog

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I wouldn't try SQL 2005 with Vista.
In fact I wouldn't try Vista at all :)

I had a nightmare with SQL 2005 Express on someone elses Vista machine.
We never did get it working, we went to SQL 2008 instead.

Avatar of Malog

ASKER

chrismc I am talking about MSSQL 2K5 Developpment edition and Vista -->IIS 6
Anyway my clients usually use Vista.