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\Logfil es\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?
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\Logfil
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?
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.
You may have the same sort of issue with the ReportServer database. Just double check it does exist.
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
Malog
ASKER
Thnks chrismc . The database exists and there are three users:
KIKA-34F6BFEA0A\ASPNET
NT AUTHORITY\SYSTEM
DBO
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?
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.
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.
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
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"?
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"?
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. (rsReportServerDatabaseUna vailable) Get Online Help
Login failed for user 'KIKA-34F6BFEA0A\ASPNET'. Reason: Not associated with a trusted SQL Server connection
Thanks again
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUna
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_engli sh]
change the default database and language to suit and run this in SQL
change the default database and language to suit and run this in SQL
ASKER
QPR.
I am cursed:
It keeps sending the message :Incorrect syntax near 'LOGIN'.
Maybe using the Server Management Interface?? (Server-->Security--> Logins..)
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
Click "search" and then "locations" and select the domain and then type aspnet and then click ok
ASKER
QPR
The Server Login 'KIKA-34F6BFEA0A\ASPNET' already exists (as a windows identification). It's default database is ReportServer.
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?
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. "
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. "
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
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
ASKER
chrismc I do not use the PC as domain controller. It is a PC with WIN XP SP2.
Thanks
Thanks
True but the fact your ASPNET account was missing, I thought the last bit might help.
Cheers
Chris
Cheers
Chris
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-->DEfaultW ebSite -->ReportServer ?
Thanks
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-->DEfaultW
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.
This is not much help to you I know.
You really need someone with good Networking/Security knowledge to help here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
chrismc I am talking about MSSQL 2K5 Developpment edition and Vista -->IIS 6
Anyway my clients usually use Vista.
Anyway my clients usually use Vista.
Does this account have DB access?