On Mar 24, 12:05 pm, zach <neopot...@gmail.com> wrote:
> Hi,
>
> We have a server in a workgroup that users in our active directory
> will need to access.
>
> How can we configure an odbc connection to use a different username
> and password (windows not sql) than the one they are currently logged
> on on as. (The application we are using only supports windows
> authentication not sql)
>
> example : I am logged onto my workstaion a 'Jane', but i Need to use
> user id 'janey' to connect to the odbc, and i dont want to have to
> log
> on to the workstation as janey

Hi, i'm no network admin, but from my experience usually what they do
is create a windows group and assign all the users they want to have
access to that odbc to that group, then you have your dba create a sql
account with that group having minimal permissions needed and set up
the odbc with the group name.