Much thanks. I'll take a look at it.

John Uptmore <john.[Email Address Removed] wrote:John,

If the Access Application was compiled with the Office Developer tools,
and/or if it is using an ADO connection string which includes
"SSPI=Integrated Security"; this phrase in the connection string causes any
standard SQL user connection to be ignored.

You have the following options:
1. Use NT Authentication: You must add your NT user ID to the SQL Server
and the databases you are using through the Access Application. In
Enterprise Manager, expand the SQL Server under the appropriate SQL Server
Group, then expand Security. Right-click on the Logins, and follow the menu
to "New Login...". You will need to create yourself as a user with access
to the database(s) that the Access application uses. You will need to
repeat these steps for each NT user.

2. Use a standard SQL Account Authentication: Change the connection string
that the Access application is using to connect to the SQL Server, so that
it uses a standard SQL Server authentication. This can be a DAO, ADO, UDL,
DSN or an ODBC connection. You can use the Window's Search feature to find
these files on your local machine.

Hope this helps,
John David Uptmore,
Database Administrator

-----Original Message-----
From: John F Lewis [mailto:[Email Address Removed]
Sent: Tuesday, April 29, 2003 4:54 PM
To: LazyDBA.com Discussion
Subject: access to sqlserver


Okay, granted I've been doing Oracle for the past 6 years, with 0 Access
experience and some Sqlserver experience.

I'm trying to connect to sqlserver from access. Everytime it tells me I'm
not a trusted connection when I run a pre-existing query. A little box comes
up. I un-check the trusted connection box and enter a valid user that I can
log in with. Still Access tells me that sqlserver says I'm not a trusted
connection. Why does it ignore login/password for SQLServer? Is this an
Access problem?

Is there some sort of a global flag in Access or SqlServer that says all
connections must be from trusted connections.




(956) 423-6100 x113
1-800-395-9353
FAX (956) 423-4519

---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] 423-6100 x113
1-800-395-9353
FAX (956) 423-4519

---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
MS Sql Server LazyDBA home page