Solved

Configure Sharepoint 2007 connect to SQL 2008 on different server

Posted on 2009-05-15
6
960 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 Table Moves 3 27
Stored Proc - Rewrite 42 73
Adding SQL Server Browser in after install is complete 8 29
How come this XML node is not read? 3 28
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…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
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 antispam), the admini…

756 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