SQL Server does not exist or access denied error

[TelmoERF96]

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)

[Agnius]

Well, you have either:

1. provided an incorrect server name
2. provided incorrect credentials
3. provided a server that is not accessible from your machine (maybe you're outside of the network)
4. 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.

[TelmoERF96]

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]

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]

Certainly, here is the connection string

[Srini007]

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

[Agnius]

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.