Domain Accounts

I would like to set up an odbc connection to a MS SQL
2000 database using a domain account.
Is there a way to define a dsn odbc connection using a
windows domain account without actually login onto the
server/pc as that domain account?
Thanks,
SherrySecurity context is not saved with the DSN. A trusted connection is
established under the security credentials of the executing application. A
SQL authenticated connection uses the userid and password supplied in the
connection string.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Sherry" <anonymous@.discussions.microsoft.com> wrote in message
news:31a401c4aee1$834a3650$a401280a@.phx.gbl...
>I would like to set up an odbc connection to a MS SQL
> 2000 database using a domain account.
> Is there a way to define a dsn odbc connection using a
> windows domain account without actually login onto the
> server/pc as that domain account?
> Thanks,
> Sherry|||Hi
You may want to look into DSN less connections.
John
"Sherry" <anonymous@.discussions.microsoft.com> wrote in message
news:31a401c4aee1$834a3650$a401280a@.phx.gbl...
> I would like to set up an odbc connection to a MS SQL
> 2000 database using a domain account.
> Is there a way to define a dsn odbc connection using a
> windows domain account without actually login onto the
> server/pc as that domain account?
> Thanks,
> Sherry