oledb connectivity to SQL Server 2000

From: arul (arulmozhi.sengodan@us.bosch.com)
Date: 03/19/03 

From: "arul" <arulmozhi.sengodan@us.bosch.com>
Date: Wed, 19 Mar 2003 08:29:30 -0800

I need to create a DSN to connect to SQL Server. The
problem is I connect using username\password and then I
have to assign a role for accessing the tables. How Do I
do it?