Forum Discussion
Connect to SQL server with Localhost via UNIX socket
- 6 years ago
Hi admin_e4e ,
Would you please follow the steps below to locate your issue:
1. First check whether the server name or alias of SQL server is set correctly
2. Check whether TCP/IP protocol is enabled on the client side and SQL server side
3. Check whether the SQL server Browser service of SQL server starts normally
4. Ping the IP address of the server where SQL server is installed to see if it works, and test whether the port number of SQL server listening is enabled
Best Regards,
Dedmon Dai
admin_e4e , Your Server type: MySQL. As per the description given. Are you connecting to the right DB
- admin_e4e6 years agoFrequent Visitor
Yes. the IP is correct. I think the problem is that the connection is configured partly local via hosts file located in: C:\Windows\System32\drivers\etc. the IP address of the server is configured there.
- v-deddai1-msft6 years agoCommunity Support
Hi admin_e4e ,
Would you please follow the steps below to locate your issue:
1. First check whether the server name or alias of SQL server is set correctly
2. Check whether TCP/IP protocol is enabled on the client side and SQL server side
3. Check whether the SQL server Browser service of SQL server starts normally
4. Ping the IP address of the server where SQL server is installed to see if it works, and test whether the port number of SQL server listening is enabled
Best Regards,
Dedmon Dai