Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Connection parameter syntax for MS SQL DB Connection

sdey_2023
Regular Contributor
Regular Contributor

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 

8 REPLIES 8

rushikeshvartak
All-Star
All-Star

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


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

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
Saviynt Employee
Saviynt Employee

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>

 

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

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


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

AshishDas
Regular Contributor II
Regular Contributor II

Hi,

While following the same format we get an error as such 

AshishDas_0-1683782614183.png

Any idea if we are missing something?

 

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?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

DixshantValecha
Saviynt Employee
Saviynt Employee

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>