Hi There, I'm running XP pro, Internet Information Server 5.1 and SQL Server 2000.

Now, I've created a simple website which is suppose to log a user into my system, but I keep getting this error message:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'XBOX\IUSR_XBOX'.
/ERP/Default.asp, line 14


can someone please tell me how to rectify the problem... now I know it has something to do with the user restrictions but I don't know how to create it in SQL server or IIS. I'm basically a beginer who is trying to ctach up on web development.

Thank you in advance for any help.

- Adam.

I believe that SQL Server doesn't like uderscores in user names, in any case I use my administrator account details for the anonymous user account details in IIS.

In Windows 2000:
Start >> Programs >> Adminastrative Tools >> Internet Services Manager >> Right click on Default Web Site and select properties, Click the Directory Security Tab, in the Anonymous access and authentication control section click Edit, now click Edit in the Anonymous access section, enter your administrator username and password, that should do it.

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/