i am trying to connect to the database(SQL server 7.0) . IIS and the database server are on the same machine. <BR><BR>I am getting the following error message. please help me<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers<BR>(0x80040E4D)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login<BR>failed for user 'NANIIUSR_NANI'.<BR>/hello.asp, line 6<BR><BR>and NANI is the name of my IIS server. when i checked the users profile i saw that IUSR_NANI is the default user for IIS something. please help me.