Re: Why CAN I log in?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: bing (bing_at_discussions.microsoft.com)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 12:41:06 -0700

Thanks. But I don't quite understand it. Did you suggest login to SQL
server using Query analyzer as that domain user? Query analyzer is only
installed on the sql server. This domain user is not allowed to log on to
the sql server locally. How should I try what you suggested?

Bing

"Hari Prasad" wrote:

> Hello,
>
> Might be thru a GUEST user. Login to SQL server using Query analyzer and
> execute the below command:-
>
> select system_user
>
>
> Guest User:
>
> The guest user account allows a login without a user account to access a
> database
>
> Thanks
> Hari
> MCDBA
>
>
>
> "bing" <bing@discussions.microsoft.com> wrote in message
> news:38EB39B9-B2AA-43CD-A964-984E4E99BD52@microsoft.com...
> > I can log in to a Windows machine using an average domain account. I
> > configured ODBC to use Windows authentication. Then I had no problem
> > connecting to the SQL server and got a Test Successfully message. But I
> > checked Logins under Security on the SQL server and did not find the
> domain
> > account I used for the connection was there. And this domain account is
> not
> > in any admin groups. I'm confused. How can this account connect to the
> SQL
> > server?
> >
> > I would appreciate if anybody can help clear up my confusion.
> >
> > Bing
>
>
>

Relevant Pages

  • Secure web authentication system w/o SSL and PKI
    ... In the beginning, a user should be able to register for an account, ... minted one-time password to their email address. ... it is assumed that only both the server and the end ... I'm making the big assumption that the user's email login has not been ...
    (comp.security.misc)
  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: user cant access OWA or RWW
    ... I filtered the Security log on the server using her name in the User box and unchecked Success. ... Now I see Event 533's for her account when I tried it this morning. ... There should be a couple of events during this login process. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
    ... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
    (microsoft.public.sqlserver.clustering)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)