[AccessD] Connecting to SQL from Access w/a single login?

Christopher Hawkins clh at christopherhawkins.com
Fri Sep 17 13:34:16 CDT 2004


Can you elaborate?



---- Original Message ----
From: mikedorism at adelphia.net
To: accessd at databaseadvisors.com, 
Subject: RE: [AccessD] Connecting to SQL from Access w/a single login?
Date: Fri, 17 Sep 2004 14:23:01 -0400

>Easiest way is to use your Global Domain master account and use 
>Windows NT
>authentication to set up a trusted connection to the server.
>
>Doris Manning
>Database Administrator
>Hargrove Inc.
>www.hargroveinc.com
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
>Christopher
>Hawkins
>Sent: Friday, September 17, 2004 2:06 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Connecting to SQL from Access w/a single login?
>
>
>This is driving me nuts.  I know I did this a few years ago, but 
>right now
>I'm totally stumped.
>
>A client of mine wrote himself an Access app for use around his 
>office.
>Eventually the back-end swelled up to 500MB and problems ensued, so 
>they
>decided to go to SQL Server.  He upsized the database himself and 
>then
>called me in to help get the Access front-end working against SQL 
>Server.
>
>Here's my current issue; I want all the Access clients to use the 
>same SQL
>Server login rather than having a unique SQL Server login for each 
>domain
>account.
>
>I went ahead and created an AppUser login and gave it the appropriate
>permissions to the application database.  I have the AppUser login 
>and
>password set in the ODBC DSN.  But whenever a user tries to connect, 
>an
>error message appears stating that his domain login was not 
>recognized by
>the SQL Server.  It's not even paying attention to the AppUser info.
>
>I'm surfing BOL right now, but haven't yet figured out what I 
>missed. And I
>know I'm missing something.
>
>Any suggestions?
>Respectfully,
>
>Christopher Hawkins
>Software Developer
>(559) 687-7591
>http://www.christopherhawkins.com
>
>
>-- 
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>-- 
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
Respectfully,

Christopher Hawkins
Software Developer
(559) 687-7591
http://www.christopherhawkins.com





More information about the AccessD mailing list