Re: Login without password

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 08/12/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 12 Aug 2002 11:23:33 -0600

It sounds like you have orphaned users. You may want to
refer to the following articles:
PRB: "Troubleshooting Orphaned Users" Topic in Books Online
is Incomplete
http://support.microsoft.com/?scid=kb;en-us;Q274188
PRB: User Logon and/or Permission Errors After Restoring
Dump
http://support.microsoft.com/?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is
Moved Between SQL Servers
http://support.microsoft.com/?scid=kb;en-us;Q240872

-Sue

On Mon, 12 Aug 2002 01:23:04 -0700, "Sarah" <sarah@hkpc.org>
wrote:

>Thanks Margolin for your reply. But I've tried to search
>for the user/login in the guest, but it doesn't exist.
>How can I delete the login and add it back? It's a great
>problem for me now because if hackers know the username,
>they can easily login without the password.
>
>>-----Original Message-----
>>Sarah,
>>
>>Check out the section "guest User" in the SQL Server 7.0
>Books Online.
>>
>>-------------------------------------------
>>BP Margolin
>>Please reply only to the newsgroups.
>>When posting, inclusion of SQL (CREATE TABLE ...,
>INSERT ..., etc.) which
>>can be cut and pasted into Query Analyzer is appreciated.
>>
>>"Sarah" <sarah@hkpc.org> wrote in message
>>news:488801c23915$05c44340$2ae2c90a@phx.gbl...
>>> My SQL Server is version 7.0. I migrate the server from
>>> one old server to a new one, but it is still SQL Server
>>> 7.0. However after the migration, some users can login
>>> into the server without a password or with a wrong
>>> password. I found that the user is disappeared
>>> from "Login", but when I open a role and I can see that
>>> user under that role. In this way, since the user
>doesn't
>>> displayed out as a login, I cannot delete it. But when
>I
>>> try to add a new login to set a new password, the server
>>> stated that the user already exists. what should I
>do? I
>>> need to solve this problem in a very short time. Please
>>> help me. Thanks a lot!!!
>>
>>
>>.
>>

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: error logging on SQL 2008
    ... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server role or right click on it and choose properties from the popup menu, ... Login is a member of the "sysadmin" fixed server role now. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > file while you do changes, so the script file in the end contains the ... >> Server, doesn't have the right to grant DB access to Domain Groups. ... > Tibor Karaszi, SQL Server MVP ... >> site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)