I've installed SQL Server Express 2019 on a Domain Controller.
Yes I know Microsoft suggest to use a Server or at least another stand alone PC, but for now the office is not in a financial situation to pay for a new server.
In Access 365, I started adding linked tables from External data in ribbon, New Data Source - From Database - From SQL Server.
Then selected Link to the data source by creating a linked table in the next window.
I created a new DSN Connection to the server using Windows Authentication and received a TESTES COMPLETED SUCCESSFULLY.
But when the list of tables in target database opens, It's full of a lot of tables starting with sys.
None of other tables that contain data is shown.
If I create the DSN Connection using sql server authentication, I have the full list of the tables I need.
Note: There's no problem between clients and server. The domain has been up and running for more than 5 years and each client machine can access the server resources according to their rights.
Is there anything in SQL Server's Database option that I have to check?
Thanks for any insight.
Yes I know Microsoft suggest to use a Server or at least another stand alone PC, but for now the office is not in a financial situation to pay for a new server.
In Access 365, I started adding linked tables from External data in ribbon, New Data Source - From Database - From SQL Server.
Then selected Link to the data source by creating a linked table in the next window.
I created a new DSN Connection to the server using Windows Authentication and received a TESTES COMPLETED SUCCESSFULLY.
But when the list of tables in target database opens, It's full of a lot of tables starting with sys.
None of other tables that contain data is shown.
If I create the DSN Connection using sql server authentication, I have the full list of the tables I need.
Note: There's no problem between clients and server. The domain has been up and running for more than 5 years and each client machine can access the server resources according to their rights.
Is there anything in SQL Server's Database option that I have to check?
Thanks for any insight.