SQL Operations Studio and Windows Authentication
With the recent release of the Microsoft's SQL Operations Studio, a cross-platform tool which allows you to have the option to connect to your SQL instances using either SQL login or Windows Authentication from your macOS computer.
To be able to connect to your SQL instances using Windows authentication, you can use the tool kinit to acquire initial tickets. You need to create a file (/etc/krb5.conf) with the following information, make sure to use all-caps in the default_realm setting.
[libdefaults]
default_realm = SUBDOMAIN.EXAMPLE.COM
Now, you should be able to connect to your active directory. Here's an example:
$ kinit myuserid
[email protected]'s password:
If you put in your password correctly, you should now have a 10-hour authentication ticket. You can verify by using the klist command:
$ klist
Go back to the SQL Operations Studio and give it a try.
Subscribe to /home/jrienton
Get the latest posts delivered right to your inbox