open rowset query using windows authentication

microsoft.public.sqlserver.server

18 May 2006 5:04 PM

shelleybobelly

Hi I need to do an "open rowset" query from one SQL server to another
(because I don't want to set up a linked server). I want to use windows
authentication, rather than a SQL logon. My windows account has read to
the remote server. Is this possible? If so, what is the syntax?

if I use SQLOLEDB, I cant' figure out how to say sspi or
trusted_connection = true. I can do it with a UID and PWD, but don't
want to, since I don't want to have to create the login, etc.

Anyone?

18 May 2006 6:39 PM

Jerry Spivey

Shelly,

Not sure what version you're using but check out:

OPENROWSET
http://msdn2.microsoft.com/en-us/library/ms190312(SQL.90).aspx

and

OPENDATASOURCE
http://msdn2.microsoft.com/en-us/library/ms179856(SQL.90).aspx

HTH

Jerry
<shelleybobe***@yahoo.com> wrote in message
Show quoteHide quote

news:1147971881.722223.11140@i40g2000cwc.googlegroups.com...
> Hi I need to do an "open rowset" query from one SQL server to another
> (because I don't want to set up a linked server). I want to use windows
> authentication, rather than a SQL logon. My windows account has read to
> the remote server. Is this possible? If so, what is the syntax?
>
> if I use SQLOLEDB, I cant' figure out how to say sspi or
> trusted_connection = true. I can do it with a UID and PWD, but don't
> want to, since I don't want to have to create the login, etc.
>
> Anyone?
>

Are all your drivers up to date? click for free checkup

18 May 2006 7:16 PM

shelleybobelly

Thanks Jerry. I realized I didn't have DBPROP_AUTH_INTEGRATED set to
yes on the server I was querying, so it was blowing up. Also I
couldn't find those articles when I searched MSDN (for some reason).
Thanks again.

Shelley

Thread options