Sapen (11/30/2011)
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" returned message "[ProvideX][ODBC Driver][FILEIO]Table is not accessible".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "AR_Customer" from OLE DB provider "MSDASQL" for linked server "MAS90_LINK".
Yes I am the SYSADMIN and I am using the same windows authentication to connect to the SQLServer with linked server from my laptop through SSMS(from where I am getting the error) and if I do an RDP to the remote Server and connect then I am able to fetch the records. Although I am not able to view the tables from my laptop as well as actual server under the catalogs of the linked server(MAS90_Link).
Try also enabling RPC and make sure the distributed transaction option is TRUE as well. I can't find to much info on these, but I believe that RPC may have something to do with remotely logging into the instance and then accessing a linked server.
Jared
Jared
CE - Microsoft