July 22, 2013 at 2:13 am
Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 10.5.34.152]
I am getting the above error over and over in my SQL log but SQL is 100% enabled for mixed mode. I have restarted SQL to ensure it is and also ran
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly');
which returns 0.
Any idea where this error might of appeared from?
July 22, 2013 at 5:32 am
Hi,
Is your SQL Login Enabled? (check Properties->Status for Login). Once I had that problem.
Also check the User mappings and other properties for the Login.
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
July 22, 2013 at 5:56 am
Its not actually specifying an account in the error but yes ive checked all the accounts and none are locked\disabled.
Cheers for your time though.
July 22, 2013 at 6:06 am
What does
exec sp_change_users_login @Action='Report'
say?
Take a look on this: http://msdn.microsoft.com/en-us/library/ms174378(v=sql.105).aspx
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
July 23, 2013 at 1:49 am
Its coming back saying 2 SQL accounts are orphaned but I wouldn't think the error I am getting would be due to orphaned accounts?
July 23, 2013 at 8:47 am
Yes, It should not be unless if your account is one of the orphaned.
Well, try by resetting the password of your Login. Check some other stuff, and inform the community when you'll resolve it.
Interesting issue anyway.
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply