I have successfully created an on premise gateway to a 2019 server and have 2019 SQL Express installed as well. Using an ODBC product, I have created a linked server instance for SQL server. When I try to add a SQL server connection in Power Apps, I choose:
- SQL server authentication
- Use the SQL server name as <computername>\SQLEXPRESS
- Use linked server object name (also shown in linked server properties)
- Use sa as username
- Use password for sa
- Use gateway name that appears
I get an authentication error that credentials are missing or not valid.
On the security tab on the linked server properties, I also added a local account administrator; authentication is allowed for Windows and SQL. I tried that, too, but get the same error.
Are linked servers allowed in SQL on premise connector? Am I missing a correct setting?
Thanks in advance. Really anxious to get this to work.
