I’m migrating a smallish MS Access database to SQL Server. I’ve installed new instance of SQL Server 2022 Express on a Win10 box.

Setup was done pretty much with all the defaults. Processed database backend through SSMA. All tables seem to be migrated successfully. Data is visible on the server box.

Now I’m attempting to connect from a separate machine on the domain network. I cannot connect via Access and just trying to establish connection via ODBC at this point. Continually getting failed connection tests. It seems to be an networking issue.

I’m sure it’s a basic problem I’m missing with the connection. I’ve been beating this up for several days. I sincerely appreciate ANY assistance.

In Server Config Mgr, protocol set to use port 1433. I have checked firewall. Port 1433 is opened. All machines are domain joined. I can connect to the server via RDP. I can map a network drive on the server (just to prove to myself that I can access the server).

All services appear to be running. I have multiple ODBC drivers installed on client… none seem to work.
Screenshots below. server name: RWP02 db: genysis

Server services:

Server remote connections:

Server ports:

Server firewall:

Client driver list:

Client server select:

Client connect error: