Prev: Column naming standard - general opinions
Next: XML parsing duplicate attribute Error
From: jh on 26 Nov 2009 15:51
Just to be sure: Is it possible to login from a _remote_ machine to SQL
Server using Trusted Connection _without_ a Active Directory account?

The story... I have a workgroup build with 3 PCs only. The first PC has
installed SQL Server 2008 Express. I need to connect from other PCs with
Trusted Connection. The message I get when connecting is: The login is from
an untrusted domain and cannot be used with Windows authentication. Any
chance to login (windows authentication) without a domain controller?

Jacek

From: Erland Sommarskog on 26 Nov 2009 17:28
jh (NIE_SPAMUJ_jh(a)radio.kielce.pl) writes:
> Just to be sure: Is it possible to login from a _remote_ machine to SQL
> Server using Trusted Connection _without_ a Active Directory account?
>
> The story... I have a workgroup build with 3 PCs only. The first PC has
> installed SQL Server 2008 Express. I need to connect from other PCs with
> Trusted Connection. The message I get when connecting is: The login is
> from an untrusted domain and cannot be used with Windows authentication.
> Any chance to login (windows authentication) without a domain
> controller?

Yes, it is possible to do Windows authentication in a workgroup, but it
can be a battle.

To start with, you must have the same login and password on both machines.
There is also a Group Policy setting that needs to be set to Classic.

But I have never seen the error message you quote. The group-policy
setting eluded me for a long time, but I only got the message "is not
associated with a trusted connection". Then again, that was not SQL 2008;
maybe they have updated the error message.




--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Column naming standard - general opinions
Next: XML parsing duplicate attribute Error