How to connect to your on-promise SQL instance with a container in kubernetes?

2,828 views

Skip to first unread message

Anton Vasanthakumar

unread,

Jun 18, 2018, 8:48:01 AM6/18/18

to Kubernetes user discussion and Q&A

Hi ,

I'm creating a container with a connection to on-premise sql database. When I deploy it it's throwing an error message shown below,

"System.Data.SqlClient.SqlException: Cannot authenticate using Kerberos. Ensure Kerberos has been initialized on the client with 'kinit' and a Service Principal Name has been registered for the SQL Server to allow Kerberos authentication."

Thanks,

Anton

paco tena

unread,

Jul 12, 2018, 7:58:57 AM7/12/18

to Kubernetes user discussion and Q&A

I have just had the same issue. My problem was the connection string (I was using the Trusted_Connection=true parameter). If you need to use it as a trusted connection instead of using [User Id] & Password you have to be sure that your SQL Server have Kerberos configurated properly. You can check it using this Microsoft tool :https://www.microsoft.com/en-us/download/details.aspx?id=39046