ASP连接SQL出错,急急急!给分

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

[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'IT-64636CA60441\IUSR_IT-64636CA60441' 登录失败。

/ygmr/includefile/condate.asp,行3

连接代码如下:
<%dim xlconn
set xlconn=server.createobject("adodb.connection")
xlconn.open "DSN=ygmr;UID=ygmrstar;PWD=star_ygmr"
function charvalidate(msgid)
if msgid="" or not isnumeric(msgid) then msgid=1
msgid=left(msgid,9)
msgid=int(msgid)
charvalidate=msgid
end function
%>
[580 byte] By [zmjls] at [2008-1-9]
# 1
try: xlconn.open "DSN=ygmr;UID=ygmrstar;PWD=star_ygmr","ygmr","star_ygmr"
cpp2017-慕白兄 at 2007-9-30 > top of Msdn China Tech,Web,ASP...
# 2
兄弟不要用DSN连啊,对你以后发展不好.
<% dim connstr,conn
connstr= "Driver={SQL Server};server=(local);uid=sa;pwd=000;database=wkk;"
Set conn = Server.Createobject("ADODB.Connection")
conn.open connstr%>
nerissa-小新新 at 2007-9-30 > top of Msdn China Tech,Web,ASP...