Hello all,
I am unable to connect to database after deploying application on posit connect. we have to use window authentication for database connection.
I have created dsn in odbc.ini for connection.
[test]
Driver=ODBC Driver 18 for SQL Server
Server=ServerName
Port=1433
Database=DatabaseName
Trusted_Connection=yes
TrustedServerCertificate=yes
After that we have tested the connection with
isql -v test
This work perfectly!!
But after deploying shiny app where data is import from ms sql db , connection gives error.
We understand that we need create Kerberos ticket which is created by:
kinit serviceaccount@domain.com
Warning: Error in: nanodbc/nanodbc.cpp:1118: 00000: [Microsoft][ODBC Driver 18 for SQL Server]SSPI Provider: No Kerberos credentials available (default cache: KCM:) [Microsoft][ODBC Driver 18 for SQL Server]Cannot generate SSPI context.
Kindly support to figure out the issue.