Could you please help me resolve the problem with connection to SQL serverExpress 2008 R2.
My server has been setup to use mix sql and windows authentication. Its in my domain but everytime pople in company try to conenct using windows authentication ( their logins/passwords)connection failed we receive sql error 18456. Everything works fine for sa login and pass
Could you please help me investigate why we cant conenct using windows authentication?