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

Eric Barro ebarro at afsweb.com
Thu Aug 21 15:43:57 CDT 2003


Rich,

On enterprise manager use the name of the SQL server when connecting...not the IP.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Lavsa,
Rich
Sent: Thursday, August 21, 2003 12:11 PM
To: 'dba-sqlserver at databaseadvisors.com'
Subject: RE: [dba-SQLServer]SQL server on VLAN, in own workgroup


I tried to use the IP Address.. No luck there... 

I tried adding the entry to the HOSTS file as suggested by Eric.. No luck
there either..

and as far as connecting using the client utility.. I'm not sure what I'm
looking at there.. options are TCP/IP and Named Pipes.. looks like it is set
to what it should.. Am I missing something there.. 
How do I go about making a connection with this tool?

-----Original Message-----
From: Djabarov, Robert [mailto:Robert.Djabarov at usaa.com]
Sent: Thursday, August 21, 2003 12:27 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]SQL server on VLAN, in own workgroup


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


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003




More information about the dba-SQLServer mailing list