Posted by Erland Sommarskog on 10/28/30 11:36

Jens (Jens@sqlserver2005.de) writes:
> YOu can connect to SQL Server without having a domain integration, but
> yxou cannot use integrated authentication across the computers because
> the SQL Server can´t trust these unknown and unreliable machines. If
> you want to use SQl Server authentication you have to include the
> UserId and the Password tag within the Connection string.

You can use integrated security in workgroups as well, but it is more
flaky. You username and password must be the same, but there may be more
to it.

During the beta programme of SQL 2005, I ran SQL 2005 on virtual machines,
and I did not have any domain. I was able to connect from my host computer
to the virtual machines with integrated security, but the other direction
did not work.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

[Back to original message]