Re: Login failed for Server\Guest

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 07:52:08 -0700

Not in terms of the same type of thing with the guest
account.When it's a specific account failing, that's a
different matter than attempted authentication via the guest
account.

-Sue

On Thu, 10 Feb 2005 19:33:17 -0500, "Maer"
<maer@auditleverage.com> wrote:

> 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
    ... | guest and the use of the same account/password does not ... |>I think it is not a limitation in Windows 2000. ... |>use same password for Administrator account on both Win2000 and WinXP ... although Windows Authentication is more secure than ...
    (microsoft.public.sqlserver.connect)
  • Re: Access denied ( From one site to another, that is in another server)
    ... | configure it for Basic Authentication, can I avoid use Kerberos and use ... |> Enable Integrated Windows Authentication check box is ... Active Directory - Delegation: ... To verify that the application account can act ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Access denied ( From one site to another, that is in another server)
    ... If insted of configure the ASP.NET Application for Windows Authentication, ... Active Directory - Delegation: ... To verify that the application account can act ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: NT based roles using forms authentication
    ... You could create locked down local accounts on the web server and ... still use Windows authentication. ... >them selves and change between users without logging off the account. ... >> Windows manage the authentication and impersonation with a web.config ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Windows XP Advanced Filesharing
    ... Be consistent how you setup authentication on each computer. ... If neither automatic non-Guest, nor Guest, access is possible, you will ... interactively, using an activated non-Guest account, with correct password. ... Disable that account for local access, and Enable it for network access. ...
    (microsoft.public.windowsxp.network_web)
Loading