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

Norton Antivirus / SQL Server

I have a Windows 2003 Server STD box with SQL Server 2000 STD on it. I want
to install Norton Antivirus Corporate. Are there any Norton/SQL issues that I
need to be aware of? (ie. folders to exclude, performance issues).Exclude all SQL data, log, and backup file folders. Limit access to these
folders as much as possible through NTFS permissions. Do not use any AV
product from any vendor on a clustered SQL Server.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:0D69F483-0A5C-4A9A-AFD2-831BEDE16BFA@.microsoft.com...
>I have a Windows 2003 Server STD box with SQL Server 2000 STD on it. I want
> to install Norton Antivirus Corporate. Are there any Norton/SQL issues
> that I
> need to be aware of? (ie. folders to exclude, performance issues).

Norton Antivirus / SQL Server

I have a Windows 2003 Server STD box with SQL Server 2000 STD on it. I want
to install Norton Antivirus Corporate. Are there any Norton/SQL issues that I
need to be aware of? (ie. folders to exclude, performance issues).
Exclude all SQL data, log, and backup file folders. Limit access to these
folders as much as possible through NTFS permissions. Do not use any AV
product from any vendor on a clustered SQL Server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:0D69F483-0A5C-4A9A-AFD2-831BEDE16BFA@.microsoft.com...
>I have a Windows 2003 Server STD box with SQL Server 2000 STD on it. I want
> to install Norton Antivirus Corporate. Are there any Norton/SQL issues
> that I
> need to be aware of? (ie. folders to exclude, performance issues).
sql

Norton Antivirus / SQL Server

I have a Windows 2003 Server STD box with SQL Server 2000 STD on it. I want
to install Norton Antivirus Corporate. Are there any Norton/SQL issues that
I
need to be aware of? (ie. folders to exclude, performance issues).Exclude all SQL data, log, and backup file folders. Limit access to these
folders as much as possible through NTFS permissions. Do not use any AV
product from any vendor on a clustered SQL Server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:0D69F483-0A5C-4A9A-AFD2-831BEDE16BFA@.microsoft.com...
>I have a Windows 2003 Server STD box with SQL Server 2000 STD on it. I want
> to install Norton Antivirus Corporate. Are there any Norton/SQL issues
> that I
> need to be aware of? (ie. folders to exclude, performance issues).

Norton anti virus on Sql server

As part of the Security Initiative, Our security team wants to put
Anti-Virus protection on All Sql server database.
Is it good a practice to Install Anti Virus software on Sql servers?
Has anybody installed it on their production system? Any issues with it?
I appreciate your answer.
James,
[vbcol=seagreen]
I certainly would.No compromise, even when the server is not connected to
internet.
[vbcol=seagreen]
Exclude the SQLServer files - mdf,ndf and ldf etc from being scanned.Also,
whenever you are doing any setup from a recognised media, make sure to stop
the AV service and turn it back on when you are done.
'INF: Consideration for a Virus Scanner on a Computer That Is Running SQL
Server'
http://support.microsoft.com/default.aspx?id=309422
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"james" <kush@.brandes.com> wrote in message
news:uF$IIA8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> As part of the Security Initiative, Our security team wants to put
> Anti-Virus protection on All Sql server database.
> Is it good a practice to Install Anti Virus software on Sql servers?
> Has anybody installed it on their production system? Any issues with it?
> I appreciate your answer.
>

Norton anti virus on Sql server

As part of the Security Initiative, Our security team wants to put
Anti-Virus protection on All Sql server database.
Is it good a practice to Install Anti Virus software on Sql servers?
Has anybody installed it on their production system? Any issues with it?
I appreciate your answer.James,

I certainly would.No compromise, even when the server is not connected to
internet.
[vbcol=seagreen]
Exclude the SQLServer files - mdf,ndf and ldf etc from being scanned.Also,
whenever you are doing any setup from a recognised media, make sure to stop
the AV service and turn it back on when you are done.
'INF: Consideration for a Virus Scanner on a Computer That Is Running SQL
Server'
http://support.microsoft.com/default.aspx?id=309422
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"james" <kush@.brandes.com> wrote in message
news:uF$IIA8MEHA.3636@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> As part of the Security Initiative, Our security team wants to put
> Anti-Virus protection on All Sql server database.
> Is it good a practice to Install Anti Virus software on Sql servers?
> Has anybody installed it on their production system? Any issues with it?
> I appreciate your answer.
>

Norton anti virus on Sql server

As part of the Security Initiative, Our security team wants to put
Anti-Virus protection on All Sql server database.
Is it good a practice to Install Anti Virus software on Sql servers?
Has anybody installed it on their production system? Any issues with it?
I appreciate your answer.James,
>> Is it good a practice to Install Anti Virus software on Sql servers?
I certainly would.No compromise, even when the server is not connected to
internet.
>>Any issues with it?
Exclude the SQLServer files - mdf,ndf and ldf etc from being scanned.Also,
whenever you are doing any setup from a recognised media, make sure to stop
the AV service and turn it back on when you are done.
'INF: Consideration for a Virus Scanner on a Computer That Is Running SQL
Server'
http://support.microsoft.com/default.aspx?id=309422
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"james" <kush@.brandes.com> wrote in message
news:uF$IIA8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> As part of the Security Initiative, Our security team wants to put
> Anti-Virus protection on All Sql server database.
> Is it good a practice to Install Anti Virus software on Sql servers?
> Has anybody installed it on their production system? Any issues with it?
> I appreciate your answer.
>