ScotN

updated

12 years ago

S

ScotN

76 Posts

0

4434

June 14th, 2014 07:00

DD prompting for password

My Data domain started prompting for passwords and flat out giving permission denied to a few SQL agent accounts running backup jobs.

The share is r/w to the hosts and I even made the SQL account owner of the share through windows domain admin account.

I can login to the SQL server as the SQL agent account and browse to the share but yet the SQL job still fails.

It's very strange and we have been looking at this for days.  It seems to be a problem upstream to the share because tcpdump shows the SMB request never gets past the initial SMB Setup andX Request. Responds with STATUS_LOGON_FAILURE.

account has full read write access. I have made the share completely wide open but it's still getting denied.

2008 Domain Controllers, 208-2012 SQL Server running transact SQL job to dump to the database.

SQL agent is running as an AD service account. Worked for weeks then just stopped at 4AM with no changes.

Tried:

  • rebooted DD
  • re-joined DD to the domain.
  • used cifs troubleshoot to validate the sqlaccount could be looked up from the dd
  • used net dns to verify client host and domain controllers resolve.
  • Changed ownership of the share to the sql agent.
  • updated to ddos 5.2.5 from 5.1
  • scratched head vigorously