请教一下SQL的连接问题。希望大家帮忙

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://cm-zy:1433;DatabaseName=books";
// String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books";
//更改了名称还是连接不上：localhost，.，机器名 
Connection conn=DriverManager.getConnection(url,"sa","963852741");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String query="Select * from traffic";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
String s=rs.getString("name");
out.print(s+"<br>");
}
%>
</body>
</html>
代码基本就是这样。运行程序之后提示：
javax.servlet.ServletException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.home.index_jsp._jspService(org.apache.jsp.home.index_jsp:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)它提示连接不上SQL。但我已经换成不同的连接方式了。第一次用JAVA使用SQL。还请大家帮忙。谢谢