MS SQL 2008 and MS SQL 2008 Express
-
Hi,
I am new and I have problems with setting up replication between to MS SQL servers. The publisher is MS SQL 2008 server and is situated in Intranet. The second server is MS SQL 2008 Express is in DMZ. I need to set up push subscription. I have set up distribution, publication without problems. But when I want to set up push subscription than I have got error on the picture.
I have created on server firewall outbound and inbound rules for port TCP 1433 and I have also opened TCP 1433on ASA firewall to DMZ .
Thanks for help
-
Hi,
Hope this steers you in the right direction:
1: The port of named instances will generally not be 1433
2: External access is disabled by default, so you would need to enable TCP/IP and/or named pipes in order to connect remotely (Do this in SQL Server Configuration Manager, you'll also find the TCP/IP port here)
3: When you do allow the correct port on the firewall, you'll also need to set up an alias on the connecting server specifiying the instance name/port number as unless you have the SQL Server Browser Service running and have access to port 1434, it won't find the instance (P.S. I wouldn't recommend enabling this service in a web environment).
Never ever let SQL ports be accessible via the internet at all unless it's heavily restricted to trusted IP addresses and proper consideration has been given to locking down access/enforcing password compliance.
-
Also, for more information on the above, the following areas in BOL should help out:
Configure the SQL Server to listen on a specific port (for security reasons, pick a non-standard port)
http://msdn.microsoft.com/en-us/library/ms177440.aspx
How to create a new Network Alias from the local server:
http://msdn.microsoft.com/en-us/library/ms188635.aspx
More information on the SQL Server Browser Service:
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply