authentication
From: wei (xiaowei.cao_at_state.mn.us)
Date: 07/10/03
- Previous message: JimT: "How to create a trusted connection"
- Next in thread: Dan Guzman: "Re: authentication"
- Reply: Dan Guzman: "Re: authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 10 Jul 2003 09:15:25 -0700
We just install SQL server.
1 this morning I try to change start service account from
controlpanel /services logon from this account:
.\Administrator password.....
to localsystem account on server
then change windows authenticate to mix mode, on server
and client
then I can connect to the server by using sa and my
passoword in my workstation client
2. Then I tried to change to windows authenticate to see
if it works or not.
In server it works, but in workstation client it can't
connect.
So I tried to change back to mix mode and set the sa's
password.
Then I tried either server or client not working.
I notice in the SQL- EM/Security/login sa's password is
longer than what I just set.
So I changed there and save and restart, but the password
seemed not changed at all.
Thanking you in anticipation
- Previous message: JimT: "How to create a trusted connection"
- Next in thread: Dan Guzman: "Re: authentication"
- Reply: Dan Guzman: "Re: authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|