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

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.


More information about the dba-SQLServer mailing list