Re: Why CAN I log in?
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 08/20/04
- Next message: Russell Fields: "Re: VLDB backups and partial restore"
- Previous message: Russell Fields: "Re: how to copy sql database?"
- In reply to: bing: "Re: Why CAN I log in?"
- Next in thread: bing: "Re: Why CAN I log in?"
- Reply: bing: "Re: Why CAN I log in?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Aug 2004 17:26:30 -0400
bing,
Get into Query Analyzer however you got into it the first time. I believe
you used a trusted connection.
Execute the TSQL statement that Hari gave you, modified as:
select system_user, session_user
The first should give you the login that you are using, the second the
database user (which might be "guest").
See what your results are. Also, read about the "guest" account in the
Books Online.
Russell Fields
"bing" <bing@discussions.microsoft.com> wrote in message
news:8D6856B8-2E93-4262-BCC9-AF14FA0FCE3D@microsoft.com...
> 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
> >
> >
> >
- Next message: Russell Fields: "Re: VLDB backups and partial restore"
- Previous message: Russell Fields: "Re: how to copy sql database?"
- In reply to: bing: "Re: Why CAN I log in?"
- Next in thread: bing: "Re: Why CAN I log in?"
- Reply: bing: "Re: Why CAN I log in?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
