i am able to query linked server using openquery
but when i try to access table directly it give error

Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'SQLOLEDB'.


i am connecting as sa so security is not an issue

also all othere database from linked server are working this is new database which i attached

sanjit

some thoughts. I like to use domain accounts that have been registered across the linked servers. Otherwise, some ports can be blocked on the linked server.