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 :
; 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
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.