- In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance.
- Open the ODBC DSNs used by the server files.
- Change the Server field from the LAN IP to localhost (or (local)) so the local servers use named pipes or shared memory.
- Restart the SQL Server service and start the servers again.
After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?
Konuyu açan kişi bunun işe yaradığını onayladı.
Konu sahibi, 2020-05-23 (orijinal ifadeler)Orijinal metin (İspanyolca)
“El problema era la configuracion del ODBC. Yo me conectaba utilizando la IP local, la solucion fue utilizar "piped names" y poner "localhost"”