Install SQL Server 2000 on home network

Hi,

I'm a web developer who is trying to expand my database knowledge by
learning SQL Server 2000 (I've used Access previously) for creating dynamic
web pages. I have two computers, both running Windows XP Pro SP2 that are
networked together through a Netgear wireless router although these two
desktop computers are connected to the router through ethernet cables, not
wireless. On one system I have IIS running, as well as the software I use
on a regular basis, including Dreamweaver MX2004. On the other computer
I've kept it bare bones and am trying to install SQL Server 2000. I've
installed SQL Server with logon set as Local System Account. I should
mention that I don't currently have Windows passwords set up for either
machine (blank) and I have Admin privileges on both. I have not installed
Service Pack 3a yet although I have the cd for that. I'm able to get SQL
Server to start when I start the computer and I can create ODBC connections
on the machine it's running on. What I want to do and I am unable to do is
create an ODBC connection from the other computer to the SQL Server
computer. I'm assume it's a log in and permissions thing but I'm a little
lost. Does anyone have any good resources that address something like this
step by step or does anyone have any advice for doing this? I forgot to
mention that I'm using SQL Server 2000 Developer's Edition. Thank you very
much!

Mark


.

Relevant Pages

  • Re: SQL Server Express: Anybody Using It?
    ... SQL Server Express with Visual Web Developer ... Development for a sever database and desktop database can be done ...
    (comp.databases.ms-access)
  • Missing Remote Administration (HTTP) tool from Add/Remove Programs
    ... I have a web developer that I want to be able to: ... Access my SQL server ... 30 places but step three Install Remote Administration tool is ... Administration tool from being added? ...
    (microsoft.public.windows.server.sbs)
  • Re: Install SQL Server 2000 on home network
    ... > I'm a web developer who is trying to expand my database knowledge by ... > other computer I've kept it bare bones and am trying to install SQL Server ... > connections on the machine it's running on. ...
    (microsoft.public.sqlserver.setup)
  • Re: Missing Remote Administration (HTTP) tool from Add/Remove Programs
    ... I have a web developer that I want to be able to: ... Access my SQL server ... 30 places but step three Install Remote Administration tool is ... Administration tool from being added? ...
    (microsoft.public.windows.server.sbs)
  • Re: .net hosting recommendations
    ... Web Developer / Programmer ... www.aboutfortunate.com "Out of chaos comes order." ... But the others might be a good buy if you don't need SQL Server:> ...
    (microsoft.public.dotnet.framework.aspnet)