Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Authentication: NT
 Auth fails with DSN connection		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Lweast
Starting Member

29 Posts
Posted - 17 April 2003 :  17:08:07  Show Profile

I had set up Snitz to use DSN via an ODBC connection pointing to the DB residing on the same server and found that anyone in the Domain Admin group could access the site without a problem but Non-Admins could not.

They received the error..
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MYDOMAIN\AUSER'.
/forums/inc_header.asp, line 114
Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page: GET /forums/Default.asp

It appears that when DSN is used every person allowed access to the site must have some permissions granted on the server. (Either to use the ODBC or to access the DB.. I'm not sure.)

To work around this I finally got the strConnString for SQLOLEDB to work by using Data_Source=172.0.0.1 rather than the MachineName which I thought would be resolved by DNS but wasn't. Also LocalHost did not work.

Hopefully this will help someone else who runs into the same problem.

Kal Corp
Average Member

USA
878 Posts
Posted - 21 April 2003 :  08:11:57  Show Profile  Visit Kal Corp's Homepage
Thanks Lweast !

{VAS}-Kal Corp
VAS Development NetWork - Forums for old Snitz Mods!
Creator of all things {VAS}
Go to Top of Page

geoffr
Starting Member

16 Posts
Posted - 01 May 2003 :  12:56:58  Show Profile
How was the DSN set up? Was it set to use the Windows Account for authentication or a SQL account?
Go to Top of Page

Lweast
Starting Member

29 Posts
Posted - 01 May 2003 :  15:59:39  Show Profile
The ODBC was set up with SQL Server Authentication.
IIS5 set up using NT basic Authentication.
Go to Top of Page

geoffr
Starting Member

16 Posts
Posted - 02 May 2003 :  11:42:54  Show Profile
One idea is to add the username and password into the strConnString to make it look like

strConnString = "DSN_NAME; Username=User; Password=password; '## DSN
This would force the DSN to use the account that is listed.

quote:
Originally posted by Lweast

The ODBC was set up with SQL Server Authentication.
IIS5 set up using NT basic Authentication.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07