/
SQL Server Error (Narrowed to DNS issue)

SQL Server Error (Narrowed to DNS issue)

Owned by Albert Saludaga
Last updated: Jul 02, 2024
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.

The important steps, once we narrowed it down to DNS issue:

  1. Checked the DNS server on the DC (.200) since that's our DNS server

    1. Verified that neither tbrep.ticketboat.local was in the forward zone

    2. and that 192.168.10.204 was not in the reverse zone

  2. Tried restarting the DNS server on the DC, that didn't work

  3. Went to TBRep (.204) and did an ipconfig /renew on the adapter to get it to reregister

Add label

Related content