SQL Server does not exist or access denied error

(0) Share

Report

Posted on by TelmoERF96

170

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)

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
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.

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

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)?

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like (0)

Report

Certainly, here is the connection string

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No