- 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?
“El problema era la configuracion del ODBC. Yo me conectaba utilizando la IP local, la solucion fue utilizar "piped names" y poner "localhost"”
El autor del tema, 2020-05-23 (texto original)