SQL Server Performance Forum – Threads Archive
OPENDATASOURCE question
Hi Folks,<br />I need to use OPENDATASOURCE using Windows (trusted) Authentication to query another SQL server. BOL and other resources provides this connection thru SQL authentication. <br />e.g.<br /><br />SELECT *<br />FROM OPENDATASOURCE(<br /> ‘SQLOLEDB’,<br /> ‘Data Source=ServerName;User ID=MyUID<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />assword=MyPass'<br /> ).Northwind.dbo.Categories<br /><br />What is the format if I need to use Windows authentication to use this.<br /><br />Thanks much in advance,<br />Anil <br />Check: http://msdn2.microsoft.com/library/ms179856.aspx
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS†with no warranties for accuracy.
Luis’s link refers to SQL 2005 and it helps if your servers 2005 version. Referhttp://msdn.microsoft.com/library/d…wd11/html/womthOpenDataSource1_HV05212333.asp &http://www.codecomments.com/archive352-2005-3-432174.html for more information. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Yeap. Sorry.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS†with no warranties for accuracy.
This’d help. Thanks much Luis and Satya.
]]>