SQL Server does not exist or access denied error

Like (0) Share

Report

Posted on 4 Oct 2023 11:13:14 by TelmoERF96

167

Hello again everyone,

I am having trouble trying to connect to a SQL Server Database and send a datatable I created and populated in Power Automate Desktop to said database. I really don't understand what could be wrong, the flow stalls "thinking" while trying to connect for a few seconds and then the error appears. The credentials are correct, this is how my flow is looking and the error it gives me.

Sorry had to cover the string for security reasons.

And these are the details of the error:

ID de Correlação: 21816d15-3829-4dfb-99c3-101f8e9fbe0c

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Não é possível ligar à origem de dados [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. ---> System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
em System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
em System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
em System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
em System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
em System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
em System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
em System.Data.OleDb.OleDbConnection.Open()
em Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.DatabaseActions.OpenConnection(Variant connectionString, SqlConnectionVariant& connection)
--- Fim do rastreio da pilha de excepção interna ---
em Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.OpenConnection.Execute(ActionContext context)
em Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

All responses (6)

Answers (0)

Agnius Bartninkas 10,045 Most Valuable Professional on 05 Oct 2023 at 07:23:52

Like (0)

Report

Re: SQL Server does not exist or access denied error

Try changing the Provider value to "SQLOLEDB.1" (without the quotes).

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
SriniK 3,025 Super User 2025 Season 1 on 04 Oct 2023 at 17:39:53

Like (0)

Report

Re: SQL Server does not exist or access denied error

Hi @TelmoERF96

Check below documentation for your reference

https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/database

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini
TelmoERF96 167 on 04 Oct 2023 at 12:51:33

Like (0)

Report

Re: SQL Server does not exist or access denied error

Certainly, here is the connection string
Agnius Bartninkas 10,045 Most Valuable Professional on 04 Oct 2023 at 12:38:21

Like (1)

Report

Re: SQL Server does not exist or access denied error

The provider in this case is a driver. If you did not have SQL server drivers on your machine, that could cause the problem, but that should generally not be the case. Can you share your connection string (remove the actual server name and credentials first)?
TelmoERF96 167 on 04 Oct 2023 at 12:06:23

Like (0)

Report

Re: SQL Server does not exist or access denied error

Hello Agnius, thank you for your fast reply
I am already connected to said server in Microsoft SQL Management Studio with the the same server name, and credentials, so the problem I don't think comes from that. And all of this is happening on the company network with company servers. I have another information though, I went to test the connection in the Data Link Properties I get this error.
Do you think the problem could come from the provider here?
Agnius Bartninkas 10,045 Most Valuable Professional on 04 Oct 2023 at 11:18:08

Like (1)

Report
Re: SQL Server does not exist or access denied error

Well, you have either:

provided an incorrect server name

provided incorrect credentials

provided a server that is not accessible from your machine (maybe you're outside of the network)

provided credentials for a user that is not authorized to connect to the server

Please double-check the server name and credentials. Then also try to connect to the same server via a different tool, such as the SQL Server Management Studio or something like that from your machine, and see if it works there.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.