Ok this is the problem of I go in and create a user lets dat domain\user1. I can than create a dsn to the system or use sql enterprise manager on the users workstation and connect fine to sql server.