[dba-SQLServer]SQL server on VLAN, in own workgroup

I checked the port which is ok.  The server is not hidden.

as far as the name of the machine, I cannot even ping the machine using the
name, I must use the IP alone.. not sure if that is a result of it being on
its own workgroup network and/or vlan... maybe that is a problem in
itself... 

I'm stumped here.. I can connect to any and all other sql servers using only
the IP address.  These are all in the same domain so it wasn't much of a
challenge.. 

Do I have to set up a trust between the domain and workgroup?  In Mixed mode
is that even possible, or do you have to build a Forest?

Hoping someone may still have an idea!!!

thanks,
Rich

-----Original Message-----
From: Billy Pang [mailto:tuxedo_man at hotmail.com]
Sent: Thursday, August 21, 2003 4:30 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]SQL server on VLAN, in own workgroup


Also, make sure your client is using a port sql server is listening on.

To determine which port sql server is listening on, on the host machine, run

the Server Network Utility and double-click TCP/IP.

HTH

Billy


>From: "Djabarov, Robert" <Robert.Djabarov at usaa.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]SQL server on VLAN, in own workgroup
>Date: Thu, 21 Aug 2003 11:26:40 -0500
>
>Try to register it using its IP.  If it works you can create an alias in
>Client Network utility and re-register it using the alias.
>
>-----Original Message-----
>From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com]
>Sent: Thursday, August 21, 2003 7:11 AM
>To: 'dba-sqlserver at databaseadvisors.com'
>Subject: [dba-SQLServer]SQL server on VLAN, in own workgroup
>
>
>Hello all,
>
>I have a situation..
>
>Setup is Win2K desktop, Win2k SErvers (mix mode Active Directory), SQL
>SErver 2000.
>
>The company I work for has a main office in Pittsburgh, and 2
>manufacturing plants (one in Port Allegany, PA, and one Sedalia,
>Missouri).  We are connected VIA a WAN.  In our Port Plant, we are
>implementing new technology to gather defect information from the plant
>floor.  This information will be held in a sql server database.  The
>software company recommends this system be separated by a VLAN which has
>been set up and is working.  They also recommend having this sql server,
>PLC, and 2 other machines be exclusively on their own network of which a
>workgroup was set up.  I'm not a network kind of guy, know enough to get
>around but that's about it.
>
>So now I'm the SQL server person here.  I'm new to it, learning it as I
>go with a 5 day class under my belt.  We have quite a few sql server
>database servers doing various things, all of which I have taken
>responsibility for. I connect to all of them using Enterprise Manager on
>my machine.  I cannot connect to the new SQL server that is on the VLAN.
>I can ping the server, however using the IP address I cannot register
>the server with my Enterprise Manager.
>
>Has anyone done this, or know how to do this?
>
>Rich