Cannot Connect to Database Master at SQL Server at “” . The Database might not exist, or the current user does not have permission to connect to it

Finally, I have started working with SharePoint 2016… in 2017 😉

So as always, I like to setup my development environment. Instead of using VMWare workstation, I decided to try out Hyper-V on Windows 10. And guess what? I love it.

I always begin the very first install of SharePoint manually, piece by piece before I start using the AutoSPInstaller scripts. I like to know whats’ what in the box before I begin using automation for the process. It adds to my understanding and knowledge of how pieces fit together. That’s just me.

Anyways, so I created a Win Server 2012 Hyper-V VM, installed the Active Directory services feature, added service accounts for the install, installed sql, installed SharePoint 2016 binaries. This link is what you should follow when setting up SharePoint 2016

(https://technet.microsoft.com/en-us/library/ee662513(v=office.16).aspx)

And THEN! I ran the Configuration Wizard. On step 3, creating the configuration database… the error “Cannot Connect to Database Master at SQL Server at ‘xxx’ . The Database might not exist, or the current user does not have permission to connect to it” .

So I begin the quest to find whats wrong. I came across blogs that told me to checked TCP/IP, named pipes, sql server access and the list goes on but nothing matched up with solving the issue.

I came across a blog that mentioned about adding the IP address of your active directory server to your host file. And it WORKED!

On my VM, my Domain is called SP.Com. I added a entry in there to the machine I was building my development environment on.

hostfile

So in my case, this was the fix.

 

Hope that helps. Also wish to give credit to the blog that gave me this hint but I forgot which one it was. It was a late night. Sorry

 

Phil