Solved

Installing Sharepoint 2010 from scratch - Is SQL Server 2008 R2 required

Posted on 2013-11-11
2
391 Views
Last Modified: 2013-11-11
Hello all,

I am trying to install SharePoint 2010 Enterprise. I just reloaded an HP Server with a brand new Windows Server 2008 R2 OS / It is running an a Primary domain controller, I have AD installed on this serve. I have installed all the SharePoint pre-reqs.

SharePoint states it installed correctly but I constantly get the following error message and cant get past it:

[SharePoint Products Configuration Wizard]
Cannot connect to database master at SQL Server at [server name]. The database might not exist, or the current user does not have permission to connect to it.


Do I need SQL 2008 server installed in order for SharePoint 2010 to install correctly ? It does not specifit that in the pre-reqs during the install of SharePoint 2010.

Thanks !!
SharepointInstallError.JPG
Sharepoint-error-2.JPG
0
Comment
Question by:PAULADAMSJR
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 39640247
Hi,
so you want to run SharePoint 2010 Enterpise single server install?
THen you have to install SQL Server seperatly before running the SharePoint Product Configuration wizard AND you have to install SharePoint using "Farm" installation.

SQL Server Express cannot be installed OOTB on a domain controller. When you install SharePoint in Single Server mode, SharePoint tries to install the SQL Express edition automatically - and this will fail.

Therefore you have first to install SQL Server Express (or better a full version) before installing SharePoint.

HTH
Rainer
0
 

Author Closing Comment

by:PAULADAMSJR
ID: 39640481
Installed SQL server 2008 Standard R2, then ran SharePoint Product Configuration Wizard, selecteded Farm Installation...and.....Wahaaa !!  Issue Resolved. Thank You !! :-)

PA~
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

919 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

16 Experts available now in Live!

Get 1:1 Help Now