Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Use on local machine w Windows Authentica
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Use on local machine w Windows Authentica

 Post Reply Post Reply
Author
reeljustice View Drop Down
Newbie
Newbie


Joined: 20 July 2003
Location: United States
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote reeljustice Quote  Post ReplyReply Direct Link To This Post Topic: Use on local machine w Windows Authentica
    Posted: 20 July 2003 at 11:29am

I would like to work with WebWizForums on my local machine. 

I am relatively new to ASP so I hope this isn't too stupid a question.

My local machine database server is JoelJr

The WebMatrix installation I selected uses Windows Authentication. 

How do I edit the 'SQL_server_connection.asp' file to allow usage on my local machine?

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 20 July 2003 at 12:27pm
If you want to use WIndows Auth. for the forum you need to change your connection string to something like:
data source=ip_or_servername;integrated security=sspi;database=forumdb
Though the IUSR_Machinename account needs to be setup in the SQL then so it had select, update and insert rights.....
Back to Top
ScottM View Drop Down
Newbie
Newbie


Joined: 28 July 2003
Status: Offline
Points: 25
Post Options Post Options   Thanks (0) Thanks(0)   Quote ScottM Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2003 at 9:01am

Hi,
Windows Authentication has been discussed in two threads but neither seems to describe my aim, which is to avoid having the user complete the login if they are already logged in as a valid user on the Windows NT domain. Say, the forum is integrated within a portal which requires the user to log in as a NT user. When the user does something eg post a reply, which would normally open the login page, I want their existing NT login to be accessed and their username to be used throughout the forum. If they try to do something which would normally open a login page and they are not logged in then they will be prompted for a login. How close can I get to this with minimal changes to the forum?

ScottM

Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2003 at 7:08pm
This requires a change to the log in script of the forum code.
There have been many, many posts made throughout the world...
This was one of them.
Back to Top
seidren View Drop Down
Newbie
Newbie


Joined: 08 August 2003
Location: Sri Lanka
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote seidren Quote  Post ReplyReply Direct Link To This Post Posted: 08 August 2003 at 3:54am

Hey ScottM, I am trying to get the same thing done too.

I am new to asp so if I need some help.

i have asp code which, when you pass the username and password will authenticate. I dont know if just inserting this in to the login script would work.

Bunce!!! if you can tell us what changes should we do to the script it will be very help full.

Back to Top
spg_ View Drop Down
Newbie
Newbie


Joined: 10 April 2004
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote spg_ Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2004 at 7:34am
Ive already done this change ( if you really searched hard, you wouldve found it on this very forum :) )

http://forums.webwiz.net/forum_posts.asp?TID= 5937&TPN=6

This allows for automatic authenication and registation of a user based on their Windows user login.
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.