Configure Sharepoint 2007 connect to SQL 2008 on different server
Posted on 2009-05-15
I am setting up a test server for Sharepoint 2007. When I use the Sharepoint Products and Technologies Configuration Wizard to connect to our SQL 2008 Server, I receive the error below. I want to know if I need to open any special ports on my SQL server 2008 for Sharepoint.
Error: An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: Failed to connect to the database server or the database name does not exist. Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server. To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_5_15_2009_10_20_28_928_1777412741.log. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.
Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.