SQL Server – SSMS – Creating New Credentials – Error – “Cannot determine whether computer is joined to a domain”

Preface

Following a guideline on running “SQL Server Agent Job Steps” via Proxy Agent and tumbling badly out of the gate.

 

Error

Textual

The error is “The program cannot open the required dialog box because it cannot determine whether the computer named <computername> is joined to a domain. Close this message, and try again“.

Image

cannotdeterminewhethercomputerisjoinedtoadomain-brushedup

 

Recreation

  1. Launch SQL Server Management Studio ( SSMS )
  2. Connect to the SQL Server Instance
    • Choose the SQL Instance
    • Navigate the tree to Security \ Credentials
    • Right click on Credential and from the drop down menu choose “New Credential
    • “New Credential” Window
      • The “New Credential” windows is displayed
      • Click on the Identity button
      • The system stays busy for a bit and the error pasted above comes up

 

Screen Shot

New Credentials – Trigger

newcredentialtrigger-brushedup

 

New Credentials – Identity Button Clicked

newcredentialtrigger-brushedup

 

Diagnostic

Network Diagnostic

netstat

Syntax


netstat -an | find "SYN"

Output

netstat-synstat-20161215-1006am-brushed-up

 

Explanation

  1. We see that we stuck trying to connect to port 445 on our destination SQL Instance
    • Stuck?
      • SYN_SENT Status means stuck
    • Port 445
      • SMB Traffic

 

Remediation

Have your Network\Firewall team open up Port 445 ( SMB traffic )

 

Workaround

Do the unthinkable, open up a Query window and enter the corresponding Transact SQL Statements.

Please lookup “Create Credential“.

 

References

  • Create a Credential
    Link

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s