We help IT Professionals succeed at work.
Get Started

MSSQL 2005 report services configuration

576 Views
Last Modified: 2012-08-13
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?
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 26 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE