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.PostS etupConfig uration.Po stSetupCon figuration TaskExcept ion 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\PSCDiag nostics_5_ 15_2009_10 _20_28_928 _177741274 1.log. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.
Microsoft.SharePoint.PostS etupConfig uration.Po stSetupCon figuration TaskExcept ion: Exception of type 'Microsoft.SharePoint.Post SetupConfi guration.P ostSetupCo nfiguratio nTaskExcep tion' was thrown.
Error: An exception of type Microsoft.SharePoint.PostS
Microsoft.SharePoint.PostS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what about the user mappings for the user?
ASKER
what should the user mappings be?
ASKER
got it! The wizard wanted all caps when i was using lowercase
Hope you resolved your problem.
ASKER
Sharepoint-Account.JPG