SBS and SQL Server on existing network

From: Mr. A (rocklobsterNOSPAM_at_techie.com)
Date: 01/09/05 

Date: Sun, 9 Jan 2005 10:19:58 -0500

Our old Win2k server is dying, so I recently purchased a new server and SBS
Premium, mainly fot SQL server 2000.

Our old server was set up as simple peer to peer, and PCs would connect
using either access project (.adp) databases or attached mdb databases,
along with some asp.net apps.

When I set up the new server, I accepted most of the default settings, and
now it is not part of the original workgroup, but looks like it is a new
one.

I can connect to SQL server on this machine from client PCs as long as they
are Windows XP. The other PCs in the office are Win2k, and I'm having fits
trying to connect them to SQL server on this thing. Only one of the Windows
2000 PCs (mine, which I've used mainly for development) can "see" the server
when you go into setting up an odbc connection. The others can only see the
database if you log into the new server as a user - something I'm trying to
avoid.

Any ideas on what could be causing the other Win2k clients to not access the
database?

Relevant Pages

  • Re: How to move system databases to new SAN drive in cluster serve
    ... I have moved model, msdb, and tempdb on a cluster ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrate stand alone sql server to a cluster without downtime
    ... Use backup and restore to create the databases on the new system. ... Run a log backup WITH STANDBY on each database on the old server. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: SPS 2003 Portal change SQL server
    ... select portal site to delete and choose to NOT delete the databases ... server farm, you can just copy them over. ... attach the databases to the new sql server. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Moving SQL Server 2000 to a new machine
    ... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving databases to a new server
    ... Moving Databases between Servers ... Disaster Recovery Articles for SQL Server ... I am leaning toward the detach and> attach method but I want to make sure there are not any hidden problems with> this method. ...
    (microsoft.public.sqlserver.setup)