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
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
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
I tried and getting the below error. Screen attached for reference
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
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