October 22, 2024 at 5:44 pm
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,
October 22, 2024 at 9:29 pm
October 30, 2024 at 10:54 am
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