bricoexpert
asked on
SQL 2005 Login failed for user 'sa' & constant Info errors
Hello Experts
I have a problem with one of our SQL 2005 SP2 servers.
From time to time the performance decreases gradually until and all queries from client software halt in time out.
In the SQL log file shows something strange:
"Error 18456, Severity: 14, State:16
Login failed for user 'sa'.[Client: xxx.xxx.xxx.xxx] - most of the times is the IP of the server itself"
I must add that clients software authenticates with 'sa' user from the software itself so is not the case of misspelling the password.
I have used "perfmon - SQLServer:SQL Errors[Info Errors]\Errors/Sec" and I've found constant info errors even if no transactions are tacking place.
The server is a central cashier server. The client software authenticates through user 'sa' and the sql service is running under an domain account. The server uses bulk import&bulk export for some clients who run SQL Express and tcp with others.
The client and the server are in the same location so network connectivity is ruled out. The load on the server is minimal.
Please help
Thanks
I have a problem with one of our SQL 2005 SP2 servers.
From time to time the performance decreases gradually until and all queries from client software halt in time out.
In the SQL log file shows something strange:
"Error 18456, Severity: 14, State:16
Login failed for user 'sa'.[Client: xxx.xxx.xxx.xxx] - most of the times is the IP of the server itself"
I must add that clients software authenticates with 'sa' user from the software itself so is not the case of misspelling the password.
I have used "perfmon - SQLServer:SQL Errors[Info Errors]\Errors/Sec" and I've found constant info errors even if no transactions are tacking place.
The server is a central cashier server. The client software authenticates through user 'sa' and the sql service is running under an domain account. The server uses bulk import&bulk export for some clients who run SQL Express and tcp with others.
The client and the server are in the same location so network connectivity is ruled out. The load on the server is minimal.
Please help
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to be of assistance. May all your days get brighter and brighter.
you must run some health/antivirus/... checks on the server.
also, try to identify and scheduled activities, or maintenance plans, that run at the times you get the error message.
note:
>I must add that clients software authenticates with 'sa' user from the software itself so is not the case of misspelling the password.
VERY bad idea. you really should change that!!!
once done, change the sa password, and see what happens