Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

On a single Windows 2008 Server I'm running SharePoint 2007 Enterprise (SP2, December 2009 CU) and SQL Server 2005 (SP3, CU 7). Authentication is NTLM. I've been trying to get SharePoint Reporting Services integration to work without success.

The Reporting Services configuration tool has all ticks. It is possible to browse to the ReportServer IIS directory and see a list of SharePoint sites. The Reporting Services URL has been set within Central Administration.

When I fill in the "Grant Database Access" form with a user account and click OK, the following message displays: 'A connection to the computer cannot be established'. There is no error logged to the ULS logs or the Reporting Services logs about this.

I've tried:

  • a complete uninstall and reinstall both SQL Server and SharePoint (as it is impossible to only uninstall the Reporting Services component with SQL Server 2005)
  • used the same service account for all SQL services and the same for all SharePoint services
  • given all service accounts domain administrator and local administrator permissions
  • enabled Named Pipes and TCP/IP networking within SQL Server
  • followed Troubleshooting Server and Database Connection Problems

... all to no success! Ideas?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

The solution that worked was to turn off UAC as mentioned in this forum post.

As that poster mentions, it would be great to know how to do this without turning off UAC.

Another resource: Troubleshooting Integration with SQL Server 2005 and Microsoft SharePoint Technologies.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.