Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Configure Sharepoint 2007 connect to SQL 2008 on different server

Posted on 2009-05-15
6
Medium Priority
?
964 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 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

670 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