I gave you a wrong version for the sql server..please find the correct ones below

Linked server is set up of sql...

/****** Object: LinkedServer [MAS90_LINK] Script Date: 11/30/2011 15:26:01 ******/

EXEC master.dbo.sp_addlinkedserver @server...

I am not much familiar with adding users to the mas90 providex database. I will look for resources that would help me with it.

But I just created a login on...

When I say remote connection I am using SSMS to connect to DB Server from my laptop instead of connecting from the SSMS from the DB Server directly. I am...

I just used the same username and password that I am using in the provider string in "Be made using this security context". Still no luck.

So should these credentials be added to the sql server too?

I have tried running the queries both the ways and still no luck

SELECT count(*) FROM MAS90_LINK...AR_Customer

SELECT * FROM OPENQUERY(MAS90_LINK, 'SELECT count(*) FROM AR_Customer')

I havent setup anything in the security part of the linked server properties. But in the provider string, I am using the username and password to connect to the mas90...

Forgot the Mention that I am using SQL Server 2005 Standard Edition. I have enabled the RPC but still ended up getting the same error. I dont see the distributed...

If you want use the profiler then the below blog might be helpful too.

http://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/

Thanks for you inputs Jared.

I have just enabled the RPC out and executed my query and I end up getting the below error:

OLE DB provider "MSDASQL" for linked server "MAS90_LINK"...

I have

Data Access set to True

Use Remote Collation set to True

and all the others set to False

with a blank in the collation name and 0's for Connection timeout and...

Any updates please.

The thing is I am able to select data from table AR_Customer thru my select query under the linked server but not able to see anything in the catalogs under...

I was able to create the linked server connection. But not able to see any tables under the catalogs of the linked server.

but when i test the connection string...