changing sa password / login

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

From: "Holly" <h.cooper@hailcotton>
Date: Thu, 12 Dec 2002 15:08:21 -0800

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: Access link table security
    ... onerous chore of creating DSN's on each client. ... >and SQL Server is on the same machine. ... >How and where do I set at the Access frontend so that I can choose the login ... >change the login name for the Access frontend, do I need to play with ODBC ...
    (microsoft.public.sqlserver.security)
  • Re: Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... a Window 2000 Login with Domain User default permissions, ... > actually answered the question about the permissions the user has re: ... Forget about SQL Server for the moment. ... >> Enterprise Manager, but he is still able to stop the SQL Agent ...
    (microsoft.public.sqlserver.security)
  • Re: Log in problem
    ... Open Enterprise Manager and right click on the server node. ... Select Edit SQL Server Registration Properties. ... You may also just be experiencing a login time...it's hard ... >not log into my local database however I can log into a ...
    (microsoft.public.sqlserver.clients)
  • Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?
    ... > The question is - can I connect to this instance with either SQL Server ... The firewall MSDE is a SQL 2000 instance. ... W3WALL\MSFW as the SQL Server in Enterprise Manager. ... Install the client tools on the firewall, login as ...
    (microsoft.public.isaserver)
  • Re: Storing/saving sessions on SQL Server
    ... If you dont have enterprise manager, download SQL ... "SQL Server does not exist or access denied. ... "Cannot open database requested in login 'ASPState'. ...
    (microsoft.public.dotnet.framework)