Android Question RDC - SQL Express 2008

[RDCrozier]

Has anyone managed to get this working with SQLEXpress 2008 R2? If so then what did you use for the server and database name in the config.properties file on the JdbcUrl line... Whenever I try the web connection to the server it comes up with the message:

RemoteServer is running (Thu Aug 08 16:23:13 BST 2013)
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

Which would signify that it is in fact working but not connecting to SQLExpress. Normally to access SQLExpress you specify the string .\sqlexpress instead of the IP address that would normally be present but this doesn't seem to work

 

[Erel]

Note that there might be more information in the DOS console.

Can you post your JdbcUrl?

This link might be helpful: http://social.msdn.microsoft.com/Fo...-486d-a57a-78b90d7ccceb/jdbc-with-sql-express

 

[citywest]

It will likely be permissions on the SQL instance.

It's easiest to troubleshoot if the RDC is running on the SQL box. That way you can connect to 127.0.0.1 which SQL treats as a secure connection. Ensure that the SQL instance has a binding to port 127.0.0.1, TCP is running and SQL is a single instance. Also ensure that Mixed Mode Authentication is being used on the SQL Instance.

If you are not running a single instance of SQL then you will have to append the instance name to the 127.0.0.1. It's easiest if you play around with ODBC connections in Control Panel first to a) ensure that things are working and b) you know which connection strings work.

You may also have to change the user context of RDC if it is running under a service account. Ensure this user has sufficient privileges to access your Database i.e. run it under a "real" user account that can access SQL and your database(s).

This should you get you a working although insecure setup. So start implementing whatever security etc you are comfortable with then a step at a time.

If the RDC is located on a different machine you need to make sure that the SQL instance "Accepts Remote Connections".

Good luck,

Mark S.