Cannot Connect Access To Sql Server Linked Tables - Error Message Loggingin

I have a client for which I am setting up a new SQL Server Express and (on a different computer) connecting their Access front end to that SQL Server. I created an account on SQL S

Solution 1:

To connect to a named instance on SQL Server Express with Servername\SQLEXPRESS, you need:

1. SQL Server Browser service running, and its UDP port 1434 open in the firewall.

https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access

SQL Server Browser serviceUDP port 1434 The SQL Server Browser service listens for incoming connections to a named instance and provides the client the TCP port number that corresponds to that named instance.

2. The fixed TCP port for your instance open in the firewall. You set this in SQL Server Configuration Manager

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port

Solution 2:

This looks more like a network setting rather than server issue.

Check if all necessary permissions, configuration and settings on your machine running the server are OK to accept external connections.

Usually its the server that is rejecting the connection for security reasons.