sharepoint database configuration issue

Seth Simmons
Seth Simmons used Ask the Experts™
we want to play with sharepoint 2016 beta 2 and having a problem with the database (same server)
the system is 2012 R2 fully updated with sql 2012 SP2
sharepoint installed fine but during the configuration, it says it "can't connect to the database might not exist or the current user does not have permission to connect to it."
firewall is disabled, all sql protocols are enabled and the application log states 'named pipes provider error 40 - could not open a connection to sql server'

i did do "sc query mssql$sharepoint" and it says it is running as well as the sqlbrowser.  not sure what else to try.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013
Awarded 2012

unfortunately the minimum supported SQL Server version is SQL 2014.

Most Valuable Expert 2013
Awarded 2012
Correction: Its 2014 SP1

The 64-bit edition of Microsoft SQL Server 2014 Service Pack 1 (SP1)
Sr. Systems Administrator
unfortunately the minimum supported SQL Server version is SQL 2014

while that statement is correct (apologies for making this an RTFM issue), it didn't resolve the sharepoint config problem
i built a new vm and installed sql 2014 sp1 and had the same error in the sharepoint config

after some trial and error, discovered the way i was specifying the server and database instance was incorrect.  once i got it right, it finished successfully

separately as a POC, i went back and built another vm with sql 2012 sp2 and used the correct database format in the sharepoint config and was successful.  not supported but technically did work.

the database format string was the issue
Seth SimmonsSr. Systems Administrator


figured it out myself though giving points to rainer for the requirements clarification

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial