I am problem with the sql server connection.
I was following connection string with sql server.

set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="Provider=SQLOLEDB.1;Integrate d Security=SSPI;Persist Security Info=False;Initial Catalog=dcil;Data Source=DCIL2"
cn.Open

now it give following error


Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
/cather/trip.asp, line 87


Above connect I was using. But due to some problem in my computer, I have to formated the drive and re-install necessary software. When I load my site on localhost, the above connection not working.

I create New connection string with the "MS ADO DATA CONTROL VERSION 6.0 "
But it give same error.
Before foramte my hard drive above connect was working, but after formatted the drive It not working why ?
What is the problem ?

Mateen

When you reinstalled IIS, did you also set up the IUSR_<server> account, the account IIS uses for anonymous access?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

thanks for response.
I reinstalled IIS but I not set up the IUSR_<server> accout,
I create new PWS and move all file to new directory,
now it is working.