CODEWITHSUNDEEP
sql-serverpowershellactive-directoryspn
Luke
Luke

Reputation: 855

Alternative to SetSPN command in PowerShell

I need to be able to manage SQL Server SPNs in a large estate but using the setspn command is a bit too slow.

Is there an alternative to the setspn command that is faster? Perhaps in the ActiveDirectory PowerShell module?

Thanks

Upvotes: 1

Views: 1235

Answers (1)

user847990
user847990

Reputation:

I am not aware of any method outside of setspn to manage SPNs. I mean even if you get some 3rd party solution, expect it is still going to be calling that in the background as it is the utility used in AD for that purpose.

The dbatools module includes functions around managing SPNs for SQL Server. In testing they have performed a bit better than Microsoft's Kerberos Configuration Manager. I mean in a large domain it may not be the fastest, but it will offer you the ability to automate the validation/setting/etc.

The commands available:

This module is maintained/hosted on GitHub so you can find the code here.

Upvotes: 1

Related Questions