Solved

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

Posted on 2013-11-11
2
394 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
[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
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

691 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