java 与sql server2008连接方法？

Question

java和sql server2008怎么都连不上，高手帮忙解决一下。

Answer 1

1.准备驱动程序sqljdbc_1.2（如sqljdbc_1.2.2828.100_chs.exe）将下载解压得的sqljdbc.jar拷到C:\jdk1.6.0_10\jre\lib\ext 下(我把JDK安装到了C:\jdk1.6.0_10中，这里因人而异)2.开启SQL的1433端口利用SQL 配置管理器来配置，选择对应的数据库实例-->选择TCP/IP (启用它，双击出现下面第二张图，写上1433端口)，确定。3.编写测试代码package etonch.com;import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Connsql {/**
* @param args
*/
public static void main(String[] args) 
{
   // TODO Auto-generated method stub   try
   {
    String conURL="jdbc:sqlserver://localhost:1433; DatabaseName=sqljava";
    try
    {
     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
    }
    catch(java.lang.ClassNotFoundException e)
    {
     System.out.println(e.getMessage());
    }    Connection con=DriverManager.getConnection(conURL,"用户名","密码");    Statement s=con.createStatement();
    String query = "create table zg("
         + "eno char(10),"
         + "ename char(15),"
         + "esex char(15),"
         + "gz integer,"
         + "ezc char(15)"
         + ")";
    s.executeUpdate(query);
    String r1="insert into zg values("+"'1002','张小华','男',600,'助工')";
    s.executeUpdate(r1);
    s.close();
    con.close();
   }
   catch(SQLException e)
   {
    System.out.println("SQLException:"+e.getMessage());
   }
}}4.运行测试5.正常应该成功

Answer 2

com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'LocalSystem' 登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2532)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1929)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1917)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1061)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.jsp.db_jsp._jspService(db_jsp.java:71)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
总是用户名不对，sa不行呀。那 是什么呢？