How do you make an ODBC connection not use the "Use Trusted

I have an Access front end that uses an ODBC connection to a SQL
Server database.

Every time i come into my Access front end and try to execute a query,
it fails and the prompts me with a SQL Server Login .

The dialog has the server name, a checkbox for "Use Trusted
Connection", a login ID and password. of course if the checkbox is
checked, the login ID and password are greyed out. It defaults to the
checkbox being checked.

I can't for the life of me find out where to change it so the checkbox
is always unchecked by default and it uses a specific login ID and
password each time.

any help is appreciated.

thanks...

-fd

Re: How do you make an ODBC connection not use the "Use Trusted Connection"?

Obviously, the ODBC Data Source is created with Windows security (Trusted
Connection). That means user's (youor) user account is used in the Access
application to connect to SQL Server. If your windows account does not have
required permission to access said SQL Server database, then you get the
prompt.

If you cannot change the DSN, then you need to have your windows account
given needed access to the SQL Server database; or you can change the DSN to
use SQL Server security and enter SQL Server login username/password there,
so that any application using that DSN will not need username/password to
log into SQL Server database (of course you need to make sure data is
correctly secured).

"forest demon" wrote in message
news:2d54bf95-a6f9-4001-9468-aabb217699b4@i7g2000prf.googleg roups.com...
>I have an Access front end that uses an ODBC connection to a SQL
> Server database.
>
> Every time i come into my Access front end and try to execute a query,
> it fails and the prompts me with a SQL Server Login .
>
> The dialog has the server name, a checkbox for "Use Trusted
> Connection", a login ID and password. of course if the checkbox is
> checked, the login ID and password are greyed out. It defaults to the
> checkbox being checked.
>
> I can't for the life of me find out where to change it so the checkbox
> is always unchecked by default and it uses a specific login ID and
> password each time.
>
> any help is appreciated.
>
> thanks...
>
> -fd

Re: How do you make an ODBC connection not use the "Use Trusted

On Feb 1, 1:10=A0pm, "Norman Yuan" wrote:
> Obviously, the ODBC Data Source is created with Windows security (Trusted
> Connection). That means user's (youor) user account is used in the Access
> application to connect to SQL Server. If your windows account does not hav=
e
> required permission to access said SQL Server database, then you get the
> prompt.
>
> If you cannot change the DSN, then you need to have your windows account
> given needed access to the SQL Server database; or you can change the DSN =
to
> use SQL Server security and enter SQL Server login username/password there=
,
> so that any application using that DSN will not need username/password to
> log into SQL Server database (of course you need to make sure data is
> correctly secured).
>
> "forest demon" wrote in message
>
> news:2d54bf95-a6f9-4001-9468-aabb217699b4@i7g2000prf.googleg roups.com...
>
>
>
> >I have an Access front end that uses an ODBC connection to a SQL
> > Server database.
>
> > Every time i come into my Access front end and try to execute a query,
> > it fails and the prompts me with a SQL Server Login .
>
> > The dialog has the server name, a checkbox for "Use Trusted
> > Connection", a login ID and password. of course if the checkbox is
> > checked, the login ID and password are greyed out. It defaults to the
> > checkbox being checked.
>
> > I can't for the life of me find out where to change it so the checkbox
> > is always unchecked by default and it uses a specific login ID and
> > password each time.
>
> > any help is appreciated.
>
> > thanks...
>
> > -fd- Hide quoted text -
>
> - Show quoted text -

i found a workaround; however,
changing the DSN to use SQL Server security by entering SQL Server
login username/password
does not work. it still errors out and then shows the prompt with the
"Use Trusted Connection"
box checked. it's like it doesn't save the DSN config.

thanks for your input...

-fd