How to create global connection string

Archive
,
1

Hi
I am trying to use sql connection string but unable to use it because our sql server login happens based on Windows AD Account.
And also i tried to you use Global Connection string still i am not sure where to configure and how to build a connection string for that.
Please advise me

Thanks
Dharma

2

Hi
I am trying to use sql connection string but unable to use it because our sql server login happens based on Windows AD Account.
And also i tried to you use Global Connection string still i am not sure where to configure and how to build a connection string for that.
Please advise me

Thanks
Dharma

3

Hi there,

Global Connection settings can be created from Database Settings of Katalon Studio:
https://docs.katalon.com/display/KD/Database+Settings

Thanks

____________________
Thank you for choosing Katalon Studio as your automation solution.
Your feedback is needed to make Katalon Studio a better tool, take the survey at: https://goo.gl/S25NVO

4

I tried and getting the below error. Screen attached for reference

Inline image 1

5

Hi there,

Have you enabled TCP/IP connection from that server? The displayed error message indicates you need to do that: https://technet.microsoft.com/en-us/library/hh231672(v=sql.110).aspx

Thanks

____________________
Thank you for choosing Katalon Studio as your automation solution.
Your feedback is needed to make Katalon Studio a better tool, take the survey at: https://goo.gl/S25NVO

6

Its enabled already.

Inline image 1

–

7

Hi there,

So please the following solutions:
1. Double check that your port “1433” is blocked by firewall or not

2. Adjust your connection string by removing ‘serverName’ field, e.g:
jdbc:sqlserver://PC001;integratedSecurity=true;databaseName=NORTHWND

Thanks

____________________
Thank you for choosing Katalon Studio as your automation solution.
Your feedback is needed to make Katalon Studio a better tool, take the survey at: https://goo.gl/S25NVO