Norton Internet Security & SQL Server

Hi,

Just installed Norton Internet Security on an XP workstation that also has
SQL Server on it.

I now find that I cannot access SQL Server and multiple messages are being
issued by NIS.

When I switch off the Firewall & Intrusion Detection I can access SQL
Server.

Does anyone know how to configure NIS so that I can use it alongside SQL
Server?

Thanks,

Mike.Uytkownik "Mike Stogden" <news@.uniquest.demon.co.uk> napisa w wiadomoci
news:bhaolh$i5i$1$8300dec7@.news.demon.co.uk...
> Hi,
> Just installed Norton Internet Security on an XP workstation that also has
> SQL Server on it.
> I now find that I cannot access SQL Server and multiple messages are being
> issued by NIS.
> When I switch off the Firewall & Intrusion Detection I can access SQL
> Server.
> Does anyone know how to configure NIS so that I can use it alongside SQL
> Server?
Hi, try this:

permit UDP OUT and IN protocol for

SQL Server Service Manager (sqlmangr.exe)
SQL Server Windows NT (sqlserver.exe)

And TCP OUT and IN protocol for

SQL Tracing Tool (profiler.exe)
ISQL (isqlw.exe)

from any adress:any port and this should work, and then try fit your rules
to be more security

best regards
Marcin D

Non-trusted transactional replication with remote distributor?

I'm trying to find out if it is possible to set up transactional replication
over the internet (non-trusted domains) with a remote distributor which is
also a subscriber, and one additional subscriber. Initial snapshot should be
delivered using FTP. Is this possible or do the distributor and publisher
always both need direct access to the snapshot folder?
Note that we very much prefer not to use the so-called pass-through
autentication hack for the SQL Server Agent accounts, and preferably all
replication agents should run using SQL Authentication. In other words assume
the distributor/subscribers have no (non-FTP) access whatsoever to the
publisher's filesystem, and vice versa. Is this possible or will I run into
connectivity problems?
Thanks in advance.
It should be possible, but its madness for high volume applications. The
problem is if your link between your publisher and subscriber goes down your
tlog will start getting large in a hurry. Not to mention the network hop
between the publisher and the distributor/subscriber.
Why do you feel the need to have a remote distributor? Normally you do this
to offload the distribution agent from the publisher.
You don't really need to worry about pass through authentication when using
FTP as well.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jeremy" <Jeremy@.discussions.microsoft.com> wrote in message
news:C8917D4D-88F6-4CC6-AF06-80A8CB1C2F85@.microsoft.com...
> I'm trying to find out if it is possible to set up transactional
replication
> over the internet (non-trusted domains) with a remote distributor which is
> also a subscriber, and one additional subscriber. Initial snapshot should
be
> delivered using FTP. Is this possible or do the distributor and publisher
> always both need direct access to the snapshot folder?
> Note that we very much prefer not to use the so-called pass-through
> autentication hack for the SQL Server Agent accounts, and preferably all
> replication agents should run using SQL Authentication. In other words
assume
> the distributor/subscribers have no (non-FTP) access whatsoever to the
> publisher's filesystem, and vice versa. Is this possible or will I run
into
> connectivity problems?
> Thanks in advance.
>
sql

Non-standard port through router

Here's my setup. I have an SQL server machine with a local LAN ip. I have
a router with an internet IP. I configured the router to pass external port
5000 through to the sql machine's ip on port 1433. When I try to connect to
the sql server using the router's IP and port 5000 I get a timeout. I can
telnet to the router's IP and port 5000 (get a blank screen, but connection
succeeds).
Does anyone know why I would be getting a timeout? If I (internaly) connect
to the sql machine's local LAN IP port 1433 I can access the SQL server with
no problems.
Hi Lee,
If you get a blank black screen from telnet <MachineName>_or_<IP> <Port
Number>, then you have succeeded in connecting over TCP/IP to the ROUTER
port. We are not able to say it connects to SQL Server's TCP/IP port
successfully. I still think your mapping in router is not configured
correctly.
Secondly, what client tools you used to connect SQL Server? Query Analyzer?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
sql