Restore over dns alias fails with Operating system error 1326(The user name or password is incorrect.)
2
votes
1
answer
613
views
following configuration:
* SQL Server is running on server.domain.intra with an gMSA.
* DNS alias: server-db-dev.domain.intra
* gMSA Permissions on backup share: Full Control
* SPNs set for gMSA:
* MSSQLSvc/server.domain.intra:1433
* MSSQLSvc/server.domain.intra
* MSSQLSvc/server-dev-db1.domain.intra:1433
* MSSQLSvc/server-dev-db1:1433
Problem:
When the restore is started with \\server.domain.intra\BackupShare$, the restore finish successfully but with the DNS alias we get the error "Operating system error 1326(The user name or password is incorrect.)"
I have the feeling that the gMSA should be configured to allow to be delegated to the dns alias.
Or do you have any other ideas how to solve the problem?
Thank you very much and kind regards,
Olaf
Asked by Shashahan
(23 rep)
Aug 15, 2022, 06:47 AM
Last activity: Aug 15, 2022, 11:12 AM
Last activity: Aug 15, 2022, 11:12 AM