Where do you set kerberos authentication creds?

0

I have 2 domains setup with a trust between them DomainA and DomainB. when the folowing is rin from teh DomainA SSMS I get authentication errors on the SQL server in DomainB

DECLARE @DatabaseFolder varchar(4000)
DECLARE @DeleteDate DATETIME = GETDATE()
set @DatabaseFolder=N'\\sql.DomainB.local\copyonly\'
--Delete old backup files.
EXEC master.sys.xp_delete_file 0,@DatabaseFolder,'BAK', @DeleteDate,0;

If I use the IP instead of FQDN, kerberos is not used and the command works. What is super odd is that I am logged into windows as administrator, but the authentication errors i see each time I run the above command are for a specific user DomainB\jane.doe.

An account failed to log on.

Subject:
    Security ID:        NULL SID
    Account Name:       -
    Account Domain:     -
    Logon ID:       0x0

Logon Type:         3

Account For Which Logon Failed:
    Security ID:        NULL SID
    Account Name:       jane.doe
    Account Domain:     DomainB

Failure Information:
    Failure Reason:     Unknown user name or bad password.
    Status:         0xC000006D
    Sub Status:     0xC000006A

Process Information:
    Caller Process ID:  0x0
    Caller Process Name:    -

Network Information:
    Workstation Name:   SQLServerName.DomainA.Local
    Source Network Address: 10.0.2.211
    Source Port:        64747

So I am logged into DomainA SQL as administrator, I use windows authentication in SSMS but when I run the command it attempts to connect to the DomainB SQL server as this DomainB\jane.doe user.

Where is this configured in SSMS?

sql-server
ssms
asked on Stack Overflow Mar 18, 2020 by Gummby8

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0