Could you please confirm the URL, Username syntax to be used for MS SQL connection using local SQL account. In the DB connector guide, we were unable to find the connection syntax for MS SQL, please confirm if below syntax/names are correct:
URL : jdbc:sqlserver://<FQDN of DB Server>:port;databaseName=<DB Name>;
Username : local SQL Account's Principal Name without the domain?
Drivername - com.microsoft.sqlserver.jdbc.SQLServerDriver
Solved! Go to Solution.
Hi Rushikesh, Thanks for the reply. Just wanted to clarify that I was referring to a local SQL Server account based authentication and not Kerberos authentication. I believe the URL syntax format which you shared is for the Kerberos based authentication to MS SQL server but I am looking for the local SQL account based URL syntax.
Hi Dixshant, thanks a lot for sharing the details. A quick query on that - Do we need to explicitly mention the username and password in the URL as well as in the Connection Parameters that is present below the URL separately? Also, from security perspective, specifying the password explicitly in the URL might cause some issues.
No not required, username and password goes to respective connection attributes and for URL it goes like this
Looks like connectivity DB is limited to certain networks. Check with your DB team or n/w team to see if there is any IP whitelisting is required on DB side to make a successful connection.
Also are you able to make successful connection outside saviynt?