>Thanks larry if i include "Network=dbmssocn" in the string will it allow me to use the server name if I so choose or will it now restrict me to just tcp/ip.
>
>Using "Network=dbmssocn" will I be able to do both ????:
>1. Server Name = Name of Server
>2. Server Name = TCP/IP Address
You will be able to do both if the server name is able to be resolved to a TCPIP address. This is done by creating a DNS entry in your DNS server or by using a WINS server to resolve NetBIOS names (i.e. workstation names).
If PING Servername works, then the name is able to be resolved. If not, then you need to talk to your network people about updating the DNS/WINS systems for the SQL Server machine.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao