Trying to add SQL connector to on premise SQL server linked server

(0) Share

Report

Posted on by lmheimendinger

260

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.

All responses (2)

Answers (1)

Verified answer

lmheimendinger 260 on at

Like (0)

Report

Re: Trying to add SQL connector to on premise SQL server linked server

I was able top get an actual database instance created and that worked. Linked server for another day
v-bofeng-msft on at

Like (0)

Report

Re: Trying to add SQL connector to on premise SQL server linked server

Hi @lmheimendinger :

I suggest you check the authentication mode of SQL server.Change authentication it to mixed mode by selecting radio button SQL Server and windows authentication mode and restart SQL Server service again.

I think these links will help you a lot:

Choose an Authentication Mode

Best Regards,

Bof