OK, I've got a little dev server at work (XP Pro running IIS 5) so I
decided to play with webwiz forum (SQL version) using SQL Express.
- Downloaded and installed SQL Express - OK
- Created new empty dB - OK
- Downloaded and created webwiz forum dB - OK
- Connected - OK
But, there's always a but...
When I open the default.asp in the browser I'm prompted for an ID and
password for the machine the dB resides on. It authenticates with my
windows/network login. I've tried setting the forum to use
with windows authentication and without but I'm always prompted for the ID
and password. No one else can log in set either way. What little
something might I have missed to allow users to get to the forum
without being prompted for a password? I do have anonymous access set
up on IIS (for our intranet) and the SQL server is set to SQL and Windows authentication.
Just to make things more interesting...
If I use IE 6 I don't get the prompt.
I was getting the prompt with FF until I went to about:config and set
network.automatic-ntlm-auth.trusted-uris
to the server name (picked up that gem from searching here), now I
get no prompt but (there's that but again) in IE 7 I'm still prompted
to login.

I hope it's a setting I can change on the server as I'd rather not have
to explain to users that they have to go into their browser and play
with settings.
Any hints, clues or direct help would be appreciated.