Hi @Zac Watkins
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
Enable TCP\IP protocol and then test it again.
Steps as next:
1 .Turn off your firewall and antivirus software;
2. Enable the TCP\IP protocol both in server and client side and use 1433 port.
3. Restart the SQL Service and try again.
More detail steps :setting-up-management-studio-for-remote-sql-server
More helpful information: how-to-connect-to-a-remote-sql-server
BR,
Mia
If the reply helped, please “Accept Answer” and upvote it.--Mia