Unable to connect to remote SQL Server database over Named Pipes even though local database can be connected

If you are using Named Pipes to connect to a remote database, you may need to add Windows Credentials. Refer to the following steps:

  1. Open the Windows search bar (or press Win + Q), enter "Windows Credentials" and then select Manage Windows Credentials.

  2. Click Add a Windows credential.

  3. Enter the IP address, username and password of the remote database.