Bpermissions with IUSR

[BobRodes]

Hi all,

I'm working with a remote reinstall of SQL Server. The DB (we'll call it MYDB) is intact. The server is remotely accessed via MS Remote and ADO. Now, when I look at the login IUSR_MYSERVER, it says that it doesn't have permission to access MYDB. The IUSR is in the Users list for MYDB, but only with public access. So, I delete the user from MYDB, and go into the Logins and edit the properties. I check the MYDB box, and give db_datareader and db_datawriter permissions. I hit ok. When I reopen the properties window, the MYDB box isn't checked any more, but IUSR has been added to the Users for MYDB again, again with only the public role allowed.

I'm thinking that there's a setting in the registry that is overriding my attempts to allow internet user access to the DB. Can anyone point me in the right direction?

TIA


Bob

 

[mrdenny]

There shouldn't be any settings that override this. Try deleting the IUSR login account from the SQL Server and granting it it's access again.

Denny

--Anything is possible. All it takes is a little research. (Me)