Re:changing sa password / login

From: Holly (h.cooper@hailcotton.com)
Date: 12/13/02 

From: "Holly" <h.cooper@hailcotton.com>
Date: Fri, 13 Dec 2002 05:34:10 -0800

I went to my ODBC connect and changed to windows
authentication and it worked. Thank you!

>-----Original Message-----
>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
>>.
>>
>.
>

Relevant Pages

  • Re: Cant Connect
    ... Then it's likely the authentication settings on the IIS side ... Try adding the IUSR account as a login in SQL Server ... > Cn.open CnStr ...
    (microsoft.public.sqlserver.connect)
  • Re: Security question ..
    ... > If you use NT authentication, a user's permissions to a database are ... Your assertion that a user's permissions are independent of the application ... Even using Access and "exploring" will require an ODBC login to SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re:changing sa password / login
    ... I think you might have made changes to SQL Server ... to make was using Mixed Authentication which will ... Authentication" can not recognize SA login which is SQL ... configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos / Authentication to SQL2K
    ... use Windows integrated security for database access. ... That SQL Server be running on the same computer as IIS. ... > authentication until I switched on impersonation either. ... > When set up on my web server however, I get the "Login failed for user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FormsAuthentication - <http://localhost> Works, <http://RealMachineName> Does Not
    ... Good morning, Paul. ... Here's the authentication section of web.config: ... Configuration section is: ... My login page is loginpage.aspx, ...
    (microsoft.public.dotnet.framework.aspnet)