Connect to SQL Server 2000...

I there a way to connect to a SQL Server when the server is on a
computer that is apart of a network. I would like to use Windows
Permissions. Can it be done?
thanks
darylHi,
Did you mean that SQL Server machine is in a seperate domain? If yes, then
you can do this by setting Trust relationship between
both domains.
Thanks
Hari
SQL Server MVP
"Daryl" <developeracc@.hotmail.com> wrote in message
news:u6RAbyrTFHA.3620@.TK2MSFTNGP09.phx.gbl...
> I there a way to connect to a SQL Server when the server is on a
> computer that is apart of a network. I would like to use Windows
> Permissions. Can it be done?
> thanks
> daryl|||Hari Prasad wrote:
> Hi,
> Did you mean that SQL Server machine is in a seperate domain? If yes, then
> you can do this by setting Trust relationship between
> both domains.
> Thanks
> Hari
> SQL Server MVP
Thanks Hari
But no it is not on a domain, I have the network setup as a workgroup.
Each machine is named but they simply belong to a workgroup not a domain
which is the other network option.
daryl|||If you want to use Windows authication, you would need to have the same Wind
ows user name with
synchronized passwords on both machines.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Daryl" <developeracc@.hotmail.com> wrote in message news:eia4lhtTFHA.1384@.TK2MSFTNGP09.phx.g
bl...
> Hari Prasad wrote:
> Thanks Hari
> But no it is not on a domain, I have the network setup as a workgroup. Eac
h machine is named but
> they simply belong to a workgroup not a domain which is the other network
option.
> daryl
>