I can't connect to azure sql server with my android app.

Question

I can't connect to azure sql server with my android app. I'm using jtds jar for connecting to sql server but I can't. Android studio giving this error: "E/Error is: Login failed for user 'sharkman'." How can I connect to my sql server?

Answer 1

Please make sure are trying to get connected correctly. Try something like below:

try {

    String SQL = "select * from dbo.Student";

    Class.forName("net.sourceforge.jtds.jdbc.Driver");
    String url = String.format("jdbc:jtds:sqlserver://***.database.windows.net:1433/<your database name>;user=***;password=***;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;");
    conn = DriverManager.getConnection(url);

    stmt = conn.createStatement();
    rs = stmt.executeQuery(SQL);

    while (rs.next()) {
        System.out.println(rs.getString("name"));
    }
    close();
} catch (Exception e) {
    e.printStackTrace();
}

I hope this YouTube video helps you go through all the steps.

Answer 2

Let me know if this article (example) works for you.