1 Answer
- Newest
- Most votes
- Most comments
0
In addition to checking whether Named Pipes are configured, verify that the server name is resolvable from the device initiating the connection, verify port 1433 and 1434 are permitted inbound from the device you are testing from, and also verify that outbound communication is permitted for return traffic i.e. ephemeral ports are open outbound and also permitted by any firewalls in between. A more simplistic way to test is to leverage UDL files to test connectivity documented here - https://docs.microsoft.com/en-us/sql/connect/oledb/help-topics/data-link-pages?view=sql-server-ver15
answered 4 years ago
Relevant content
- Accepted Answerasked 2 years ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 10 months ago