Error: "An error occurred while trying to access the database" while installing Reporting Server

Article:TECH101736  |  Created: 2006-01-10  |  Updated: 2009-01-15  |  Article URL http://www.symantec.com/docs/TECH101736
Article Type
Technical Solution


Environment

Issue



You install Reporting Server on Microsoft SQL Server. After you give the SQL administrator user ID ("sa" by default) and password, the installation fails with the following error message: "An error occurred while trying to access the database."

The ReportingServerInstall.log file contains the following result: "No Error Info posted; HResult 0x80004005"


Solution





Before you begin: If this problem happens when SQL Server is installed on a different computer, first try the solution in the following document:
Error "An error occurred while trying to access the database." while installing Reporting Server with SQL installed on another computer


This problem can happen if the SQL server is not configured to use mixed-mode authentication.

To set the SQL server to use mixed-mode authentication
  1. On the Windows taskbar, click Start > Programs > Microsoft SQL Server > Enterprise Manager.
  2. In the left pane, right-click the server, and then click Properties.
  3. On the Security tab, under Authentication, click SQL Server and Windows, and then click OK.
  4. In the left pane, go to Security/Logins.
  5. Double-click the "sa" account, or whichever account you used when you installed Reporting Server.
  6. Type the account password, click OK, then type the password again for verification.
  7. Restart the SQL Server service.




Technical Information
If you select SQL Server and Windows for authentication but you do not confirm the password, the installation may still fail. This failure causes the following message to appear in the ReportingServerInstall.log file:


"No Error Info posted; HResult: 0x80040e4d"




Legacy ID



2006031012125848


Article URL http://www.symantec.com/docs/TECH101736


Terms of use for this information are found in Legal Notices