This question is related to the question
but I can't find the link to ask a related question
The problem is "ms/access link to sql/server express" is not working"
I have a working app in ms/access that uses, as backend, sqlserver express.
It is working, but now I need to deploy to a proper server, not on my development computer.
1. I Installed sql server express en MMSM, backed up my DB and restored it to the server. Verified connection and it is perfect. I can even edit table contents using MMSM
2. Now I need to create a link to it
2.1 created a new user (bddplus) which is a database (not windows) user
2.2 tested connection (was OK) - screenshot 1
2.2 view/edit table (was OK) - screenshot 2
3. started access and initiate the set up of link to tables in the DB (always on the server computer)
3.1 start - screenshot 3
3.2 link wizard - screenshot 4
3.3 select new data source - screenshot 5
3.4 select data source source - screenshot 6
3.4 ODBC driver as recommended (screenshot 7, 8, 9)
3.5 server/ selection (NOTE: no server shows on the list in the server name box, so we need to input it directly) screenshot 10
3.6 details of the data source screenshot 11, 12 & 13
3.7 tests failed screenshot 14
It is Portuguese, and the error states "the certificate chain was issued by a non-reliable authority
Below I am embedding the images.
Is there another manner to connect? Can anyone help?