ODBC Access

[NC Beach Bum]

I have a SQL Server in a DMZ and within the LAN I must setup ODBC access so a
use can browse a table and edit the data. The server in the DMZ is not a
member of the Active Directory but can be accessed by IP Address. The
firewall ports are all open for access from the LAN to the DMZ but not from
the DMZ to the LAN. When I try using ODBC to access the DMZ SQL Server it's
a no go. Can someone give me some pointers on the ports that need to be
opened from the DMZ to the LAN and how to use an IP Address in the ODBC
setup?

 

[bcap]

First of all, are you sure that TCP/IP is enabled on the SQL Server
instance? Some editions/versions/service pack levels install with network
protocols disabled by default.

You could try creating an alias on the client. Unfortunately you omitted to
mention what version of SQL Server. For SQL Server 2000, you do this using
the Client Network Utility. For 2005 you do it using the Configuration
Manager. Specify that the protocol is TCP, and the port is 1433 (this is
the default port for SQL Server). Then you can refer to the server by it's
alias.

Whenever you need to refer to a SQL Server instance by IP address, just
replace the server name with the IP address e.g.:

111.111.111.111\my_instance

You might also try a SQL Server newsgroup, this question doesn't really have
anything to do with Access.