[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
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail