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'.