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 |
|
juggo
Starting Member
1 Post |
 Posted - 2009-07-20 : 06:31:59
|
| Hi,I am using SQL Server 2005 for quiet sometime but recently I have getting an error that I am not able to fix. I receive timeout errors in my applications that try to connect with the server.Upon checking the logs of SQL Server I found following entries repeatedly:Login failed for user 'sa'. [CLIENT: 192.168.216.8]Error: 18456, Severity: 14, State: 10I have tried installing service pack 3 but that doesn't help either. Please helpregards,MJ |
|
|
jab
Starting Member
2 Posts |
Posted - 2009-07-21 : 12:21:39
|
| go into Studio ManagementRight click on your workspace and choose propertiesGo to Security - switch this to SQL Server and Windows AuthenticationGo back to security, logins, go to properties on SA.. Change the password to whatever you want, and then go to security, go to statues then click Enable.Restart the SQL service under Services.msc |
 |
|
|
|
|
|
Login Problem