Learn how to a build a cloud-first strategyRegister Now


Sharepoint Foundation configuration cannot connect to database master

Posted on 2011-10-13
Medium Priority
Last Modified: 2012-05-12
I am trying to get Sharepoint Foundation on a Win 2008R2 server. The server is a domain controller. I get the error "Cannot connect to database master at SQL server at DC. The database might not exist, or the current user does not have the permission to connect to it."
So far what I could find is the firewall, which I have off, SQL server pipes are all enabled, and the administrator user is the user I am using to get this going. I downloaded and installed Microsoft SQL Server 2008R2, but there is also Microsoft SQL Server 2005 installed. I am trying to create a new farm. I have Sharepoint 2003 on a member server that I want to get rid of, but I didn't think that would screw this up.
Also in the management studio for SQL 2008R2 the administrator has dbcreator and security administrator rights. What could I have missed? Thanks!!
Question by:LunaRavenscroft
  • 2
  • 2
LVL 14

Accepted Solution

KoenVosters earned 2000 total points
ID: 36983948
First of all, it is bad practice to install SharePoint on your Domain Controller. You should use a seperate server.
Secondly, you have to make sure the firewall is off on both servers.

Author Comment

ID: 37091537
Does this mean that it just doesn't work? The firewall is not the problem.
LVL 14

Expert Comment

ID: 37092634
It doesn't mean it won't work :) It's just considered not to be best practice.
You are sure that you are pointing to the correct instance?

Author Closing Comment

ID: 37156983
I think that installing Sharepoint on a DC doesn't get a good enough install as it should so I am taking your advice and will try and get a different server to put it on.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

810 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