ODBC Connectivity

  • I am running SQL Server 2019 on my local PC - Windows 10 pro x64.

    I have an MSAccess application that uses a ODBC DSN to connect to the database.

    I am trying to connect instances of this application from other PCs running Windows 11.  I cannot create a ODBC DSN from those machines to the Sql Server instance on my machine.  The setup sees the server, but the login will fail.  I am using the version 18 driver for SQL ODBC.  I have enabled remote connections on the SQL Server instance, tried using a SQL login and PW.

    Can anyone shed some light on why I cannot connect?

     

    Thanks,

     

     

     

  • What do the Error logs show in MSSQL?

    There are so, so many possible reasons for the issue; you will need to be a lot more specific. First though, carefully check the errors in MSSQL (and the OS Security Event Log) for info.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply