Link to home
Start Free TrialLog in
Avatar of bjv211
bjv211

asked on

Configure Sharepoint 2007 connect to SQL 2008 on different server

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.
ASKER CERTIFIED SOLUTION
Avatar of tigin44
tigin44
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bjv211
bjv211

ASKER

All SQL services are running except SQL Server Agent which is disabled (is that correct).  The sharepoint service account has login enabled and sysadmin role.
Sharepoint-Account.JPG
what about the user mappings for the user?
Avatar of bjv211

ASKER

what should the user mappings be?
Avatar of bjv211

ASKER

got it!  The wizard wanted all caps when i was using lowercase
Hope you resolved your problem.