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

Integrate MS SQL Server Express Edition

 

Select TCP/IP properties

Integrate MS SQL Server Express Edition

 

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

Integrate MS SQL Server Express Edition

 

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

Integrate MS SQL Server Express Edition

 

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>

 

  
Thank you for taking out time to read the above post. Hope you found it useful. In case of any questions, feel free to comment below. Also, if you are keen on knowing about a specific topic, happy to explore your recommendations as well.
 
For any latest updates or posts on our website, you can follow us on LinkedIn. Look forward to connecting with you there.


Share this:
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments