Haslett, Andrew
andrew.haslett at ilc.gov.au
Sun Aug 24 21:20:29 CDT 2003
Rich, assuming you are authenticating through mixed mode, then you shouldn't have to set up a trust. The fact that you cannot ping the server by its name means that there is no DNS server resolving its name that you can access, which as I understand it, means that Names Pipes cannot be used (not sure about that though). Therefore you must ensure TCP/IP is setup in the Server network utility (and the network card on the server) and the client network utility on your machine to create an ALIAS. Are you sure the SQL account you are trying to connect to on the server is availiable and it is running in mixed mode? Is it running in 'Single-User-Mode'? Can you connect to the server FROM the server itself using this account? Have you tried connecting to the server using the IP address AND the port number eg. 192.168.0.44:1433? Perhaps you can tell us what the TCP/IP settings are on your network card (such as IP address, subnet, dns, gateway) and of the network card on the server. (You can also type ipconfig /all at a command prompt to get this info). Definitely a puzzling one! Cheers, Andrew -----Original Message----- From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com] Sent: Friday, 22 August 2003 9:32 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.