CODEWITHSUNDEEP
sql-serveractive-directoryuser-accounts
Wiktor
Wiktor

Reputation: 631

Unable logon sql instanced

Recently I changed a password for the account and now I am unable to run instances on the SQL server. I got error0x8007042d. What is more interesting the same credentials are working on another sql server. Another interesting thing is no matter what credentials I use from my domain I got the same error. Can you please guide where the problem lies?

enter image description here

Upvotes: 0

Views: 18

Answers (1)

Apep
Apep

Reputation: 111

Are both servers pointing to the same domain controller? If not, what is the replication time between them? Perhaps it's working on the other server because the password was reset on the DC it's pointing at.

Also check the server is actually joined to the domain properly, has a machine account in AD, the account you're trying to use isn't locked out/disabled, etc.

Another possibility could be Group Policy settings, check both servers are in the same OU, or have the same policy applied.

Upvotes: 1

Related Questions