Hi all - hope you can help

I have a SQL Server 2008 instance running on a Server 2008 box and can
connect perfectly fine with machines on the network but outside the network
I cannot connect at all.  I have done the following and still cannot connect
with an ODBC connection to be used by an Access 2007 database:

- opened TCP 1433 and UDP 1434 on the Server 2008 box (both inbound and
outbound
- set 1433 and 1434 on the router to forward to the server 2008 box
- enabled TCP/IP in the SQL Server protocol config to not dynamically
assign ports but to listen on 1433 in the ip all section

Still cannot connect from outside the LAN - any idea what I have overlooked?

Have you tried adding sqlserver (from binn directory) program to firewall
exceptions?

jh

Yes that has been added too.  I am at a total loss now especially seeing as
putting the server into the routers DMZ makes no difference to the problem.

The remote machine has Norton 360 installed on it and that has been set to
allow 1433 and 1434 traffic in both directions and its still the same.


Show quoteHide quote

HI Lain,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you have enable TCP/IP and add the
SQL Server program to firewall
exceptions, however we still can't remotely connect to the SQL Server 2008.
Is it correct?
If I have misunderstood, please let me know.

To better understand the issue, please help to confirm/collect the
following.
1 what kind of authentication you use to connect to the SQL Server? if you
use Windows authentication and the user who tries to connect to the SQL
Server is a windows user, the issue you meet seems to be by-design. we need
to create a same windows user with same password on the machine where the
SQL is installed.

2 on the Client, please do the following to narrow down the issue.
ping ipaddress
ping server name

telnet server name 1433
telnet server name 1434

3 to further diagnosis the issue, we need the following information. if it
is convenient to you, please email me. My address is
v-fat***@online.microsoft.com(remove online). and then I can create a work
space for you to upload the required files.
what application you use to connect to the SQL Server

SQL Server error log

Windows event log

screen-shot of the error message


If there is anything unclear, please do not hesitate to let me know.




Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msd***@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

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

Hi Lain,

This is Mark. I'm writing to follow up the post.

If i can assist you anythine related to the issue, please let me know.

I look forward to hearing from you. Thanks.

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msd***@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

text to number <--SQL rookie here Options
dbcc shrinkfile
SQL 2005: "Function argument count error." error
listing sql server and instances
Collation Issue
Active/Active/Active Cluster question
SQL 2000 and 2005 On Save Box
16GB memory for SQL
Oracle Linked Server
Creating a job