Connect Java to SQL Server database -- com.microsoft.sqlserver.jdbc.SQLServerException: Login failed

[Gary Grubb]

I am havine an issue connecting my Java code to a remote SQL Server database. I Googled for an answer to this issue, but the answer is always the same, i.e. wrong username & password. I am using this username & password connecting to the same remote database from a VB.NET program on the same server wothout issue.
I can also log in to this database with the same username and password as well.

There has got be be something I am missing. Here is the error message... there isn't anything particularly helpful in the rest of the error stack:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'omnireport'.

public static void main(String[] args) {
      Connection con = null;
      CallableStatement proc_stmt = null;
      ResultSet rs = null;

      try {

         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
         String username = "--removed";
         String password = "--removed--";
         String connStr = "jdbc:sqlserver://--removed--:1433;instanceName=tcs2005test;databaseName=ZCalDBtmp";

         con = DriverManager.getConnection(connStr, username, password);
         if (con != null) {
            // ... extra code deleted
         } else {
            System.out.println("NO CONNECTION");
         }
      } catch (ClassNotFoundException ex) {
         ex.printStackTrace();
      } catch (SQLException ex) {
         ex.printStackTrace();
      } finally {

         try {

            rs.close();
            proc_stmt.close();
            con.close();

         } catch (SQLException ex) {
            ex.printStackTrace();
         }

      }
   }

[Paul Sturrock]

Did you see this discussion?

[Jan Cumps]

Hi Gary. Welcome to JavaRanch.

I have hidden the password and servername in your code. That server seems to be reachable from the internet.