How will you validate whether the linked server properly configured / not ?

Answer:

Scenario:
1.You are in Server1
2.You have configured a linked server to access the Remote server(Server2)
3.How will you validate whether the configured linked server to the Server2 is properly configured or not ?

Solution:
1.Login into Server1
2.Execute the script given below to validate the remote server accessibility.

EXEC sp_testlinkedserver N'Server2'

Result:
The result should be : Command(s) completed successfully.

If it throws an Err like : "Server 'Server2' is not configured for DATA ACCESS" then, You have to give Data Access server option.

Use Master

Go

EXEC sp_serveroption @server=N'Server2', @optname=N'data access', @optvalue=N'true'

Now, Try to validate again

EXEC sp_testlinkedserver N'Server2'

Result:
The result should be : Command(s) completed successfully.