November 30, 2011 at 4:18 am
Hey:w00t:
Bit of a strange one... Getting the following error in the log for a couple of Clients
Error: 18456, Severity: 14, State: 58.
Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: x.x.x.x]
SQL Server Authentication is set to Mixed Mode... Always has been... I have restarted ect
Any ideas?
November 30, 2011 at 4:22 am
Are you sure nobody touched the Authentication Mode? Please verify. It can't just appear without user intervention.
November 30, 2011 at 4:24 am
Yeah! just checked set to SQL Server and Windows Authentication mode..
November 30, 2011 at 4:32 am
Are you making attempt on correct server? Please check server name / instances (named / default).
Can you login on the server with Windows Account? Are SQL Logins enabled on Server?
November 30, 2011 at 4:39 am
Hello,
As a test, what happens if you create a new SQL account and then try logging onto the instance using it ?
Cheers
Vultar
November 30, 2011 at 6:10 am
Can you please let us know, how those users are connecting to the server e.g. through application, SSMS etc? Moreover, which version of SQL Server are you using?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply