SQL Server and Workgroup networks, how?

[DotNet]

How to establish connection string for sql server on non-domain network?

[Jens]

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.

From Connectionstrings.com:

"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

HTH, Jens Suessmeyer.

[Erland Sommarskog]

Jens (Je**@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx