Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Configure Sharepoint 2007 connect to SQL 2008 on different server

Posted on 2009-05-15
6
Medium Priority
?
965 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:bjv211
  • 3
  • 3
6 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 2000 total points
ID: 24396549
First off all you have to check 2 points.
1 Your sql server is installed and the service is running. Check the service status under services.
2. Make sure that the account you are trying to access to the server has defined in server as login and datbase as account. These are related but different tasks and need to be rewiewed.
0
 
LVL 1

Author Comment

by:bjv211
ID: 24396708
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
0
 
LVL 26

Expert Comment

by:tigin44
ID: 24396743
what about the user mappings for the user?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 1

Author Comment

by:bjv211
ID: 24396794
what should the user mappings be?
0
 
LVL 1

Author Comment

by:bjv211
ID: 24397127
got it!  The wizard wanted all caps when i was using lowercase
0
 
LVL 26

Expert Comment

by:tigin44
ID: 24398793
Hope you resolved your problem.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question