SQL Express Settings???
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23152
Printed Date: 07 April 2026 at 8:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Express Settings???
Posted By: mike54
Subject: SQL Express Settings???
Date 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.
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. |
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: mike54
Date Posted: 20 April 2007 at 4:09pm
It took Admin rights but no more login... 
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. |
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.Posted By: WebWiz-Bruce
Date 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.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: mike54
Date Posted: 20 April 2007 at 5:25pm
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.  |