关于ASP数据库连接问题，超晕，有时能连上，有时连不上。请高手指教。

[zsy5218]

我Z做的网站是用ASP做的，数据库为SQL server2000.我数据连接验证是用的WINDOWS用户验证。在建立脚本是能测试连接上数据库，但在网页预览时数据库有时连接上，有时就连不上，错误为：Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'ZRY\IUSR_ZRY' 登录失败。请高手指教。

[jspadmin]

连接代码贴上来

[leohuang]

为啥用信任连接泥,直接用SQL Server的验证不行?

还有权限的吗?

[zsy5218]

代码一部分是<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/zz.asp" -->
<%
var Recordset1__MMColParam = "2005-3-13 15:27:22";
if (String(Request.Form("mm")) != "undefined" &&
String(Request.Form("mm")) != "") {
Recordset1__MMColParam = String(Request.Form("mm"));
}
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_zz_STRING;
Recordset1.Source = "SELECT MonthDataTime, DustDensity, DustTotal, SO2Density, SO2Total, NOXDensity, NOXTotal, CO2Density, CO2Total, CODensity, COTotal, HCLDensity, HCLTotal, SmokeTemp, SmokePressure, SmokeTotal, SmokeO2, SmokeMoisture FROM dbo.MonthData WHERE SN10='3713060101' and MonthDataTime = '"+ Recordset1__MMColParam.replace(/'/g, "''") + "' ORDER BY MonthDataTime ASC";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
Recordset1_numRows += Repeat1__numRows;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
Recordset1_numRows += Repeat1__numRows;
%>
对应的zz.asp代码为
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_zz_STRING = "dsn=ZS;"
%>

[zsy5218]

各位帮帮忙吧。我急用。谢谢 。如果我直接用SQL验证那怎么设，郁闷呀，现在彻底连不上了。帮~~~~~~~~~~

[leohuang]

连接字符串这么写
Provider=SQLOLEDB.1;Data Source=服务器名;User ID=用户名;Password=密码;Intial Catalog=数据库名

打开你的SQL 企业管理器,展开SQL Server组,在你的SQL Server服务器上点右键,选择"属性"->选择"安全性"标签,在身份验证中选中"SQL Server和Windows"确定确定确定...
再试一下