You have several SQL Servers in your organization that participate in linked server queries, with security configured as shown in Table 14-3. BobH complains that the linked server queries are not working. What can’t BobH use linked server queries?

You have several SQL Servers in your organization that participate in linked server queries, with security configured as shown in Table 14-3. BobH complains that the linked server queries are not working. What can’t BobH use linked server queries?

You have several SQL Servers in your organization that participate in linked server queries, with security configured as shown in Table 14-3. BobH complains that the linked server queries are not working. What can’t BobH use linked server queries?


Answer: – The users who cannot access the linked server use standard logins, so you need to map a linked server login by executing sp_addlinkedsrvlogin on the local server.

(For users who use standard logins to access a linked server, you need to map a local login to a login on the remote server using the sp_addlinkedsrvlogin command.)