Login failed for user MyComputer\IUSR_MyComputer.

[JennB]

I have recently had to reinstall IIS when my it refused to recognize MyComputer. I'm not sure why but after I reinstalled it, when I try to test an asp page on the local network I get the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user MyComputer\IUSR_MyComputer.

I have checked SQL Server and have given permission for this user to access the database tables. When I test the query in Dreamweaver server behaviors, the test goes ok, but when I try to make the site dynamic or view it through the browser, I can't connect. Any idea what the problem might be? I'm really in a crunch here.

Thanks.

jenn

 

[ClayG]

It may not be relevant but usernames can look like they match but have different internal IDs if they have been recreated. Try:

sp_change_users_login 'Report'