ODBC Connection to SQL Server

[Guest]

I have read several threads here about how to accomplish this and even the
article by Doug Steele. However, no matter what I attempt to do I keep
getting a pop-up box with an error message:
Connection failed
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'domain\username' (domain and username actually was filled)

then another pop-up
SQL Server Login
with Use trusted Connection checked.

Now if I un check it and actually place the username and password of my SQL
Server Admin account then the connection works. This is not want I want to
do. I just want the users to have a connection to the database on the
server. How can this be done. You would think Microsoft would make this
procedure a little easier. I even tried upsizing, but without any luck.

I created the Database on the server with the dbo account and then made
another user account, for a web program.

How can I make the connection from a Access 2003 mdb to a SQL Server 2000
and have the program transferable to other PCs without the user getting these
errors messages?

I want to keep a history of user logging in as well. If I keep the Server
dbo as the user name and password will the table be updated with this account
or the user name of the individual?

Any help on this would be appreciated.

 

[Pat Hartman\(MVP\)]

This is an SQL Server security issue. You'll probably get a better
explanation of how to resolve it from the SQL folks. The only SQL databases
that I have created have been unsecured so I can't help.

 

[Sylvain Lafontaine]

SQL-Server doesn't know anything about the passwords for windows account, so
it's not possible to fill the domain and username of a windows user account
when trying to connect to SQL-Server. The only way of using a windows user
account to connect to SQL-Server is by the way of a trusted connection and
these account must have been previously granted permission to one or more
databases in the Security tab of SQL-Server.