windows authentication login failed

[automicgina]

Hi,

I created a DSN coonection to a SQL db and I have to use windows authentication. I was able to login under the computer's administrator account, but when I login as regular network user I got this error:

Connection failed:
SQL State: "28000"
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'mydomain\myname'

Is this a SQL problem or a network problem?

 

[Corran007]

Did you set that specific user up on the server to login to what ever datbase they need?

If not then you will need to do so. sql server has builtin\administrators as sys admins by default which explains why your admin account could connect.

 

[automicgina]

That is a problem to me then. I'm using MSDE, not SQL Server. Is there any way to allow the user group to login to the db with MSDE?