I need to connect to a SQL Server through UFT (Unified Functional Testing) but the problem is SQL Server is present at different domain whereas QTP (HP QuickTest Professional) is present in a different domain.
I am able to connect to SQL Server manually from my domain using
runas /netonly /user:mydomain\TestUser "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe
Where mydomain is the domain in which the SQL Server is present. This is working fine when I connect it manually, but it failed to establish a connection when I tried to connect it through QTP.
Connection string that I'm using:
The password in the connection string is different from the password that I provide after executing above
runas command. I also tried with passing both the domains in UID in connection string in QTP but still not able to connect.