RE: Accessing sql server

Hello John,

Thank you for posting here.

According to your description, I understand that you want to access an
external SQL server (running on standard ports) from SBS. If I have
misunderstood the problem, please don't hesitate to let me know.

Based on my research, I suggest we try the following steps to resolve this
issue:

1. Rerun CEICW
Please carefully rerun the CEICW follow the KB:

How to configure Internet access in Windows Small Business Server 2003
http://support.microsoft.com/kb/825763/en-us

After you run the CEICW, the wizard will create the ISA rule to all ports
access from SBS to external. So we do not need to create a allow rule
manually.

2. You can confirm it from:

a. Open ISA Management console, extend Access Policy

b. You can extend Site and Contend Rules, you will find a rule called
"Small Business Server Internet Access site and Content Rule".

c. You can extend Protocol Rules, you will find a rule called "Small
Business Internet Access Protocol Rule".

If the issue persists, please kindly help me collect some information for
further investigation:

1. What port the external SQL server uses?

2. Can you ping the external SQL server?

3. Try to telnet the standard ports, does it work?

4. Is there any error when you try to access the external SQL server?

5. Please help to gather the ISA Info:

1) Visit www.isatools.org. Click ''ISAinfo for ISA 2000''.

2) Run the script isainfo.vbe on the SBS server.

3) Send the ISAinfo log files to me at v-terliu@xxxxxxxxxxxxxx

6. Please also help to gather the ISA logs:

1) Open ISA Management console, navigate to 'Monitoring
Configuration'\'Logs'. In the right panel, right-click 'Packet filters' and
choose 'Properties'.

2) In the 'Fields' tab, select ALL log fields. Also enable all the log
fields for 'ISA Server Firewall service' and 'ISA Server web proxy service'
log. Navigate to 'Monitoring'\'Services', restart the ISA related services.

3) After reproducing the problem, gather the recent log files in C:\Program
Files\Microsoft ISA Server\ISAlogs\ folder and send them to me for further
research.

Hope these steps will give you some help.

Thanks and have a nice day!

Best regards,

Terence Liu(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Reply-To: "John" <John@xxxxxxxxxxxxxxxxxxxx>
| From: "John" <John@xxxxxxxxxxxxxxxxxxxx>
| Subject: Accessing sql server
| Date: Sun, 21 Jan 2007 03:23:07 -0000
| Lines: 11
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
| Message-ID: <Ojly5tQPHHA.992@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups:
microsoft.public.isa,microsoft.public.isa.configuration,microsoft.public.isa
server,microsoft.public.windows.server.sbs
| NNTP-Posting-Host: 81-86-132-31.dsl.pipex.com 81.86.132.31
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.isa.configuration:464
microsoft.public.isaserver:175 microsoft.public.windows.server.sbs:11700
microsoft.public.isa:936
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Hi
|
| SBS 2003 with ISA2000. I need to access an external sql server (running
on
| standard ports) from within isa 2000. What changes do I need on isa/sbs
to
| accomplish this?
|
| Thanks
|
| Regards
|
|
|

.

Loading