Issue:
Unable to connect to SQL Server remotely. Able to connect on the server. This is for a newly installed instance of SQL Server.
Fix:
Make sure “Named Pipes” and “TCP/IP” protocol is enabled.
- Go to SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER
- Make sure Named Pipes and TCP/IP is set to Enabled
Make sure firewall not blocking domain connection.
Make sure SQL Server property “allow remote connection” is checked.
Comments