ODBC and SQL Security

Hi,
What is the best practice for authentication to Win2003 Server with SQL
Server 2000 database? For example, an Access 2003 application that would us
e
a ODBC pass-through query to connect and select (read only) data from the
SQL Server database. Would prefer to hard code the username and password
using VBA as this is a reporting app only. We are using a Novell network on
servers where Access app is installed. Usernames are only unique within the
contexts on multiple Novell servers.Bonnie
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting
best practices
http://vyaskn.tripod.com/sql_server...t_practices.htm --secu
rity
best practices
"Bonnie" <Bonnie@.discussions.microsoft.com> wrote in message
news:1A495F95-D112-4364-A11B-F1FDC24D93C4@.microsoft.com...
> Hi,
> What is the best practice for authentication to Win2003 Server with SQL
> Server 2000 database? For example, an Access 2003 application that would
use
> a ODBC pass-through query to connect and select (read only) data from the
> SQL Server database. Would prefer to hard code the username and password
> using VBA as this is a reporting app only. We are using a Novell network
on
> servers where Access app is installed. Usernames are only unique within
the
> contexts on multiple Novell servers.