Is Database Required Before SharePoint Small Server Farm Installation

Posted on 2011-10-03
Last Modified: 2012-05-12

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:\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

Question by:NovaCharged
    LVL 13

    Accepted Solution


    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-

    Hope this helps

    Author Closing Comment

    Solution provided links containing background information that I needed to understand, troubleshoot and resolve the problem.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    This video discusses moving either the default database or any database to a new volume.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    730 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

    18 Experts available now in Live!

    Get 1:1 Help Now