How to connect Mule application to SQL Server with Windows Authentication-CodePudding

I have SQL Server installed on my PS. I can connect to it using Windows Authentication and SQL Authentication using SQL Server Management Studio. But, when I try to connect it from Mule it's always a connection error.

Things I've tried so far:

Used default option provided by MuleSoft for SQL Server.
Tried turning my firewall off.
Tried integretaedSecurity=true.
Tried Generic connection and provide my own JDBC URL

No luck so far. Any help please?

CodePudding user response：

It will be good if you can provide the exact error.

But mean while,

Try enabling TCP port in the system.

Below are the steps to enable TCP (in local machine).

Open the 'Sql Server Configuration Manager' application. In the left pane, go to 'SQL Server Network Configuration' -> 'Protocols for [instance-name]' Right-click on 'TCP/IP' and select 'enable'.

Restart the 'SQL Server ([instance-name])' windows service or restart your machine.

CodePudding user response：

You need to ensure that the DLL sqljdbc_auth.dll is in the path of execution for Mule. Note that integrated authentications will work only when Mule is executing in a Windows OS. It will not work if deployed to Linux, CloudHub or Runtime Fabric.

Full instructions: https://help.mulesoft.com/s/article/How-to-use-Windows-Authentication-in-Database-Connector-with-Microsoft-SQL-Server-in-Mule4