Re: Merge Replication Security
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I would recommend using merge over HTTPS (port 443) if you are concerned
about security and as you are using SQL Server 2005.
Static IPs allowed through the firewall can also be used in this scenario.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
.
Relevant Pages
- Re: hack using xp_cmdshell
... I'm no security expert, so please forgive if I'm not using the right ... install SQL Server in Windows Only mode and then Switch down to Mixed mode, ... Is the SQL Server instance a default instance? ... > port 65300, which has never been open on my firewall. ... (microsoft.public.sqlserver.server) - Re: ADP problems after SQL 2005 Upgrade
... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ... (microsoft.public.access.adp.sqlserver) - [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ... (Securiteam) - Re: Do SqlServer 2000 & SqlServer 2005 co-exist
... Either SQL Server 2000 or SQL Server 2005. ... So you have to move one of them to another port. ... You could allow an program exception in your firewall instead of a port number exception. ... I understand that you can connect to SQL 2000 named instance on the local ... (microsoft.public.sqlserver.setup) - Re: IIS, SQL 2000 & XPs Firewall
... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ... (microsoft.public.sqlserver.connect) |
|