Integrate MS SQL Server Express Edition

To show how MuleSoft Integrate with MS SQL Server Express Edition. Let’s start with installing MS SQL server SQLEXPRESS Edition from below url

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://mulesy.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>