How to check if SQL is Reachable from the Orchestrator Server using the same credentials as what Orchestrator is using if additional software cannot be installed on the Orchestrator Server?
- In file explorer, under view, ensure File name extensions are enabled
- Create a blank test doc on the desktop called testdoc.udl
- Open the document
- Attempt to connect to the SQL server using the same credentials Orchestrator uses to connect. (See screenshot below.)
- Click Test Connection .