| Author |
 Topic  |
|
bobsmith
Starting Member
25 Posts |
 Posted - 16 May 2006 : 12:23:50
|
My server is Server 2003 Enterprise. SQL is version 2005 standard. IIS & SQL are on the same box. Im setting up a test forum to play with before I decide on what product to use.
When I first tried to access the setup page, I was getting a login failure. I then went to IIS and turned off anon access, at which point I get a username and password prompt when going to the site.
My question is, how to work with IIS anon access and snitz on the same server?
Current'y, when I go to the forum, I'm pronmpted for a username and password (I assume this is becasue anon access is turned off. Of course, I'd like to have anon access to the default.asp page enabled. How can I do this?
When I turn off anon access, I cannot access the forum.
Thank you
Cliff |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 May 2006 : 12:29:36
|
| you should have anon access turned ON in IIS, you then to to make sure that the directory in which you have placed the forum files has the correct userights, ie it must have the IUSR_XXXXX account added to the list of users under the folder security options |
 |
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:04:08
|
OK, anon turned on and folder has RE/L/R rights to forum folder.
Now I get a login failure for iusr_username |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:09:00
|
| HTTP 500 error. It said logon failure for iusr_username |
|
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:11:09
|
quote:
Originally posted by ruirib
Login failure for what? Accessing the site or the database?
All I did was turn on IIS anon access and add that user to the security for the folder. If I turn off anon access, I get a logon prompt and can access the site fine if I put in a username and password. |
|
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:18:38
|
| I'm thinking my iusr_username needs read access to database. |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 May 2006 : 13:25:12
|
iusr needs read/write and modify permissions for the db.
when you turned on anon access in IIS, check that IIS is set to control the password |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:28:47
|
| IIS has anon access and Windows Authentication is checked. |
|
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:29:58
|
quote:
Originally posted by ruirib
It's an SQL Server DB, Huw.
SQL 2005 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 May 2006 : 13:31:58
|
| AFAIK, you should just have anonymous authentication checked. Don't have that much experience on Windows Server 2003, but the only one I can use now has just anonymous access checked and it works outta box. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:34:55
|
| I have added IUSR as a user to my database, and given that user db_read and db_write permissions. Restarted SQL and same error. |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 May 2006 : 13:43:45
|
| if it is sql IUSR does not need access to it, you should remove it asap, you should have added your db login details to the snitz config.asp file |
|
|
|
bobsmith
Starting Member
25 Posts |
Posted - 16 May 2006 : 13:45:43
|
| I added my uid and pwd to my config.asp. Is there something else this string should have? |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 May 2006 : 13:47:11
|
| no, your problem is not with the db, it is with IIS or the folder permissions |
|
|
|
Topic |
|
Topic Locked
