Connecting DB using MSSQL

0
Hi All, Can anyone please suggest how to connect the database by using MS SQL server? Thanks in Advance!
asked
3 answers
2

Hi Saranya,

- Create a database in MS SQL server

- In Mendix, under the project tab in the file explorer open your settings.

- Open one of the configurations

-Set database type to MS SQL Server

- Set the correct name and authorisation, standard URL is localhost:1433 I believe

Now you can start your app and it should work. If there is a pop-up click on synchronize database.

Or is there a more specific problem?

 

answered
0

I'll add a new answer so I can show it on a screenshot.

Run SQL server configuration manager.

Under network configuration see protocols for MSSQLSERVER.

Check that TC/IP is enabled. IF not right click and enable it.

answered
0

Hi Matteo,

Here the snapshot for your reference

 

answered