- 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?
Der Threadersteller hat bestätigt, dass das funktioniert hat.
Der Threadersteller, 2020-05-23 (Originalwortlaut)Originalwortlaut (Spanisch)
“El problema era la configuracion del ODBC. Yo me conectaba utilizando la IP local, la solucion fue utilizar "piped names" y poner "localhost"”