INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database

Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database

Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database

(OP)
I'm trying to set up Reporting Services on a win 2008 R2 server, talking to a MS SQL 2008 R2 backend SQL server

I keep getting the error
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database
in the log file

I have the following set up in Reporting Services Configuration Manager
eportServer Instance MSSQLServer (which when connection clicked connects ok)
Server Account Network Service
Database Credential Service Account NT Authority\NETWORK SERVICE
If I click on change credentials I get
Authentication type Current user - Integrated Security\NETWORK SERVICE
and clicking on the test connection gives success
Clicking next shows Server Credential NT Authority

I have no execution account set up

Looking under services the SQL Server (MSSQLSERVER) service is also using
NETWORK SERVICE

The links are
Report Manager http://<server name>:80/Reports
Web Server http://<server name>:80/ReportServer
where <server name> is the name of my server

So I'm at a loss what I'm doing wrong, but am getting this error both on a local test VM (where web site and SQL servers are running on the same VM) and on the liuve site, where the web server talks to another server with the backend SQL database on it

If anyone can help I would be grateful

Andy

RE: Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database

Is all of this on one single machine?

What does the SQL Server (database engine) errorlog show for login failure messages (should be on by default)?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close