I have 2 different virtual server and both has own sql database. I named A and B them. B's sql database added as linked server on A server. I can run query on A server for B's database. Bu when I try with mobile application which connect to A database I can't get any data. When tracking with sql profiler,query run on A server but I can't see it on B server.
Thanks in advance
First, check the security settings for the linked server on Server A. In SQL Server Management Studio, go to Server Objects -> Linked Servers -> (Your Linked Server) -> Security, and ensure the connection is using a valid SQL login that has access to Server B.
Also, if your app uses Windows Authentication, try configuring the linked server to pass the correct credentials. If that doesn’t work, check if the RPC OUT option is enabled for the linked server (sp_serveroption YourLinkedServer, rpc out', true).
Lastly, test running the same query manually from Server A while logged in with the same credentials your app is using