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