You were not connected because a duplicate name exists on the network.
I am getting this error daily on my web server that is trying to connect SQL Server.
"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: TCP Provider, error: 0 - You were not connected because a duplicate name exists on the network. If joining a domain, go to System in Control Panel to change the computer name and try again. If joining a workgroup, choose another workgro " Both Server are on Windows 2016. SQ I have already 1. checked the domain controller and found no duplicate entries 2. using different aliases for multiple IP on same SQL server 3. Checked all the server in the environmnet for any duplicate name and found nothing.
Can you please help me resolve this?
-Проверьте сеть: можете ли вы пропинговать сервер? Работает ли DNS на сервере?
-Проверьте настройку SQL: это экземпляр по умолчанию или вам нужно указать экземпляр?
-Проверьте, используя другое приложение / сервер: Может ли другой сервер подключиться к серверу SQL? Можете ли вы использовать соединение ODBC и будет ли оно работать?
Все это позволит сузить круг проблем.