when i first open sql management studio, it asks me to login. yes?
I choose windows authentication, and it blocks out the user/pass but puts in southeast\administrator as the user. nothing goes in for pw
I click login, and it successfully logs in. Everything is good. I can browse the databases, look/edit users, etc etc.
BUT when I right click on the database server in the tree (SERVER2 is its name) and goto properties..it generates about 5 errors, the final one being 'login failed: password is invalid'. I have to view the properties of server2 using the administrator account so I can disable successful audits from logging in the event viewer.
Make sense now? Its kinda tough to explain.