Re:changing sa password / login
From: Vishal Parkar (vgparkar@hotmail.com)
Date: 12/13/02
- Next message: Arzan: "Re: Column level security"
- Previous message: Michael S: "TcpPort property change"
- In reply to: Holly: "changing sa password / login"
- Next in thread: Holly: "Re:changing sa password / login"
- Reply: Holly: "Re:changing sa password / login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Vishal Parkar" <vgparkar@hotmail.com> Date: Thu, 12 Dec 2002 21:54:05 -0800
I think you might have made changes to SQL Server
configuration as well, previous connection which you use
to make was using Mixed Authentication which will
validation SA login but If it is changed to "Windows Only"
authentication which is also called as "Trusted
Authentication" can not recognize SA login which is SQL
Server authentication.
If above assumption is correct change sql server
configuration to use mixed authentication. and try
connecting to server.
--Vishal
>-----Original Message-----
>Hi.
>
>I'm using SQL Server authentication.
>
>I created a new login "identical" I think to the sa login
>and changed both their passwords. I also changed then in
>the ODBS as I am running an accress front end to my SQL
>server for reports. I tried getting in through access
and
>it worked, partly, so I changed the password for sa back
>to its original password. It worked completely. Then we
>rebooted the system and now I can't get it to work. I
>have a very limited knowledge of this. I changed the sa
>password in the logins part of the security section of
>enterprise manager. Then I adjusted the config of the
>ODBC to match the enterprise manager password. But now,
>when I try the ODBC connect, I get a message that 'login
>failed for user 'sa' Reason, not associated with a
trusted
>SQL server connnection.
>
>I looked at the users under the database itself in
>enterprise manager, and the dbo has no login name. It
>used to have the login name sa.
>
>Does this make sense to anyone? I barely understand it
>enough to even phrase the problem.
>
>THANK YOU, Holly
>.
>
- Next message: Arzan: "Re: Column level security"
- Previous message: Michael S: "TcpPort property change"
- In reply to: Holly: "changing sa password / login"
- Next in thread: Holly: "Re:changing sa password / login"
- Reply: Holly: "Re:changing sa password / login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
