Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - SQL Express Settings???
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Express Settings???

 Post Reply Post Reply
Author
mike54 View Drop Down
Newbie
Newbie
Avatar

Joined: 21 March 2003
Location: United States
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote mike54 Quote  Post ReplyReply Direct Link To This Post Topic: SQL Express Settings???
    Posted: 20 April 2007 at 11:38am
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.Confused 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. Ouch
Any hints, clues or direct help would be appreciated.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
mike54 View Drop Down
Newbie
Newbie
Avatar

Joined: 21 March 2003
Location: United States
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote mike54 Quote  Post ReplyReply Direct Link To This Post Posted: 20 April 2007 at 4:09pm
Quote 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.

It took Admin rights but no more login...Clap
Quote 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...Wink
It works for our intranet and for doing a little playing and testing though.

Thanks for the help.


Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
mike54 View Drop Down
Newbie
Newbie
Avatar

Joined: 21 March 2003
Location: United States
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote mike54 Quote  Post ReplyReply Direct Link To This Post Posted: 20 April 2007 at 5:25pm
Quote 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.Thumbs%20Up
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.