mixed mode does not work

I have recently set the security mode to Mixed mode for SQL2005 running on
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
ThanksLarry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>