[SQL Server]用户 'sa' 登录失败

[zitiger]

[SQL Server]用户 'sa' 登录失败
[SQL Server]用户 'sa' 登录失败。(这个数据库green是存在的)
代码
<%
Dim Conn,ConnStr,Rs,Sql
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "driver={SQL Server};server=zitiger;uid=sa;pwd=;database=green"
Conn.Open Connstr
Set Rs = Server.CreateObject("Adodb.RecordSet")
%>

错误信息
Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'sa' 登录失败。

/green/Conn.asp，行6

[birdzxy]

SQL SERVER是不是混合方式认证呢？

[ldcr520]

dim db As ADODB.Connection
Set db = New ADODB.Connection
db.ConnectionString = "driver={SQL Server};server=(local)或写服务器名;database=databasesname;Persist Security Info=False;user id=sa;"
db.Open

[whitechief]

connstr="driver=sqloledb;......."
试一下。
l