May 29, 2008 at 6:56 am
We are not sure what happened but I can no longer logon with the Windows Authentication account we normally use. I can log on with the SA account however, it will not allow me to add any accounts or change anything. Our DBA however, CAN see all of the logons but cannot make changes. Any help would be appreciated.
May 30, 2008 at 4:30 am
Check with your Active Directory Admin to see how the Windows Account is set up. Does it require the password to be changed on a regular basis?
Most likely, it does or someone went in manually changing the password, causing SQL Server to not recognize the account any more. In which case, you might have to drop the account and re-add it to the server. Also, verify all the permissions of the account on SQL Server to make sure nothing changed there.
May 30, 2008 at 4:32 am
Wait a minute. Did I read that right? You can't make any changes with the SA account either?
Have you checked the Server's Event Log (Security) to see what sort of errors you're getting?
May 30, 2008 at 5:48 am
Finally able to logon with the mentioned account. Found out it had no default database assigned. The issue is fixed now. Thanks for your reply. Tom 🙂
May 30, 2008 at 5:58 am
Glad you figured it out. @=)
May 31, 2008 at 2:36 pm
This is one of the reasons that we typically ensure the accounts that manage security and the like have master set as the default database. I've faced this same problem before and it's frustrating because you typically only happen on the solution by chance.
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply