- 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?
Người mở chủ đề đã xác nhận cách này hiệu quả.
Người mở chủ đề, 2020-05-23 (nguyên văn)Nguyên văn (Tiếng Tây Ban Nha)
“El problema era la configuracion del ODBC. Yo me conectaba utilizando la IP local, la solucion fue utilizar "piped names" y poner "localhost"”