Solved

Configure Sharepoint 2007 connect to SQL 2008 on different server

Posted on 2009-05-15
6
957 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 500 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now