Service Account for Microsoft SQL

💬 Queries and Resources
1

I want to connect to a managed instance of MS SQL using a service account, not an SQL account. A service account has the same form as an email address.

When I put in the credentials, it reads the service account name as a username and then a server, so failing to connect.

I cannot see how I can use a service account to connect, and I don't see another connector type I could use.

image
image340×321 8.58 KB

3

Found the only way to do this is using a JDBC connector and specifiying in the connection string.

4

Have you tried capitalizing all your domain part (ZZZ.COM.AU in your example)? I also use MS SQL and have no issue connecting with username in email format.