Re: Login failed for user . The user is not associated with a tru

tech-pete (techpete@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
So is Windows Authentication just for SQL running on a server and in a
domain?

You can use Windows authentication in a workgroup, but a couple of
stars need to be aligned for it to work. Users must have the same
username and password on both machines. In Windows XP and Vista there
is also a local security policy you need to change.

I would say that overall SQL authentication is the best choice for a
workgroup.

I thought when you opened up the guest account that this would allow
connectivity?

Guest account is only related to access between databases once you have
logged in to SQL Server, and is not a matter here.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Windows Authentication Question
    ... > I have two computers in a Workgroup. ... > still use Windows Authentication for SQL Server? ... Here is some background reading on SQL Server security best practices: ...
    (microsoft.public.sqlserver.setup)
  • Re: Login by IP address in Management Studio
    ... In a workgroup, integrated authenticiation works, if username and password ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Authentication
    ... available are Windows authentication only or mixed mode. ... You cannot configure SQL Server ... Windows authnetication is on the local machine. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: User authentication
    ... defined on the other workstation, using it and configure it to use ... Windows authentication is a difficult thing to get working in a workgroup. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005
    ... One is to enable SQL Server Authentication through Management Studio. ... through your application with Windows authentication, ... The other option is to add your Windows user to the sysadmin role: ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)