I am trying to create SharePoint 2013 farm using SQL Alias. I did create SQL alias ahead of time and I was able to verify connectivity using a udl file and that is working without any issue. However, I have tried to create SharePoint farm (single server) using manual steps and also using AutoSPInstaller and I am getting the same error:
Cannot connect to database master at SQL server SP2013DEV. The database might not exit, or the current user does not have permissions to connect to it.
Also, we are getting event ID: 5586
Log Name: Application Source: Microsoft-SharePoint Products-SharePoint Foundation Date: 10/23/2015 10:07:08 AM Event ID: 5586 Task Category: Database Level: Error Keywords: User: CNP\svc_farm Computer: ew.en.org Description: Unknown SQL Exception -1 occurred. Additional error information from SQL Server is included below. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Note: SQL 2012 standard edition is installed on the same box Firewall is disabled.