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
Post a Comment