Related external database connectivity

0
I got this error when I am trying to connect mendix with  external database. I have used sql server management studio. I have also enable TCP port in sql server configuration management. “Opening JDBC connection to Some(localhost:1433) failed with SQLState: 08S01 Error code: 0 Message: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". Retrying...(2/4)” Please help me .  
asked
1 answers
0

Hi Pranati,

First open SQL Server Configuration Manager

On the left-hand side, under SQL Server Network Configuration, select the protocols for your server instance. Most likely you will now see on the right-hand side that the TCP/IP is “Disabled”. Enable it by right clicking on TCP/IP and selecting “Enable”. Ensure you expose your desired port in the properties (again, right click on TCP/IP and select “Properties”)

In your configurations, ensure that you use integrated security

 

If you don’t want to use the Windows authentication, then you should not use the integrated security. You should then add the username and password of the database user (which you can define in SQL Server Management Studio). In this case, you should also change the allowable authentication on the SQL server. In SQL Server Management Studio, right click the server, select properties. In the left-hand side, select “Security” and under “Server authentication” select “SQL Server and Windows Authentication mode”

Hope it helps!

answered