Connection parameter syntax for MS SQL DB Connection

[sdey_2023]

Hi Team,

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

@ParitaSavla 

[rushikeshvartak]

jdbc:sqlserver://JOBINSSIS2016.europe.com:1433;databaseName=DB_UAM;authenticationScheme=JavaKerberos;integratedSecurity=true;userName=SAM-AUTOMATION-S;password=Rushi@123

[sdey_2023]

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.

[DixshantValecha]

If you are using SQL Server authentication instead of Windows authentication (Kerberos), then you can use the following syntax for the JDBC URL:

syntax:-jdbc:sqlserver://<server_name/ip>:<port>;databaseName=<dbname>

[sdey_2023]

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.

[Saathvik · Accepted solution]

No not required, username and password goes to respective connection attributes and for URL it goes like this

jdbc:sqlserver://<server_name/ip>:<port>;databaseName=<dbname>

[AashishD]

Hi,

While following the same format we get an error as such 

Any idea if we are missing something?

[Saathvik]

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?

[DixshantValecha]

yes like Saathvik mentioned:-

ername and password goes to respective connection attributes and for URL it goes like this

jdbc:sqlserver://<server_name/ip>:<port>;databaseName=<dbname>