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?
User contributions licensed under CC BY-SA 3.0