/ SQL

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.



SQL Operations Studio and Windows Authentication
Share this

Subscribe to /home/jrienton