I have a problem connecting to an sql server through ip address, here are the symptoms.
1) try to connect to managment studio with ip 127.0.0.1 and windows authentication error "login is from an untrusted domain..."
2) try to connect to managment studio with ip 127.0.0.1 and user sa and pass login success
The same behaviour when I try to connect from VB .Net with adoconnection,
I have windows 7 pro 64 bit, in my win xp pro sp3 machine can connect without errors.
(notice try to change the permissions of the user in sql managment studio but failed to give permission to user supervisor, only user sa has permissions.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)