P
Pat Hampson
How can I run an ADO based query to a SQL 2000 server that
is not in my domain (or more accurately, I am not in a
trusted domain) by still using "windows authentication"?
(details below)
I work with a product that I install for many customers
where the only ADO connection allowed is via "windows
authentication". In other words, there is no SA account
(or SQL Server account) priveledges and I do not want to
change that.
I used to be able to connect using ADO with "trusted
connection=yes" in the connection string and supply the
login as "User ID=DOMAIN\UserName" where the
DOMAIN\UserName is a known account with priveledges to
query the database. I would also supply the password for
that account.
Since SQL Server SP3 was installed (and is on all the
products we are installing), I cannot authenticate to run
a query from my machine. I can connect to this machine in
my company's domain, the problem is, my product will
always be in an untrusted domain belonging to whatever
customer I am installing for. This is for documentation
of our installation.
I have tried mapping a drive to the server, since I have
to authenticate, but ADO apparently does not see those
credentials.
Any ideas?
Thanks in advance, the newsgroup has been invaluable to
me.
is not in my domain (or more accurately, I am not in a
trusted domain) by still using "windows authentication"?
(details below)
I work with a product that I install for many customers
where the only ADO connection allowed is via "windows
authentication". In other words, there is no SA account
(or SQL Server account) priveledges and I do not want to
change that.
I used to be able to connect using ADO with "trusted
connection=yes" in the connection string and supply the
login as "User ID=DOMAIN\UserName" where the
DOMAIN\UserName is a known account with priveledges to
query the database. I would also supply the password for
that account.
Since SQL Server SP3 was installed (and is on all the
products we are installing), I cannot authenticate to run
a query from my machine. I can connect to this machine in
my company's domain, the problem is, my product will
always be in an untrusted domain belonging to whatever
customer I am installing for. This is for documentation
of our installation.
I have tried mapping a drive to the server, since I have
to authenticate, but ADO apparently does not see those
credentials.
Any ideas?
Thanks in advance, the newsgroup has been invaluable to
me.