Re: Login failed for user Servername\Guest

From: Lance Geeck (lgeeck_at_cox.net)
Date: 03/05/04


Date: Fri, 5 Mar 2004 11:00:43 -0800

How is the correct why to set this up without a domain?

Can you point me to a reference that would show me the steps?

Thanks
Lance

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:%23iReJWoAEHA.2300@TK2MSFTNGP10.phx.gbl...
> 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...



Relevant Pages

  • Re: Security
    ... > You now logon using your windows account, ... connect to SQL SERVER using the FRED user. ... I'm logged into windows using my own login, and connecting to SQLSERVER ...
    (microsoft.public.sqlserver.server)
  • Re: Security
    ... > You now logon using your windows account, ... connect to SQL SERVER using the FRED user. ... I'm logged into windows using my own login, and connecting to SQLSERVER ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL server
    ... The setup was asking you for the windows account to run the SQL server ... Windows authenication mode is the most secure way to access SQL server - you ... > When I setup it up, it asked me for the user name and password that I ...
    (microsoft.public.sqlserver.setup)
  • Re: How to prevent sa from hacking Windows Server ?
    ... run SQL Server under an Windows account that isn't a member of the ... Windows administrators group and doesn't have permissions to create Windows ...
    (microsoft.public.sqlserver.programming)
  • Re: How to prevent sa from hacking Windows Server ?
    ... run SQL Server under an Windows account that isn't a member of the ... Windows administrators group and doesn't have permissions to create Windows ...
    (microsoft.public.sqlserver.security)