B. run surnetcn.exe (double click file) on resulting panel make
sure that named pips and tcp are enabled. Select TCP ad view Properties, write
down somewhere where the port number is.
C. Go to the windows control panel
C 1. Click on Administrative tools
C 2. Click on services
C 3. Make sure that any service with the word "sql" is
C 4. Make sure that any service with the keyword "remote"
or "network" are enabled.
C 5. Open "Windows Firewall"
C 6. Examine Server TCP port
1. Navigate to sub-folder C:\Program Files\Microsoft SQLServer\80\Tools\Binn
2. Double click SVRNETCN.exe.
You will see a screen that looks like this:
C.5.1 Select "Exceptions" tab, then Port tab and enter same
port # as in 1B
C.5.2 Select the "Advanced" tab, select
"Settings" for your workgroup connection, then enable all settings
including services as well as ICMP. However, alternatively, just enable
these settings one by one, testing in conjunction with the ODBC step below
that this server-workstation is visible from the ODBC SQL DRIVER below