Install MS SQL server SQLEXPRESS Edition from

https://www.microsoft.com/en-in/sql-server/sql-server-editions-express

After installation go to SQL Server Configuration Manager and enable all the options

Select TCP/IP properties

Configure the port through which you want to connect with SQL Server

Once updated we now enable both SQL server and Windows Authentication in SQL server

We can also create new user through which we want to access the DB

Add the user details

Above changes require a restart of SQL server so please do restart after every change

Please follow this blog to add SQL server DB connector in Mule –

http://www.acesoa.com/2018/05/03/microsoft-sql-server-integration-with-mulesoft/

and use below jdbc string to connect

jdbc:sqlserver://localhost;instance=SQLEXPRESS;databaseName=master;user=root;password=<password>

 

Leave a Comment