Windows Authentication Login?
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=18745
Printed Date: 13 April 2026 at 1:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Windows Authentication Login?
Posted By: bad5star
Subject: Windows Authentication Login?
Date Posted: 16 March 2006 at 8:25pm
Hi,
Is there a way to connect to the database
(database_configuration.asp) page via a windows authentication instead of SQL login?
I have other apps running on SQL through windows authentication login and when I try to enable the SQL and WIN login together... my other apps shut down and I STILL cant login to the database for WWF
Thank you in advance,
B5
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 March 2006 at 11:39am
Web Wiz Forums uses the standard way for a login to SQL Server using TCP/IP that is required for ASP.
I have not come across anyone in 5 years asking for Windows Authentication to login into the SQL Server so this is not supported, but if you can find away to do this then you are welcome to modify the connection string so this can be done.
|
Posted By: WebWiz-Bruce
Date Posted: 17 March 2006 at 11:42am
I've just done a quick search on Google and it looks like it can be done by just adding a few parts to the connection string, which should be simple for you to modify.
Have a look at:-
http://support.microsoft.com/kb/247931/en-us - http://support.microsoft.com/kb/247931/en-us
Adding 'Integrated
Security=SSPI' to the end of the connection string looks like it might do it as long as the server is setup for the method.
|
|