Re: Login failed for Server\Guest

From: Maer (maer_at_auditleverage.com)
Date: 02/11/05 

Date: Thu, 10 Feb 2005 19:33:17 -0500

    Thank you, Sue. Your suggestion seems to be the way to go.

    I have noticed that when I try to log in using Windows Authentication to
a Windows 2000 machine from my XP machine, it tries to log me in as
"Server\Administrator" and, of course, fails. My account is part of the
Administrator's group. However, the other way around (from Win 2000 to XP)
works fine.

    Is there a limitation in Windows 2000 too?

    Thanks again,
    Maer

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:gg8001d3s2nhf3kjd1i61srhmh5264arvc@4ax.com...
> Hi Maer,
> You can enable the guest account but that's a security risk
> - especially if exposed to the outside world. For SQL
> Server, although Windows Authentication is more secure than
> SQL Authentication, I'd probably use that option instead of
> enabling the guest account. Make sure to turn on security
> audits, limit the number of SQL logins and make sure all SQL
> logins have strong passwords - mixed case, alpha numeric
> with special characters, no known words, etc.
>
> -Sue
>
> On Tue, 1 Feb 2005 18:44:54 -0500, "Maer"
> <maer@auditleverage.com> wrote:
>
>> Thank you, Sue!
>>
>> That clarifies so much! Would I be right in assuming that using
>> windows
>>authentication is not an option when logging in remotely to Xp Home since
>>it
>>always uses Guest? Is there a work-around?
>>
>> Maer
>>
>>
>>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>>news:k2tvv01h3cqitqs4jefqnnoa9s3obd5rv1@4ax.com...
>>> With XP home, authentication is done using the guest account
>>> as simple file sharing is always enabled on XP Home. Refer
>>> to the following for more info:
>>> SQL Server clients are authenticated as guests if Simple
>>> File Sharing is enabled
>>> http://support.microsoft.com/?id=831133
>>>
>>> -Sue
>>>
>>> On Tue, 1 Feb 2005 15:42:45 -0500, "Maer"
>>> <maer@auditleverage.com> wrote:
>>>
>>>> Hi - I have two computers, one running Xp Pro and one Xp Home. I
>>>> created
>>>>a windows user account on both machines with the same password. I added
>>>>those accounts to SQL Server on both machines and I want to be able to
>>>>connect to each other using a trusted connection.
>>>>
>>>> If I try to remotely connect to the Xp Pro machine from the Home
>>>> machine
>>>>using windows authentication, everything works fine. But, if I try to
>>>>remotely connect to the Home machine it says that login failed for
>>>>Server\Guest. My understanding is that it tries to log in as guest if
>>>>the
>>>>windows account is not found.
>>>>
>>>> Why does it work on one computer but not the other? Is it because it
>>>> is
>>>>Home edition? Is there something else I need to do?
>>>>
>>>> BTW, standard authentication works fine on both machines and the
>>>> Guest
>>>>account is turned off.
>>>>
>>>> Thanks,
>>>> Maer
>>>>
>>>
>>
>

Relevant Pages

  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)
  • RE: Integrated Authentication (Kerberos) Problem
    ... Verify the SPN for the SQL service account is registered such as the ... >Thread-Topic: Integrated Authentication Problem ... A Windows XP SP1 with IE6 client machine ...
    (microsoft.public.inetserver.iis.security)
  • Re: User authentication
    ... What I want to do is configure scheduled backup. ... However, if possible, I would like to use Windows authentication as opposed ... the backup job in SQL server. ...
    (microsoft.public.sqlserver.clients)
  • Re: How to SELECT records based upon ASP.NET Roles
    ... security principals directly. ... be able to use SQL row-level security as well (which is something I've never ... When using Windows ... authentication in IIS, this will be a WindowsPrincipal object, but it would ...
    (microsoft.public.dotnet.security)
  • Re: How to SELECT records based upon ASP.NET Roles
    ... security principals directly. ... also be able to use SQL row-level security as well (which is something ... using Windows authentication in IIS, ...
    (microsoft.public.dotnet.security)