How I use OpenRowSet with Truested Connection?

Hi,
How I use OpenRowSet with Truested Connection?
SELECT *
FROM OpenRowSet('SQLOLEDB.1', '{SQL Server};SERVER=name', 'select a=1')
Thanks,
Jefferson ValimJefferson,
Here's an example that accesses the local server. Hopefully you
can adapt it for your needs.
select *
from OpenRowset(
'SQLOLEDB.1',
'Trusted_Connection=Yes;Database=Northwi
nd;Integrated
Security=SSPI;Data Source =(local)',
'select 1 as a')
Jefferson Valim wrote:

>Hi,
>How I use OpenRowSet with Truested Connection?
>SELECT *
> FROM OpenRowSet('SQLOLEDB.1', '{SQL Server};SERVER=name', 'select a=1')
>Thanks,
>
>Jefferson Valim
>
>|||Hi
And make sure that Security account delegation is available on the client
and sending server.
http://msdn.microsoft.com/library/d...>
ity_2gmm.asp
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve Kass" <skass@.drew.edu> wrote in message
news:ezo0X1wOFHA.904@.tk2msftngp13.phx.gbl...
> Jefferson,
> Here's an example that accesses the local server. Hopefully you
> can adapt it for your needs.
>
> select *
> from OpenRowset(
> 'SQLOLEDB.1',
> 'Trusted_Connection=Yes;Database=Northwi
nd;Integrated
> Security=SSPI;Data Source =(local)',
> 'select 1 as a')
> Jefferson Valim wrote:
>