Re: Why CAN I log in?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 22:24:08 +0530

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

  • Re: MSSQL$SBSMONITORING Login to Disabled Account?
    ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
    (microsoft.public.windows.server.sbs)
  • Re: xp_cmdshell issue, local system
    ... So initially I tried to change the login using EM, ... account to the localsystem for SQL Server and the same for agent which worked ... Now when I go and try the same for the agent startup account it ...
    (microsoft.public.sqlserver.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... >gave that login full access to all SQL DB's. ... >group and rights to all the SQL Server databases. ... >Administrator Server role explicitly. ... >account that is a member of the DBA group and this group ...
    (microsoft.public.sqlserver.security)
  • Re: The SA Mess
    ... I agree - no one needs to use the sa account. ... How does a firewall know that there was an unsuccessful login to SQL ... That info has to come from SQL Server. ...
    (microsoft.public.sqlserver.security)