Port opened, I am able to telnet
Portquery also resolved successfully.
As part of my troubleshooting, I found the below points.
SQL Server 2012 sp4
1. From the 3rd server "SQL Management Studio (Version 18.2)" I couldn't able to connect SQL DB.
2. Whereas from the other two application servers, from "SQL Management Studio" I can connect SQL DB.
What login type do you use? SQL login or Windows login?--Windows domain account.SQL Error-4.jpeg
What is the OS version on application servers?--Windows Server 2012 R2 standard
Are all computers in the same domain?--All are in the same domain only
What error message is reported? -- PFA
Firewall rule also allowed in advanced rules 1433 allowed
While connecting to odbc getting this errorSQL Error-5.jpeg
Still, issue not resolved.
Please find attached error and suggest.
I have installed and checked, but still the same issue. Any suggestions?
Download PortQry and check whether all necessary posts are open on the 3rd server.
The older PortQry version offers UI.