March 20, 2006 at 4:29 am
Hi
We connect to a sql server through our firewall. In 2000 we had to use Sql Server Network Client Utility for name giving.
How do you do this in 2005 ?
Thx in advance
Kind regards
El JEfe
JV
March 20, 2006 at 7:17 am
You mean aliasing?
The SQL Server Configuration manager does the functionality of the SQL Cient Networking utility as well as the SQL Server Networking Utility and Services manager.
It's an mmc snap-in so you can deploy it to your clients if that's what you need to do.
However I would design my applications to connect to a DNS alias, and use DNS to direct clients to the appropriate server.
March 20, 2006 at 7:26 am
Hi Joseph
We need it for replication between data through firewall.
Can it be done by DNS ? If yes, can you show me the light ?
Thx in advance.
JV
March 20, 2006 at 8:07 am
Oops- wasn't paying attention.
Replication through a firewall should be implemented by using IIS as an intermediary - have a look at "Web Synchronization for Merge Replication " in BOL.
In this scenario your clients connect using a URL through the firewall to the IIS server - IIS then talks to SQL server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply