Administering Microsoft SQL Server 2012 Databases
Currently, I have set up lab environment on my lap top (like example in 70-462 Training Kit)
After 1st exercise, which is to test connectivity between machine in domain, I cannot connect from SQL-A to SQL-Core It show error
Cannot connect to SQL-CORE 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 configure to allow remote connections (provider: Named pipes Provider. Error 40 – Could not open a connection to SQL Server (.net SQLClient Data provider)
Error Number: 53
In the set up phase, I can success fully join SQL-A,SQL-B,SQL-C,SQL-D and SQL-Core to DC. Anyone has experience in this, please help.
The issue is resolve.
I re-create SQL-Core VM from scratch and re-install the SQL Server and it work.
I was in the same situation but re-creating sql-core virtual machine didn't help at first.
I solved re-creating the virtual machine and changing the command for the installation of sql server:
Setup.exe /qs /Action=install /Features=SQLEngine,IS,Conn /InstanceName=MSSQLServer /SQLSYSADMINACCOUNTS="Contoso\kim_akers" /TCPEnabled=1 /IAcceptSQLServerLicenseTerms
I added TCPEnabled=1 and this time I could connect to the SQL-CORE from SQL-A.
My question is: How could I enable TCP connections after the installation?
Hi Domenico, I have somewhat similar issue. I'm curious, I had checked all the configurations on the vm's and all said TCP\IP enabled, though they still couldn't see each other, did you notice that on your installation before you re-ran the install?