SQL Server...Login failed for user Server\* (?)

[Ovatvvon]

Hello, I have been using Microsoft Access for my databases for quite some time now. I just got Sql Serve 7, and am attempting to learn it. So far I've imported an access database into it, and have started using it on a generic site for practicing. However, once the sql database needs to be accessed, it gives me this error:

Login failed for user 'WEBSERVER\IUSR_WEBSERVER'.

where IUSR_WEBSERVER is the generic internet user ID. I have tried setting that to an actual userID on the system, but it doesn't make a difference.

See what I mean:

http://jim.jwdinfo.com

Anyone know what I'm doing wrong that is keeping it from being able to be accessed?

-Ovatvvon

 

[Guest_imported]

There is an option in the properties of the DB to make for a "single user only" Uncheck that box and give it a shot. This is assuming that you have entries in your global.asa to access the Database.

 

[jakhan]

add the NT login name Webserver\iusr_webserver in your sql server logins

make sure to to put the most restrictive permissions to this user,
for example .. to only "that" database which is being accessed by web visitors.

good luck

Jahangir

 

[Ovatvvon]

Adding the Webserver\IUSER_WEBSERVER to the login access worked. Thank you for your help!