RE: Allow access to external SQL server via ODBC thru ISA 2004

Hi Paul,

Thank you for posting in SBS newsgroup.

>From your description, I understand you want to connect to external ODBC
SQL server though SBS with ISA2004. If I have misunderstood your concerns,
please do not hesitate to let me know.

To make the client access normally to external ODBC source, you may need to
configure a protocol definition and a access rule on ISA. You also need to
configure the client computer. For detailed information, please refer to
the following KB article:

837740 How to configure ISA Server 2004 and SQL Server Enterprise Manager to
http://support.microsoft.com/?id=837740

Hope the information help and I look forward to your reply.

Best regards,

Crina Li (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.
--------------------
| Thread-Topic: Allow access to external SQL server via ODBC thru ISA 2004
| | From: "=?Utf-8?B?UGF1bA==?=" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx>
| Subject: Allow access to external SQL server via ODBC thru ISA 2004
| Date: Tue, 13 Dec 2005 14:29:03 -0800
| | Newsgroups: microsoft.public.windows.server.sbs
| |
| I am trying to access an external SQL server via ODBC thru ISA 2004. I
have
| W2K3 Premium with SP1 and have run CEICW, after that I added the 4
scripts
| from isatools.org dealing with bagle, blaster, mydoom, netsky and sasser
so
| they are the top 5 processed rules. Then I created an access rule using
the
| SQL protocol (processed 6), allowing the internal network and local host
to
| access the external network for that protocol only with, allowed with any
| source port. I still get a denied connection from live monitoring, any
idea
| what I need to do at this point? FYI, it works from behind an old linksys
FW
| but not behind ISA.
|
| Thanks for the help.
|
|

.

Relevant Pages

  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • RE: SQL Server Express on SBS2003 standard
    ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... After you applied the SBS 2003 SP1 successfully, you can install the ... SQL Server Express on SBS. ...
    (microsoft.public.windows.server.sbs)
  • Re: Accessing sql server
    ... port, select All ports, in Remote port, select Fixed port and input 1433 ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
    (microsoft.public.windows.server.sbs)
  • Re: Accessing sql server
    ... Filters rule to see if we can resolve this issue. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
    (microsoft.public.windows.server.sbs)