- 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?
L'auteur du sujet a confirmé que cela a fonctionné.
L'auteur du sujet, le 2020-05-23 (texte original)Texte original (Espagnol)
“El problema era la configuracion del ODBC. Yo me conectaba utilizando la IP local, la solucion fue utilizar "piped names" y poner "localhost"”