又有问题了~~~`Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e4d'

[kekeke]

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

[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'NT4\IUSR_NT4' 登录失败。

//global.asa，行13



哎，烦死了~~~

[popcode]

新建一个用户，然后把uid=用户名;pwd=密码"

[nickycheng]

global.asa的代码贴出来啊....

[nickycheng]

global.asa的代码贴出来啊....

[kekeke]

<script language=vbscript runat=server>

sub Application_OnStart

databaseconn="driver={sql server};database=webdatabase;server=10.31.4.2;uid=sa;pwd="

Application("web_connstr")=databaseconn

Set conn=Server.CreateObject("ADODB.CONNECTION")

Set rs=Server.CreateObject("ADODB.RecordSet")

conn.open databaseconn
///应该是这里的问题，13行
sql="SELECT name,value FROM global"

rs.open sql,conn,1,1

do while Not rs.Eof

[kekeke]

<script language=vbscript runat=server>

sub Application_OnStart

databaseconn="driver={sql server};database=webdatabase;server=111.111.111.111;uid=sa;pwd="

Application("web_connstr")=databaseconn

Set conn=Server.CreateObject("ADODB.CONNECTION")

Set rs=Server.CreateObject("ADODB.RecordSet")

conn.open databaseconn
///应该是这里的问题，13行
sql="SELECT name,value FROM global"

rs.open sql,conn,1,1

do while Not rs.Eof

[nickycheng]

SQL的权限不够咯...

[kekeke]

要怎么办？