if password changed for login windows, connection will be failed?

[920506]

Hi,
Someone initially set up my ASP page access sql server using windows authentication mode. It works all right.
several months later, I reran that ASP page, it doesn't work anymore. It always give me error message like:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'BETTYPC\IUSR_BETTYPC'.
/myweb/webmsde/XXX.asp, line 30

I wondered if the login password changed(since I have to change password every month) for log into windows will affect that.

Thanks
Betty

 

[nigelrivett]

For a trusted connection it will take the user that it is running under. Probably the iis service user.

BETTYPC\IUSR_BETTYPC doesn't sound like a service account and so is probably set to expire and will give an error when iis is restarted.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[920506]

hi,
I did reinstall IIS after that. Do I need to reset IIS and How? BETTYPC\IUSR_BETTYPC is not service account.
BettyPC is my server/computer name.
if my windows login username is betty,
do I need to set up windows account in syslogins table in order to access database, and how to setup
thanks
Betty
Thanks