Re: Login failed for user Servername\Guest

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 08:43:20 +0100

You cannot have SQL Server refer to an account on another machine, if you
aren't in a domain environment. You could try, from your client, to access
some windows resource (like a share) and that windows authentication could
meant that SQL Servers authentication of that other windows account (with
the same name) will be handles. Not sure, though... 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lance Geeck" <lgeeck@cox.net> wrote in message
news:2YM1c.16404$h23.14884@fed1read06...
> Tibor,
>
> Still getting the Login failed for user CDC2004\Guest.  Somehow, it seems
to
> think that I am signing onto the server as a guest and not as a user.
Here
> is what I have:
>
> On the Client computer I have a user CRAIS3.  This was setup in the
control
> panel, user accounts. It has admin rights on the client computer.
>
> On the server I have this same user name/password (CRAIS3) setup as an
> administrator on the server. (SQL Server 2000 Developer).   The computer I
> am using as a server is Win XP Professional. It's really a software
> development computer. This user was setup by the Users Accounts component
of
> the control panel.
>
> I then went into the Computer Management Component (Start, Programs,
> Administrative Tools, Computer Management) and looked at this login (Local
> Users and Groups, then selected Users).  It shows this login as being part
> of the administrators group.
>
> I then went into the SQL Server, Security, logins and added the user
CRAIS3.
> The user it added is for the Server,  it looks like this:
> CDC2004\CRAIS3.  CDC2004 is the name of the server.
>
> I think this should refer to the user on the client computer(?), but I
can't
> figure out how to add it.  I am missing a step here someplace.
>
> As it stands, I am not able to make an ODBC connection from the Client to
> SQL Server.  The error refers to me as a guest.  This implies to me that
the
> client computer isn't setup to login as a valid user.  What I find odd is
> that from the client, I can access the server disk drives and create
files,
> delete files, directories and soforth.
>
> Any ideas? Hopefully it is some simple step I have missed.
>
> Thanks Lance
>
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
in
> message news:uQCARUhAEHA.1464@tk2msftngp13.phx.gbl...
> > Enterprise Manager. Sorry, the name for the folder is Security (and then
> > Logins).
> >
> > -- 
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "Lance Geeck" <lgeeck@cox.net> wrote in message
> > news:KWJ1c.16358$h23.14633@fed1read06...
> > > Tibor,
> > >
> > > Thanks for responding.
> > >
> > > What does EM stand for?  I am looking at the SQL Server, but can't
seem
> to
> > > locate the permissions folder.
> > >
> > > Any pointers on finding it?
> > >
> > > Thanks
> > > Lance
> > >
> > >
> > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
wrote
> > in
> > > message news:uSkbxFVAEHA.448@TK2MSFTNGP11.phx.gbl...
> > > > You need to add this Windows account to SQL Server. EM, under the
> > > > permissions folder.
> > > >
> > > > -- 
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > >
> > > >
> > >
> > >
> >
> >
>
>

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: 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: 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)