[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

Is Database Required Before SharePoint Small Server Farm Installation

All,

I've been working on configuring a SharePoint 2010 single-tier, small server farm.  
On HyperV Machine1 , I've installed:

 - Windows Server 2008 R2
 - Active Directory
 - DNS

On HyperV Machine2, I've installed:
 - Windows Server 2008 R2
 - SQLServer Standard SP1 w/ Cumulative Update2

From a networking perspective, the machines are seeing each other and I have a few AD accounts created for the install.  During the server farm configuration, from within the SharePoint Products Configuration Wizard, after entering the following info:

Specify Configuration Database Settings
 - Database Server: SPDataServer
 - Database: SharePointConfig

Specify Database Access Account
 - User Name: SPActiveDir1.gtv.com\SPFarm
 - Password: Pass@word1

I receive the following error:
"Cannot connect to the database master at SQL server at SPDataServer.  The database might not exist, or the current user does not have permission to connect to it."

I did not actually create the database SharePointConfig before running all this.  I only performed the install for SQLServer (thus creating a database server).  

Is it required that you manually create a database before running this script?  Any ideas on how to resolve the error and move forward with my install would be greatly appreciated

0
NovaCharged
Asked:
NovaCharged
1 Solution
 
hiteshgoldeneyeCommented:
Hi,

You do not need to manually create the database, the wizard should take care of that. However maybe the firewall is blocking access to SQL Server

you can refer the following link for more details-

http://smallcitydesign.com/problems/cannot-connect-to-database/
http://blogs.technet.com/b/tothesharepoint/archive/2011/01/12/troubleshooting-sharepoint-configuration-error-cannot-connect-to-database-master-at-server-name.aspx

Hope this helps
0
 
NovaChargedAuthor Commented:
Solution provided links containing background information that I needed to understand, troubleshoot and resolve the problem.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now