Windows Authentication Issue

chris_luther

Hello,

I have recently upgraded our domain to 2008 and thought it an apt time to start using windows authentication.

I have set up a couple of domain users, which when I try to login it, it starts opening the database but then comes up with 'The operating system cannot find the drive and directory specified for the file' however I can open the database using standard database logins.

Any ideas?

Chris

jwilder

Start by making one user a sql sysadmin. See if that fixes it. If not, make the same user an admin on the server itself. I am guessing one of these 2 things will fix/identify where your problem is. Then you can focus in on where the problem is. If you respond with your findings we might be able to help some more.