Dear friends,

I am trying to connect SQL server 2000 with ASP through the DSN.My connection string is defined in global.asa file.While browsing the site I am getting folowing error.Please help me. I am sure that you can help me.

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
//global.asa, line 12


Please check the following connection string which i am using in global.aso
Set cn = Server.CreateObject("ADODB.Connection")
--------------- provstr2= "PROVIDER=MSDASQL;dsn=CEC_Cal;uid=Administrator;pw d=servoking;database=calender;"
cn.Mode=adModeReadWrite
cn.Open provstr2
-----------------------------------


Hopes for the Best..Thank you


Graceson Mathew

Have you read this?

http://www.xlinesoft.com/asprunner/d...chine_name.htm