Quote:
Originally Posted by RebeccaBlack
I'm not entirely sure what that means myself, but have you checked your logs? Any problems usually get put there. Also is your client 100% okay, since sometimes a small bug can cause everything to flip out.
I'm pretty sure that error is to do with packets though, it's not properly receiving them, or "downloading the data" correctly. Check your connection speed to make sure it's okay.
Do you have the "Linked Servers" in the database installed? To check, Go to Microsoft SQL Server Management Studio Express. Expand "Server Objects". After that, Expand "Linked Servers". You should have the following in that: - game
- PS_DEFINEDB
- PS_GAMEDB01
- PS_NCASH
- PS_USERDB
- PS_USERDB01
|
Firstly thank you for the response.
My client is fine worked perfect before and i havent change it. My whole team having the same issue. Also what logs? the ones in the server files all seem fine pls find logs below....
i do have linked server
what could be the problem there
I tested and this is the error i got...
TITLE: Microsoft SQL Server Management Studio
------------------------------
The test connection to the linked server failed.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
VIA Provider: The specified module could not be found.
OLE DB provider "SQLNCLI10" for linked server "PS_USERDB01" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "PS_USERDB01" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, Error: 126)
For help, click: