OpenRowSet query being refused

[JayKusch]

I have an instance of 08R2 running on my box with an instance of 05SP3.

Running the query in the 05 instance returns the result sets from the remote server just fine.

When I run it from the R2 instance it failes with the followig error:

OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Login timeout expired".

OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".

Msg 10061, Level 16, State 1, Line 0

TCP Provider: No connection could be made because the target machine actively refused it.

The code I am running is ...

SELECT DISTINCT 'MyServer', [name]
FROM OPENROWSET('SQLOLEDB', 'Server=MyServer;Trusted_Connection=yes;',
'SELECT [name] FROM [master].[sys].[syslogins] WHERE [name] IS NOT NULL') AS a;

I am able to connect to the R2 instance from my laptop via Mgt Studio just fine.




Thanks

J. Kusch

 

[awesomeamy]

Did you reboot at least 3 times to see if the problem resolved?

 

[DarwinIT]

I believe openrowset requires that you configure the server. Perhaps you have configured one instance and not the other?