Grant Database Access for Reporting Services: A connection to the computer cannot be established

Alex Angas
  • Grant Database Access for Reporting Services: A connection to the computer cannot be established Alex Angas

    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?

  • 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.

Related questions and answers
  • 22: The Forefront Identity Manager Service cannot connect to the SQL Database Server. This error now only exists once in the logs. The User Profile Sync service is now stuck at starting rather than... attempting to start and run the UPS Sync) and eventually fails: Error ID: 22 - The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted... incorrectly. Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active

  • as the central admin db access account has access to the config database (I have admin access so can check this) but I cannot ascertain if it has access to the existing admin content database... SharePoint_AdminContent_1c2efc32-a7c8-4e97-93d6-447c3ea5cd29 server XXXXXXXX\lob 05/05/2010 09:43:45 8 INF Using NTLM for sql connection string 05/05/2010 09:43:45 8 INF Openning configdb so that I can join it at server XXXXXXXX\lob database XXX_SharePoint_Config in farm mode 05/05/2010 09:43:45 8 INF Now joining to farm at server XXXXXXXX\lob database XXX_SharePoint_Config

  • without any particular rights: SPF_DATABASE for database credentials SPF_ADMIN for farm credentials Added domain administrator in SQL Server 2008 R2 with sysadmin rights started Sharepoint Powershell as domain administrator (so I have rights to access domain accounts) I didn't install SQL Server 2008 KB 970315 x64, because I'm running R2 version - as I understand this is SQL Server 2008 SP2... Then it runs for a few seconds and fails with this message: New-SPConfigurationDatabase : Cannot connect to database master at SQL server a t developer.mydomain.pri. The database might not exist

  • I have a new SharePoint 2010 server farm that I'm trying to configure. Installation went fine. But I'm having trouble getting the user profiles to import. I've created the User Profile service... Time=66685.955058534 As a side note, our AD structure is set up with 1 root domain, and 3 child domains. The SharePoint server and all the service accounts are running in the root domain, but I'm trying to set up a connection to one of the child domains. The connection service account has been granted "Replicate Directory Changes" permission on both the root and the target child domain. Can

  • the log file and there are a lot of entries regarding stsadmin, a few exceptions (access denied) even though I am both a server administrator and a farm administrator (everything is all and the same server... jobs running at the time, plus I tried a reboot and got the same error message. I also try to start Forefront Identity Manager Service and it stops straight away (domain account or local system account): The Forefront Identity Manager Service service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs

  • Windows SharePoint Services Database Update 2 Now I've again configured the SharePoint Farm as per your instructions but still getting the same warning. Please let me know if I am running any...I have successfully configured a SharePoint farm of 4 nodes but I got intermittent database connection failure errors. I have to restart SharePoint services and IIS to fix the database errors. Mostly... Service: Office SharePoint Server Search Issue: The search service is using an account assigned to the Farm Administrators group to crawl content for Shared Services Provider SharedServices2

  • I have created a simple survey with SharePoint Server 2010 with the intent of allowing all our domain users to access and complete it. I added some basic branching logic to this survey as well... and clicking the "Next" button, they receive an Access Denied error. Thinking that the branching may have been causing an issue, I removed it. The users can now see the whole survey at one time, but when they try to submit their answers they still received the Access Denied error. I have tried sending an access request from a test user (as prompted by the error page), but I still received the same error

  • I'm having problems installing development machine for SharePoint (Foundation) 2010. This is what I did so far on the same machine: Installed a clean Windows 7 x64 with 4GB of RAM without being... installation and then installed it as Server Farm (then Complete) to avoid installing SQL Express. Created a separate SPF_CONFIG local user with Logon as a service right. Opened SPF Management Shell and run New... The outcome after this error is: Database Sharepoint2010Config is created User SPF_CONFIG is added to SQL Server and attached to this newly created database as dbowner (check below image) alt text http

  • . At the moment the following databases have priority, but as we only have a limited set of services enabled I know there are many more. SharePoint_AdminContent_[some guid] Managed Metadata Service...SharePoint 2010 appears to continue SharePoint 2007's tradition of automatically creating horribly named SQL Databases. Like many companies we have multiple farms and developer workstations... Service Application_ProfileDB rather than: SharePoint_AdminContent_9fc4ac7c-6895-4a74-bf10-df6ac4c2c1d6 User Profile Service Application_ProfileDB_a17efbf6942341f785c69829ce7f2d97 I am creating

Data information