java - Cannot open database “” requested by the login. SQL server -


i'm using following database connect sql server 2014.

private static final string jdbc_driver = "com.microsoft.sqlserver.jdbc.sqlserverdriver"; private static final string db_url = "jdbc:sqlserver://xx.x.xx.xxx:1433; databasename=dbname"; private static final string username = "username"; private static final string password = "password";  connection conn = null;     try {         class.forname(jdbc_driver);         conn = drivermanager.getconnection(db_url, username, password);      } catch (exception ex) {         system.out.println("db connection failed: " + ex);     }     return conn; 

but gives following error

com.microsoft.sqlserver.jdbc.sqlserverexception: cannot open database  requested login. login failed. 

mssql queries correctly executing when in editor. please resolve issue.

in db_url line, try replace "databasename" property "database" instead. gives :

private static final string db_url = "jdbc:sqlserver://xx.x.xx.xxx:1433; database=dbname"; 

hope helps.


Comments