Haslett, Andrew
andrew.haslett at ilc.gov.au
Mon Aug 25 17:41:20 CDT 2003
No probs. Not your fault. Main thing is that you've got it working. Cheers, Andrew -----Original Message----- From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com] Sent: Monday, 25 August 2003 10:44 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer]SQL server on VLAN, in own workgroup Thank you everyone for your responses.. I am embarrassed to say that the IP address that was given to me from the network administrator was completely wrong. I've wasted almost 2 whole days in time trying to figure this out and now can connect fine without any troubles. I wanted to shove my foot so far up his you know what.... but I thought he made a simple mistake, one that maybe I should've checked on myself in the first place.. I digress.. and apologize if I wasted anyone's time.. thanks, rich -----Original Message----- From: Haslett, Andrew [mailto:andrew.haslett at ilc.gov.au] Sent: Sunday, August 24, 2003 10:20 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer]SQL server on VLAN, in own workgroup 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 _______________________________________________ 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.