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