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

 Posted by PandianS on 8/25/2010 | Category: Sql Server Interview questions | Views: 3529 | Points: 40
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.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response