Re: Accessing sql server
- From: "John" <John@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 24 Jan 2007 01:27:11 -0000
Hi Terence
This seems to have done the trick. Many thanks for that. Much appreciated.
Regards
"Terence Liu [MSFT]" <v-terliu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:WFkmg7tPHHA.2304@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello John,
Thank you for kind update.
Based on my further research, I suggest we try to create an IP Packet
Filters rule to see if we can resolve this issue.
1. Please open ISA management console, extend Access Policy-> IP Packet
Filters
2. Right click IP Packet Filters, select New->Filter
3. Input the name of the rule, click Next
4. Select Allow packet transmission, click Next
5. Select Custom, click Next
6. In IP protocol, select TCP, in Direction, select Outbound, in Local
port, select All ports, in Remote port, select Fixed port and input 1433
in
the Port number, click Next
7. Click Next twice and finish the wizard.
8. Extend Monitoring->Services, restart the Firewall service.
Then test the issue.
Hope these steps will give you some help.
Thanks and have a nice day!
Terence Liu
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>
| References: <Ojly5tQPHHA.992@xxxxxxxxxxxxxxxxxxxx>
<C7K5OjfPHHA.4020@xxxxxxxxxxxxxxxxxxxxxx>
| Subject: Re: Accessing sql server
| Date: Mon, 22 Jan 2007 19:32:27 -0000
| Lines: 162
| 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: <uuPINwlPHHA.992@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: 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.windows.server.sbs:11969
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Hi Liu
|
| I have now checked and I can access the sql server when creating an ODBC
| User DSN on client PCs. I do not however have access on the sbs server
| itself when creating the ODBC User DSN. Does that mean I need to install
| firewall client on server to make it work?
|
| Thanks
|
| Regards
|
|
| "Terence Liu [MSFT]" <v-terliu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| news:C7K5OjfPHHA.4020@xxxxxxxxxxxxxxxxxxxxxxxxx
| > 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
| > |
| > |
| > |
| >
|
|
|
.
- Follow-Ups:
- Re: Accessing sql server
- From: Terence Liu [MSFT]
- Re: Accessing sql server
- References:
- RE: Accessing sql server
- From: Terence Liu [MSFT]
- Re: Accessing sql server
- From: John
- Re: Accessing sql server
- From: Terence Liu [MSFT]
- RE: Accessing sql server
- Prev by Date: Migrating SBS 2003 R2 Premium to New Hardware
- Next by Date: Re: create forwarding email without user account
- Previous by thread: Re: Accessing sql server
- Next by thread: Re: Accessing sql server
- Index(es):
Relevant Pages
|
