ICF, SQL SERVER 2000 and Windows 2003

Is it possible to configure a W2K3 server's ICF (internet connection
firewall) to allow remote connection of EM (enterprise manager) to SQL
Server 2000? I tried creating 2 new "applications" on port 1433 TCP and
1433 UDP, and was unable to connect. Disabling ICF does allow EM to
connect and function.
Tia - MarkCheck your firewall log to see what is being blocked.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

i want to work on both (internet & sql server) simoultaniously.

hi friends

DNS entry is a must in my PC to connect to internet but i canot connect to an MS SQL database server
installed on another machine on same lan. but if i remove DNS entry in my PC i could connect to MSSQLServer but i canot connect internet. i want to work on both simoultaniously.
some one please suggest what to do ..?

stephen

HI,

I had the same thing @. my home. IM having two servers primary and secondary

Primary server --> internet connection available & shared my internet connection and installed sql2005

Secondary server --> I can connect to internet and i can connect to sql using primary server name from this sys

Both the sys are in one-2-one LAN connection and having two ehternet adapaters on primary sys, one for connecting to internet and another one for connecting secondary sys.

i had enabled "share internet option" on the ethernet card that is used to connect to internet in primary sys.
|||hi vidhya sagar

thank you for your reply..

let me go through it..

stephen

I need help with this sql string....({0}, {1},{2}, {3});", Chr(64 + j)

I was looking around on the internet and need something like this:
Dim NumberOfRows As Integer = 10
Dim NumberOfColumns As Integer = 4
Dim PlaneID As String = "3434278231"
Dim SeatType As String
Dim i As Integer
Dim j As Integer

For i = 1 To NumberOfRows
For j = 1 To NumberOfColumns
If j = 2 Or j = 4 Then
'Assuming B & D are Window Seats (j=1 For A, 2 for B and so on)
SeatType = "Window"
Else
SeatType = "Aisle"
End If
Qry = String.Format("INSERT INTO TBL_SEAT (SEAT_NUM, SEAT_ROW, SEAT_TYPE, PLANE_ID) VALUES ('{0}', {1},'{2}', '{3}');", Chr(64 + j), i, SeatType, PlaneID)
MsgBox(Qry)
Next j
Next i

i figured out most of it but need help figureing out how it inserts the seat number and row?

what does all this do: ('{0}', {1},'{2}', '{3}');", Chr(64 + j)

thanks for any advice.Assigns:

SEAT_NUM Chr(64 + j) to '{0}',
SEAT_ROW i to {1},
SEAT_TYPE SeatType to '{2}' and
PLANE_ID PlaneID to '{3}'.

:rolleyes: