Friday, March 9, 2012

Is SERVER OS Software needed with SQL Server?

I am learning VB.Net and ADO.Net database programming, so
I bought MS SQL Server 2000 Developer Edition. I need
some guidance on how to set it up over my LAN.
I installed SQL Server 2000 on a Win 2k Pro machine. I
would like to serve from here, then use a Win XP machine
for client apps for testing. When installing SQL Server, I
gave it a new domain name when asked. But i can't get the
client machine to find the domain. Is a DNS issue? Does
the SQL Server machine have to run Win 2k SERVER to get it
to be a DSN server? I hope not, can't afford Win Server OS
at this time. Thanks in advance."Larry" <anonymous@.discussions.microsoft.com> wrote in message
news:009001c3d3a3$f5179800$a101280a@.phx.gbl...
> I am learning VB.Net and ADO.Net database programming, so
> I bought MS SQL Server 2000 Developer Edition. I need
> some guidance on how to set it up over my LAN.
> I installed SQL Server 2000 on a Win 2k Pro machine. I
> would like to serve from here, then use a Win XP machine
> for client apps for testing. When installing SQL Server, I
> gave it a new domain name when asked. But i can't get the
> client machine to find the domain. Is a DNS issue? Does
> the SQL Server machine have to run Win 2k SERVER to get it
> to be a DSN server? I hope not, can't afford Win Server OS
> at this time. Thanks in advance.
You don't need a server to perform you testing... I'm not sure I understand
what you mean by "domain" name. Are your computers part of a workgroup?
Assuming that SQL Server is installed correctly and running, have you
enabled the File and Printer sharing from your W2K client? To rule out DNS
issues, from your XP client try connecting to your SQL Server by using the
IP address of that W2K machine.
Steve

No comments:

Post a Comment