Android Question Best Connection with SQL Server 2022 Express?

[jeronimovilar]

How the best conection (fast and security) with Sql Server 2022 Express (windows)? I tryed JDBC (mssql-jdbc), but not connect
My MS SQL SERVER and Android App are in Intranet (192.168.0.xxx)

 

[Chris2]

I used a app to testing port range, and 1433 is closed, 1434 is openned

I'd suggest you go back to the beginning and check the settings of your SQL Server.

Check TCP/IP access with SQL Server Configuration Manager and confirm which port is being used - https://peter-whyte.com/2020/04/how-to-enable-tcp-ip-connections-in-sql-server/
Check you can log in to SQL Server Management Studio with the user and password you're using.

Also, can you confirm please, are you trying to connect directly to SQL Server from a B4A phone app, or are you using a B4J server ( jRDC2) app?

 

[chej]

Hello.
I followed the same path as user 'QSerg', even for an intranet.

I suggest that to verify the connection to the SQL server, you try connecting to it from another PC to check if it responds, along with the username and password.

Translated by Google.

 

[MrKim]

Been there done that I have had it working for years. IT WILL NOT WORK WTH THE MS DRIVER. See this post:
https://www.b4x.com/android/forum/threads/mssql-jdbc-minimalistic-example.90548/post-591195

However jRDC2 IS the best solution. I did it direct because of multiple customers with servers over which we have no control and their IT departments who think java on their servers is too dangerous.