https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 20:07:13 +0000 Fri, 20 Apr 2007 17:25:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23152 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/sql-express-settings_topic23152_post122209.html#122209 Author: mike54
Subject: 23152
Posted: 20 April 2007 at 5:25pm

just when mentioned other users connecting I thought you were wanting to run more than just a development environment

I may invite the powers that be to take a look. I'd like to get them to go with a forum on the company site and yours looks pretty good to me.
]]> Fri, 20 Apr 2007 17:25:15 +0000 https://forums.webwiz.net/sql-express-settings_topic23152_post122209.html#122209 https://forums.webwiz.net/sql-express-settings_topic23152_post122204.html#122204 Author: WebWiz-Bruce
Subject: 23152
Posted: 20 April 2007 at 4:30pm

OK, no problem, just when mentioned other users connecting I thought you were wanting to run more than just a development environment.]]> Fri, 20 Apr 2007 16:30:25 +0000 https://forums.webwiz.net/sql-express-settings_topic23152_post122204.html#122204 https://forums.webwiz.net/sql-express-settings_topic23152_post122203.html#122203 Author: mike54
Subject: 23152
Posted: 20 April 2007 at 4:09pm

If you are getting a windows login this is because you have notcorrectly set permissions for the IUSR account to have anonymous accessto the directory and files in which the forum resides.

It took Admin rights but no more login...

The other thing you should know is XP Pro is not a server OS, so IIS on it is limited to only 10 concurrent connections

Poor choice of words on my part, I'm aware my little box is no real server...
It works for our intranet and for doing a little playing and testing though.

Thanks for the help.


]]> Fri, 20 Apr 2007 16:09:03 +0000 https://forums.webwiz.net/sql-express-settings_topic23152_post122203.html#122203 https://forums.webwiz.net/sql-express-settings_topic23152_post122193.html#122193 Author: WebWiz-Bruce
Subject: 23152
Posted: 20 April 2007 at 1:27pm

If you are getting a windows login this is because you have not correctly set permissions for the IUSR account to have anonymous access to the directory and files in which the forum resides.

IE works with your windows login and so it often won't prompt for the password when using IE in this way on a local network.

The other thing you should know is XP Pro is not a server OS, so IIS on it is limited to only 10 concurrent connections, and as just one user can use these up it would mean that only 1 person could browse a site hosted on IIS on XP Pro at a time.

To allow multiple users you need a real Server OS, like Windows 2003 Server, which doesn't have the restrictions that XP has for IIS.

Try it yourself open your XP Pro IIS site up in IE, Firefox, and Opera at the same time, it will see these as three different users, you will notice images, and page start to not display as the allowed connections are used up.


Edited by -boRg- - 20 April 2007 at 1:30pm]]> Fri, 20 Apr 2007 13:27:03 +0000 https://forums.webwiz.net/sql-express-settings_topic23152_post122193.html#122193 https://forums.webwiz.net/sql-express-settings_topic23152_post122189.html#122189 Author: mike54
Subject: 23152
Posted: 20 April 2007 at 11:38am

OK, I've got a little dev server at work (XP Pro running IIS 5) so Idecided 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 andpassword for the machine the dB resides on. It authenticates with mywindows/network login. I've tried setting the forum to usewith windows authentication and without but I'm always prompted for the IDand password. No one else can log in set either way. What littlesomething might I have missed to allow users to get to the forumwithout being prompted for a password? I do have anonymous access setup 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-uristo the server name (picked up that gem from searching here), now Iget no prompt but (there's that but again) in IE 7 I'm still promptedto login.I hope it's a setting I can change on the server as I'd rather not haveto explain to users that they have to go into their browser and playwith settings.
Any hints, clues or direct help would be appreciated. ]]> Fri, 20 Apr 2007 11:38:55 +0000 https://forums.webwiz.net/sql-express-settings_topic23152_post122189.html#122189