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

NovaChargedAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hitesh ManglaniCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NovaChargedAuthor Commented:
Solution provided links containing background information that I needed to understand, troubleshoot and resolve the problem.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.