Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gregorio
Starting Member
2 Posts |
 Posted - 2010-08-06 : 15:33:56
|
| Hi guys,I created a login for my database. Authentication is working fine. The default database for the login is set to this database.The problem is: Without fail, under high CPU usage on the overall server (95% and above), this error occurs:Login failed for user 'user_xyz'Error: 18456 Severity: 14 State: 16.When CPU usage settles down, logging in works fine again.Now, the server's memory is running low too by the way. Only a few hundred megabytes of actual memory are left.Any thoughts?Thanks,Greg |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gregorio
Starting Member
2 Posts |
Posted - 2010-08-06 : 16:05:06
|
| Thank you Tara. And, agreed.The server is a web and email server too. A lot of the usage is from IIS and email serving. Very little usage is from SQL Server.(I'll be setting up a dedicated system for SQL when possible)Does this sound right though? Logging into SQL Server completely ceases under high load? I wonder if there's a way around this, in addition to optimizing the server.(Right now, I never know when there will be a high usage 'blip' that will trigger this problem and break web page-to-SQL connectivity.)Thanks very much,Greg |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
SQL Server 2005 Express; login failed; CPU usage