java连接数据库sa登陆失败
数据库连接错误com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dao.BaseDao.getConn(BaseDao.java:25)
at dao.BaseDao.main(BaseDao.java:89)
--------------------编程问答-------------------- 你用是的sql server数据库吧! 你在数据库那方访问过没有? 那边可以登进去吗?
如果不可以 看看相关的服务是否启动
如果可以 那就请认真检查你自己的程序了 看看驱动那些写错没有呢 你把链接数据库的code贴上来瞧瞧呢!
还有 LZ 这问题 你先百度过没有 百度上面有很多哟.. --------------------编程问答-------------------- 看下你数据库的身份验证方式是不是混合安全验证,默认情况下,是采用集成的Windows安全验证且禁用了sa登录名滴、、 --------------------编程问答--------------------
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {给你参考
int id=Integer.valueOf(request.getParameter("id"));
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://127.0.0.1:1433;database=test;";
// ��ݿ��û���
String username = "sa";
// ��ݿ�����
String password = "123";
// ����Connection����
Connection con = DriverManager.getConnection(url,username,password);
String sql="delete from tb_book where id=?";
PreparedStatement ps=con.prepareStatement(sql);
ps.setInt(1,id);
ps.executeUpdate();
ps.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
补充:Java , Eclipse