You’re offline. This is a read only version of the page.
5
Myself configured SERVER1 and SERVER2 connected to DOMAIN CONTROLLER.
Everything is working fine.
While using the REGISTER SERVER from SSMS on Server (SERVER2) is configured / accessing for SERVER1.
Your steps are working till this point.
While doing the SAME STEPS on SERVER1 for accessing SERVER2
then
ERROR
TITLE: Edit Server Registration Properties
------------------------------
Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
But REGISTER SERVER from SSMS on SERVER1 is NOT CONFIGURING for SERVER2 for which IP Address (1433) is added on TCP/IP under Configuration Manager.
BOTTOMLINE: SERVER2 able to ADD SERVER1 but SERVER1 is NOT ADDING SERVER from SSMS
The Above Error must be common perhaps unable to decipher as myself is learner and Patrons / Experts could you please help me to deduce to solution.
Thanks in advance.
Share
Report
All responses (
Answers (
