Android Question Best Connection with SQL Server 2022 Express?

jeronimovilar

Active Member
Licensed User
Longtime User
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

Active Member
Licensed User
Longtime User
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?
 
Upvote 0
Top