Re: Login failed for Server\Guest

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

Date: Tue, 01 Feb 2005 17:55:19 -0700

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: Authentication
    ... available are Windows authentication only or mixed mode. ... else how can enforce SQL authentication only!!!!! ... Though you can't disable the mechanism for Windows authentication, ... the right to connect to SQL Server - you have to explicitly allow this ...
    (comp.databases.ms-sqlserver)
  • Re: Login failed for ServerGuest
    ... SQL Server clients are authenticated as guests if Simple ... >| I have noticed that when I try to log in using Windows Authentication ... >|> You can enable the guest account but that's a security risk ...
    (microsoft.public.sqlserver.connect)
  • Re: NT authentication vs. SQL auth
    ... During a recent data migration from a SQL 6.5 db to a SQL ... about 1 hour and 10 minutes using SQL authentication. ... >information and pass it back to SQL Server. ... >sense that Windows Authentication is more demanding, ...
    (microsoft.public.sqlserver.security)
  • RE: Running SSIS Package using a scheduled Job in SQL2005
    ... 918760 - An SSIS package does not run when you call the SSIS ... SQL troubleshooting: http://sql.veranoest.net ... Authentication option is disabled. ... I have noticed that if I use Windows Authentication ...
    (microsoft.public.sqlserver.tools)
  • Re: IIS Webservice + SQL 2008
    ... Windows Authentication is enabled. ... When I change something in sql from ... webservice same thing happens. ...
    (microsoft.public.inetserver.iis.security)