Unable to connect to SQL server in standard logic app using built-in SQL server connector

Question

Unable to connect to SQL server in standard logic app using built-in SQL server connector

Ren 21

Hi I am using standard logic app built in sql server connector to connect my on prem sql server DB. Authentication is the connection string Server={your-server-address};Database={your-database-name};User Id={your-user-name};Password={your-password}; format. However, I am getting login failed for the user. I can connect to DB without any issues on SSMS. could the domain name cause issues? e.g. contoso\userID? Please advise. Thanks

JananiRamesh-MSFT 29,236 Reputation points

2024-02-21T03:32:00.8066667+00:00

@Ren Thanks for reaching out. Did you try modifying the connection string to include the domain name like this: "Server={your-server-address};Database={your-database-name};User Id=contoso{your-user-name};Password={your-password};". Please try this and let me know if it resolves your issue.
Ren 21 Reputation points

2024-02-21T03:39:01.25+00:00

yes, I did. I passed server's internal name, db name, doman/username and psw. It is a windows authentication for sql server.
JananiRamesh-MSFT 29,236 Reputation points

2024-02-21T04:06:57.72+00:00

@Ren Thanks for the update. were you able to connect or still facing the same issue ?
Ren 21 Reputation points

2024-02-21T04:13:18.2266667+00:00

same issue. getting login failed, hence, posted the question in community.
Greg Low 1,935 Reputation points Microsoft Regional Director

2024-02-21T08:15:00.46+00:00

Without doing what Janani recommended, there's no way for the Logic App to know about your domain, so you can't use Windows authentication. If you do have connectivity to the DB engine, and you're getting a login failure, you might try using a SQL login instead. You'd just have username and password (and no domain in the username, just the domain)
But the one that Janani mentioned sounds good.
JananiRamesh-MSFT 29,236 Reputation points

2024-02-22T17:27:13.3733333+00:00

@Ren Did you get a chance to see my previous response? Do let me know incase of further questions I would be happy to assist you.
Greg Low 1,935 Reputation points Microsoft Regional Director

2024-02-27T23:33:04.91+00:00

See what it says in the SQL Server error log on the target server.
JananiRamesh-MSFT 29,236 Reputation points

2024-02-29T06:00:15.4233333+00:00

@Ren did you get a chance to see my previous response. If you found the answer to your question helpful, please take a moment to mark it as "Yes" for others to benefit from your experience. Or simply add a comment tagging me and would be happy to answer your questions.

Accepted answer

1 additional answer

Your answer

JananiRamesh-MSFT 29,236 Reputation points

2024-02-21T03:32:00.8066667+00:00

@Ren Thanks for reaching out. Did you try modifying the connection string to include the domain name like this: "Server={your-server-address};Database={your-database-name};User Id=contoso{your-user-name};Password={your-password};". Please try this and let me know if it resolves your issue.
Ren 21 Reputation points

2024-02-21T03:39:01.25+00:00

yes, I did. I passed server's internal name, db name, doman/username and psw. It is a windows authentication for sql server.
JananiRamesh-MSFT 29,236 Reputation points

2024-02-21T04:06:57.72+00:00

@Ren Thanks for the update. were you able to connect or still facing the same issue ?
Ren 21 Reputation points

2024-02-21T04:13:18.2266667+00:00

same issue. getting login failed, hence, posted the question in community.
Greg Low 1,935 Reputation points Microsoft Regional Director

2024-02-21T08:15:00.46+00:00

Without doing what Janani recommended, there's no way for the Logic App to know about your domain, so you can't use Windows authentication. If you do have connectivity to the DB engine, and you're getting a login failure, you might try using a SQL login instead. You'd just have username and password (and no domain in the username, just the domain)
But the one that Janani mentioned sounds good.
JananiRamesh-MSFT 29,236 Reputation points

2024-02-22T17:27:13.3733333+00:00

@Ren Did you get a chance to see my previous response? Do let me know incase of further questions I would be happy to assist you.
Greg Low 1,935 Reputation points Microsoft Regional Director

2024-02-27T23:33:04.91+00:00

See what it says in the SQL Server error log on the target server.
JananiRamesh-MSFT 29,236 Reputation points

2024-02-29T06:00:15.4233333+00:00

@Ren did you get a chance to see my previous response. If you found the answer to your question helpful, please take a moment to mark it as "Yes" for others to benefit from your experience. Or simply add a comment tagging me and would be happy to answer your questions.

Answer 1

webserverforum 65

The error message "login failed for the user" is definitely showing either user name is incorrect or the password you are using is incorrect. If you are able to connect successfully using these details in management studio then make sure you are using correct SQL server hostname in your app. Check that the SQL server hostname you are using in app, point to correct server IP address of your SQL server. You can check it by using ping command

Answer 2

JananiRamesh-MSFT 29,236

@Ren Thanks for the update. As per this doc https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure?tabs=consumption#connect-to-on-premises-sql-server To connect to on-premise SQL server it requires on-premise data gateway to be installed and Windows authentication is supported only with the SQL Server managed connector.

User's image

do let me know incase of further queries, I would be happy to assist you.

Ren 21 Reputation points

2024-02-23T00:24:31.5233333+00:00

Hi Jannani, Used SQL Login user for the connection string and still having login failed for user error. I can connect to DB with SQL users without any issues in SSMS. Using the built-in connector below for logic app standard.
JananiRamesh-MSFT 29,236 Reputation points

2024-02-28T04:04:53.5866667+00:00

Ren Thanks for getting back. From the error message login failed for the user indicates either username or password you are using is incorrect. If you are able to connect successfully using these details in SSMS as mentioned by webserverform make sure you are using correct SQL server hostname in your app.

do let me know incase of further queries, I would be happy to assist you.

Please accept as Yes if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.

Share via

Unable to connect to SQL server in standard logic app using built-in SQL server connector

1 additional answer

Your answer