I am using PI JDBC Driver 2016 for linux(client machine)to connect to PI server(windows machine). PI SQL DAS is also installed on the same machine which has the PI Server.
However, while connecting to PI server using the connection string i am getting the following error:
Connection string: conn <- dbConnect(drv, "jdbc:pioledb://my_server/Data Source=my_server; Integrated Security=SSPI; ")
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url), : java.sql.SQLException: Connection to https://my_server:5461:5461/DataAccessServer/Query failed. Error: [Kerberos] Kerberos ticket cannot be acquired. Unspecified GSS failure. Minor code may provide more information. SPNEGO cannot find mechanisms to negotiate. Connection to net.tcp://my_server:5461:5462/DataAccessServer/Query failed. Error: NetTcp is not supported. Could not connect using none of the specified protocols.
I have confirmed that ports 5461 and 5462 are open.
Please help me resolve this issue