InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:49:34 GMT20http://www.sqlservercentral.com/Forums/Topic1384056-392-1.aspxSELECT top 10 * FROM OPENDATASOURCE( 'SQLOLEDB', 'Data Source=Server1;User ID=user1;Password=password').orders.dbo.folderthis statement returned errorOLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "(null)" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".Msg 2, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [2]. if i run the same statement against other database it works fine.Tue, 13 Nov 2012 09:41:03 GMTskb 44459http://www.sqlservercentral.com/Forums/Topic1384056-392-1.aspxexec('exec OPENDATASOURCE(''sqloledb'',''Data Source=sqlsrv1; User ID=user1;Password=Pwd1'').Orders.dbo.testreport''' + @parameter1 + ''','+@parameter2+'' )Above statement gives me error Incorrect syntax near ','.Tue, 13 Nov 2012 09:00:58 GMTskb 44459http://www.sqlservercentral.com/Forums/Topic1384056-392-1.aspx--Execute a SP on a remote machine w/o using linked server insert into #temptable exec('exec OPENDATASOURCE(''sqloledb'',''Data Source=servername; User ID=loginid;Password=password'').databasename.schema.storedprocedurename''' +@parameter1+''','+@parameter2+'')Tue, 13 Nov 2012 07:01:42 GMTsjimmohttp://www.sqlservercentral.com/Forums/Topic1384056-392-1.aspxWould like to Run Stored Procedure on remote server and store the results in temp table.I am hoping Not to use Linked Server Feature.CREATE TABLE #ProdItem (FileName char(100),DwgName char(30),FilePath char(400) )1. Make a remote connection to the server ( I dont want to use the linked server if possible ) Server Name : ServerDwg2. Run a Stored Procedure on Remote Server (ServerDwg) and store the output of the stored Procedure in the temp table #ProdItemTue, 13 Nov 2012 06:35:37 GMTskb 44459