Hi,
I am using vbscript (adodb) to connect to a SQL DB that is situated in a different domain with windows authentication configured of that domain. For example if I want to login to the DB I use Remote desktop and login to that db server and open SQL server from there using windows authentication (used while logging into the DB server).
Now I want to connect to that DB from my system which is in a different domain and I'm trying to understand how...
I have used the following connection string
oConn.Open "Driver={SQ L Server};Domain= xyz;Server=some server;Database =my db;TrustedConne ction=yes"
I have also added my UID and PWD (Domain) in the connection string,but nothing works:
Please let me know your suggestions.
I am using vbscript (adodb) to connect to a SQL DB that is situated in a different domain with windows authentication configured of that domain. For example if I want to login to the DB I use Remote desktop and login to that db server and open SQL server from there using windows authentication (used while logging into the DB server).
Now I want to connect to that DB from my system which is in a different domain and I'm trying to understand how...
I have used the following connection string
oConn.Open "Driver={SQ L Server};Domain= xyz;Server=some server;Database =my db;TrustedConne ction=yes"
I have also added my UID and PWD (Domain) in the connection string,but nothing works:
Please let me know your suggestions.