Home / server / Questions / 30346
Accepted
Kieran
Asked: 2009-06-24 06:42:34 +0800 CST

Configuring MOSS and Reporting Services on a Domain Controller

  • 772

I'm working on a pretty standard MOSS virtual development environment. I have MOSS, sql 2005 and the machine is also the Domain Controller.

I'm now doing some work with Reporting Services (SSRS) and integrating it with MOSS.

I therefore installed SP2 to give me the option in SSRS of SharePoint integrated mode. I also installed the SSRS Add-In for SharePoint.

Then in SSRS I chose to create a new database so that I could tell it to use SharePoint integrated mode and called it reportservermoss, as reportserver had previously been used. I created this and chose all the defaults with integrated authentication.

I then began to configure the SharePoint side of things in Central Administration. Under Grant Database Access I tried to enter the local admin account, this failed until I found this post pointing out a bug, so I changed the servername to it's IP Address and it allowed me to continue.

So I think all is fine. I choose Set Server Defaults in Central Admin and get a large page of html/nonsense beginning:

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

There's nothing in the logs.

Has anyone else had this issue?

sql-server sharepoint domain-controller ssrs

3 Answers

  1. Best Answer

    The problem seems to be a known bug when your using the local admin account to make the connection between reporting services and MOSS. I had to use the static ip address of the server and then enter the local admin account and password when prompted in Grant Database Access Page.

    I then stopped and started the windows sharepoint Services service under operations > services.

    Then IISReset.

    This seemed to do the trick.

    Hope this helps someone else get around this.

    Any further thoughts on this topic appreciated.

    • 1

  2. First off, you're on a Domain Controller so there is no Local Admin account. Secondly, any SharePoint install on a DC is well known to be fraught with difficulty. I think that even if you do find a solution for your current problem, there will be other problems in the future.

    • 0

  3. You said that you used the IP address of the machine to connect reporting services. Did you use 127.0.0.1? Do you have a static IP address? Otherwise it could have been that your IP address changed and that the IP you entered in is no longer valid.

    • 0