Anyone have sp_oacreate and SQL2005 issues?

We use a few in house built COM objects that we call from stored procedures
quite often during the day. They are called from linked servers - so all
COM stuff is run on a dedicated box. Both servers are running SQL 2005 SP2.
The server that does all the COM object (sp_oacreate) work will lockup on a
daily basis and we have to restart sql service to fix. Also, we see SPIDs
on the COM box stuck in Rollback status and have to restart SQL to fix. Has
anyone seen any of these issues while migrating to SQL 2005?
Thanks,
Chuck Lathrope
www.sqlwebpedia.com
Chuck,
This is what you mean: - http://support.microsoft.com/kb/937277/en-us
which talks about sp_OAMethod not sp_OACreate.
Chris
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:120gcwua7do0w$.106toy5xoolnq.dlg@.40tude.net.. .
> We use a few in house built COM objects that we call from stored
> procedures
> quite often during the day. They are called from linked servers - so all
> COM stuff is run on a dedicated box. Both servers are running SQL 2005
> SP2.
> The server that does all the COM object (sp_oacreate) work will lockup on
> a
> daily basis and we have to restart sql service to fix. Also, we see SPIDs
> on the COM box stuck in Rollback status and have to restart SQL to fix.
> Has
> anyone seen any of these issues while migrating to SQL 2005?
> Thanks,
> Chuck Lathrope
> www.sqlwebpedia.com
|||On Thu, 19 Jul 2007 13:02:00 -0600, Chris Wood wrote:

> http://support.microsoft.com/kb/937277/en-us
That looks very promising! I have been searching net on sp_oacreate and
never saw this. Thanks. I will ask my PSS engineer if I can get the hotfix.
-Chuck
|||Hi Chuck,
Since you are on SP2, i doubt this hotfix will help you, as the SP2
build is 3042, and the above issue is fixed in 2232
HTH,
Dinesh
sql

Anyone have sp_oacreate and SQL2005 issues?

We use a few in house built COM objects that we call from stored procedures
quite often during the day. They are called from linked servers - so all
COM stuff is run on a dedicated box. Both servers are running SQL 2005 SP2.
The server that does all the COM object (sp_oacreate) work will lockup on a
daily basis and we have to restart sql service to fix. Also, we see SPIDs
on the COM box stuck in Rollback status and have to restart SQL to fix. Has
anyone seen any of these issues while migrating to SQL 2005?
Thanks,
Chuck Lathrope
www.sqlwebpedia.comChuck,
This is what you mean: - http://support.microsoft.com/kb/937277/en-us
which talks about sp_OAMethod not sp_OACreate.
Chris
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:120gcwua7do0w$.106toy5xoolnq.dlg@.40tude.net...
> We use a few in house built COM objects that we call from stored
> procedures
> quite often during the day. They are called from linked servers - so all
> COM stuff is run on a dedicated box. Both servers are running SQL 2005
> SP2.
> The server that does all the COM object (sp_oacreate) work will lockup on
> a
> daily basis and we have to restart sql service to fix. Also, we see SPIDs
> on the COM box stuck in Rollback status and have to restart SQL to fix.
> Has
> anyone seen any of these issues while migrating to SQL 2005?
> Thanks,
> Chuck Lathrope
> www.sqlwebpedia.com|||On Thu, 19 Jul 2007 13:02:00 -0600, Chris Wood wrote:

> http://support.microsoft.com/kb/937277/en-us
That looks very promising! I have been searching net on sp_oacreate and
never saw this. Thanks. I will ask my PSS engineer if I can get the hotfix.
-Chuck|||Hi Chuck,
Since you are on SP2, i doubt this hotfix will help you, as the SP2
build is 3042, and the above issue is fixed in 2232
HTH,
Dinesh

Anyone have sp_oacreate and SQL2005 issues?

We use a few in house built COM objects that we call from stored procedures
quite often during the day. They are called from linked servers - so all
COM stuff is run on a dedicated box. Both servers are running SQL 2005 SP2.
The server that does all the COM object (sp_oacreate) work will lockup on a
daily basis and we have to restart sql service to fix. Also, we see SPIDs
on the COM box stuck in Rollback status and have to restart SQL to fix. Has
anyone seen any of these issues while migrating to SQL 2005?
Thanks,
Chuck Lathrope
www.sqlwebpedia.comChuck,
This is what you mean: - http://support.microsoft.com/kb/937277/en-us
which talks about sp_OAMethod not sp_OACreate.
Chris
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:120gcwua7do0w$.106toy5xoolnq.dlg@.40tude.net...
> We use a few in house built COM objects that we call from stored
> procedures
> quite often during the day. They are called from linked servers - so all
> COM stuff is run on a dedicated box. Both servers are running SQL 2005
> SP2.
> The server that does all the COM object (sp_oacreate) work will lockup on
> a
> daily basis and we have to restart sql service to fix. Also, we see SPIDs
> on the COM box stuck in Rollback status and have to restart SQL to fix.
> Has
> anyone seen any of these issues while migrating to SQL 2005?
> Thanks,
> Chuck Lathrope
> www.sqlwebpedia.com|||On Thu, 19 Jul 2007 13:02:00 -0600, Chris Wood wrote:
> http://support.microsoft.com/kb/937277/en-us
That looks very promising! I have been searching net on sp_oacreate and
never saw this. Thanks. I will ask my PSS engineer if I can get the hotfix.
-Chuck|||Hi Chuck,
Since you are on SP2, i doubt this hotfix will help you, as the SP2
build is 3042, and the above issue is fixed in 2232
HTH,
Dinesh

Any whitepaper that talks on Web Servers to SQL server connections

I can understand when theres SQL authentication involved and how one may
pass the SQL Server credentials that way ..
But cant figure out how would IIS connect using Windows Authentication ?
What Windows login would these web servers need ? Do i create that same
login on all Web Servers and also on SQL .. What this anonymous login ? We
want to tighten the controls using Windows Authentication and dont know how
to do so with Web Servers..
Authentication and Security White Paper for Internet Developers
http://support.microsoft.com/default...b;en-us;174811
Understanding Internet Information Security
http://www.microsoft.com/ntserver/te.../iissecure.asp
AMB
"Hassan" wrote:

> I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know how
> to do so with Web Servers..
>
>
|||This paper discusses the ASP.NET model. Basically it looks like you have to
grant the ASPNET user database and some other permissions. Hope this helps:
http://msdn.microsoft.com/library/de...SecNetch08.asp
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OneQ%23N3RFHA.3732@.tk2msftngp13.phx.gbl...
>I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know
> how
> to do so with Web Servers..
>

Any whitepaper that talks on Web Servers to SQL server connections

I can understand when theres SQL authentication involved and how one may
pass the SQL Server credentials that way ..
But cant figure out how would IIS connect using Windows Authentication ?
What Windows login would these web servers need ? Do i create that same
login on all Web Servers and also on SQL .. What this anonymous login ? We
want to tighten the controls using Windows Authentication and dont know how
to do so with Web Servers..Authentication and Security White Paper for Internet Developers
http://support.microsoft.com/default.aspx?scid=kb;en-us;174811
Understanding Internet Information Security
http://www.microsoft.com/ntserver/techresources/webserv/iissecure.asp
AMB
"Hassan" wrote:
> I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know how
> to do so with Web Servers..
>
>|||This paper discusses the ASP.NET model. Basically it looks like you have to
grant the ASPNET user database and some other permissions. Hope this helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch08.asp
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OneQ%23N3RFHA.3732@.tk2msftngp13.phx.gbl...
>I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know
> how
> to do so with Web Servers..
>

Any whitepaper that talks on Web Servers to SQL server connections

I can understand when theres SQL authentication involved and how one may
pass the SQL Server credentials that way ..
But cant figure out how would IIS connect using Windows Authentication ?
What Windows login would these web servers need ? Do i create that same
login on all Web Servers and also on SQL .. What this anonymous login ? We
want to tighten the controls using Windows Authentication and dont know how
to do so with Web Servers..Authentication and Security White Paper for Internet Developers
http://support.microsoft.com/defaul...kb;en-us;174811
Understanding Internet Information Security
http://www.microsoft.com/ntserver/t...v/iissecure.asp
AMB
"Hassan" wrote:

> I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know ho
w
> to do so with Web Servers..
>
>|||This paper discusses the ASP.NET model. Basically it looks like you have to
grant the ASPNET user database and some other permissions. Hope this helps:
Netch08.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
Netch08.asp
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OneQ%23N3RFHA.3732@.tk2msftngp13.phx.gbl...
>I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know
> how
> to do so with Web Servers..
>

Any way to tell what traces are running?

I have a stored proc where I create a SQL trace (using sp_trace_create). I
went onto one of my servers to fire off a trace and noticed that another one
has been running for a few days.
Is there any way to display the traces that are running on a particular
server? I would like to stop the old trace but I can't figure out how
Any help would be appreciated.
Thanks in advance.
TomIt figures - I was looking for this info all day yesterday. Right after
posting this, I finally discovered it.
The following SQL statement displays info on traces running
SELECT * FROM :: fn_trace_getinfo(default)
It seems that when I started the new trace, it was assigned TraceId=1 and
the old trace was bumped to TraceId=2. I then just issued the following to
kill trace 2:
EXEC sp_trace_setstatus 2, 0
EXEC sp_trace_setstatus 2, 2
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:#MUmQPzuDHA.1088@.tk2msftngp13.phx.gbl...
> I have a stored proc where I create a SQL trace (using sp_trace_create).
I
> went onto one of my servers to fire off a trace and noticed that another
one
> has been running for a few days.
> Is there any way to display the traces that are running on a particular
> server? I would like to stop the old trace but I can't figure out how
> Any help would be appreciated.
> Thanks in advance.
> Tom
>|||You can run from QueryAnalyzer statement DBCC TRACESTATUS (-1) , and you will see all traces that have been set
Something like
TraceFlag TraceStatu
1204
Hope it Helps

Any tool to give me some live metrics

Id like a nice front end that I can drop to get the server I want or even
combine multiple perfmon sessions for servers in one look and feel.
I also want to look at event logs, current OS /SQL info.. Current
applications running...etc..
Right now, if i have to go to the logs, i have to go to the manage
properties of My computer.. and connect to the server..
Also open Perfmon and select the server.. or even worse, log on to the
server itself to look at current running processes.. I want to make our job
easier by having this one console that i can just drop down on the server I
want and it gives me most of the live info..Something with a web interface
would also be better..
You could check http://www.imceda.com/Product.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eznApwkBFHA.3616@.TK2MSFTNGP11.phx.gbl...
> Id like a nice front end that I can drop to get the server I want or even
> combine multiple perfmon sessions for servers in one look and feel.
> I also want to look at event logs, current OS /SQL info.. Current
> applications running...etc..
> Right now, if i have to go to the logs, i have to go to the manage
> properties of My computer.. and connect to the server..
> Also open Perfmon and select the server.. or even worse, log on to the
> server itself to look at current running processes.. I want to make our
job
> easier by having this one console that i can just drop down on the server
I
> want and it gives me most of the live info..Something with a web interface
> would also be better..
>
|||Hello Hassan,
Check out http://www.quest.com/Quest_Central_f...agnostics.asp. We have a lot of other SQL Server tools which you can see at http://www.quest.com/Quest_Central_for_SQL_Server.
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> Id like a nice front end that I can drop to get the server I want or
> even combine multiple perfmon sessions for servers in one look and
> feel.
> I also want to look at event logs, current OS /SQL info.. Current
> applications running...etc..
> Right now, if i have to go to the logs, i have to go to the manage
> properties of My computer.. and connect to the server..
> Also open Perfmon and select the server.. or even worse, log on to the
> server itself to look at current running processes.. I want to make
> our job
> easier by having this one console that i can just drop down on the
> server I
> want and it gives me most of the live info..Something with a web
> interface
> would also be better..

Any special care for CLR code when moving to other servers

I am pretty certain that once you create an assembly referring to a dll on
one server, and i decide to move that database to another server, the
assembly goes with it as part of the database and I dont have to recreate
the assembly or move the dll to the other server.. am i right ?Yes, you are right, the assembly is part of the database, even if you move
the database to another database server.
Also notice that by default on SQL Server CLR Integration is disabled so you
may need to enable it first.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:

> I am pretty certain that once you create an assembly referring to a dll on
> one server, and i decide to move that database to another server, the
> assembly goes with it as part of the database and I dont have to recreate
> the assembly or move the dll to the other server.. am i right ?
>
>

Any special care for CLR code when moving to other servers

I am pretty certain that once you create an assembly referring to a dll on
one server, and i decide to move that database to another server, the
assembly goes with it as part of the database and I dont have to recreate
the assembly or move the dll to the other server.. am i right ?Yes, you are right, the assembly is part of the database, even if you move
the database to another database server.
Also notice that by default on SQL Server CLR Integration is disabled so you
may need to enable it first.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I am pretty certain that once you create an assembly referring to a dll on
> one server, and i decide to move that database to another server, the
> assembly goes with it as part of the database and I dont have to recreate
> the assembly or move the dll to the other server.. am i right ?
>
>

Any special care for CLR code when moving to other servers

I am pretty certain that once you create an assembly referring to a dll on
one server, and i decide to move that database to another server, the
assembly goes with it as part of the database and I dont have to recreate
the assembly or move the dll to the other server.. am i right ?
Yes, you are right, the assembly is part of the database, even if you move
the database to another database server.
Also notice that by default on SQL Server CLR Integration is disabled so you
may need to enable it first.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:

> I am pretty certain that once you create an assembly referring to a dll on
> one server, and i decide to move that database to another server, the
> assembly goes with it as part of the database and I dont have to recreate
> the assembly or move the dll to the other server.. am i right ?
>
>

Any solution for that?

I've got a .dts which load data to several Sql2k servers by Copy SQL Server Objects Task. I'd like to add another task for a Sql25k but I can't because of it's requesting SMO.

It seems that such task need DMO. I know that there are other ways for do such stuff in that DTS but I wonder if there is any trick or shortcut for to avoid this barrier.

How odd, if you use Dts Import/Export Wizard from EM sql25k is accepted.

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.Hi Hassan
"Hassan" wrote:
> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.html?
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
>> This is not just tied to disk space, but also CPU load, IO, n/w
>> throughput,etc.. Thank you.
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.html?
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.
Hi Hassan
"Hassan" wrote:

> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
[url]http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.htm l?[/url]
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John
|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> [url]http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.htm l?[/url]
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.Hi Hassan
"Hassan" wrote:

> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
http://searchwincomputing.techtarge...yr2005,00.html?
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
>
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> http://searchwincomputing.techtarge...yr2005,00.html?
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John

Any Advice on transact repl error

Hi All, We are using SQL2000 servers with transact replication to a warm
stand-by server. We are seeing the following error from the Log reader
agents.

Does anyone have any insight on this error?

The process could not execute 'sp_MSadd_repl_commands27hp'

TIA Scott B."Scott Bradley" <blah@.blah.comwrote in message
news:HTm_i.9413$ww2.2129@.newssvr19.news.prodigy.ne t...

Quote:

Originally Posted by

Hi All, We are using SQL2000 servers with transact replication to a warm
stand-by server. We are seeing the following error from the Log reader
agents.
>
Does anyone have any insight on this error?
>
The process could not execute 'sp_MSadd_repl_commands27hp'
>
TIA Scott B.
>
>

|||"Scott Bradley" <blah@.blah.comwrote in message
news:HTm_i.9413$ww2.2129@.newssvr19.news.prodigy.ne t...

Quote:

Originally Posted by

Hi All, We are using SQL2000 servers with transact replication to a warm
stand-by server. We are seeing the following error from the Log reader
agents.
>
Does anyone have any insight on this error?
>
The process could not execute 'sp_MSadd_repl_commands27hp'
>

We saw this happen from time to time. Never found the solution.

Put a retry on the job and then alert upon COMPLETION (not just failure) and
restart when needed.

Quote:

Originally Posted by

TIA Scott B.
>
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||What job. I haven't been able to determine which job is calling the sp in
question.
The log reader agent retries 10 ties then 'fails'. Sometime I can get things
work by restarting teh agent. Other times I have to reboot the subscribing
server, which where I also run the distribution agents.
Thanks, Scott B.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.comwrote in message
news:13jksd0rea3mabe@.corp.supernews.com...

Quote:

Originally Posted by

"Scott Bradley" <blah@.blah.comwrote in message
news:HTm_i.9413$ww2.2129@.newssvr19.news.prodigy.ne t...

Quote:

Originally Posted by

Hi All, We are using SQL2000 servers with transact replication to a warm
stand-by server. We are seeing the following error from the Log reader
agents.

Does anyone have any insight on this error?

The process could not execute 'sp_MSadd_repl_commands27hp'

>
We saw this happen from time to time. Never found the solution.
>
Put a retry on the job and then alert upon COMPLETION (not just failure)

and

Quote:

Originally Posted by

restart when needed.
>
>

Quote:

Originally Posted by

TIA Scott B.

>
>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com

http://www.greenms.com/sqlserver.html

Quote:

Originally Posted by

>
>

AntiVirus Software for SQL Cluster Servers

Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
software I should use. Any information will be greatly appreciated.
I like TrendMicro, whatever you get - exclude the MSCS and data directories,
if not the entire shared disks at a minimum.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
> Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
> software I should use. Any information will be greatly appreciated.
>
|||I have never used TrendMicro. Should I order a specific version? will it be
aware of the cluster?
Thanks for your help!
Yuhong
"Rodney R. Fournier [MVP]" wrote:

> I like TrendMicro, whatever you get - exclude the MSCS and data directories,
> if not the entire shared disks at a minimum.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
>
>
|||The latest OfficeScan is cluster aware. Don't let the silly name fool you,
it work for both workstations and servers.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:E2E02DA9-F7B3-48C4-9846-7B0835B4A09D@.microsoft.com...[vbcol=seagreen]
>I have never used TrendMicro. Should I order a specific version? will it be
> aware of the cluster?
> Thanks for your help!
> Yuhong
> "Rodney R. Fournier [MVP]" wrote:
|||Great. Thanks so much for your information!
Yuhong
"Rodney R. Fournier [MVP]" wrote:

> The latest OfficeScan is cluster aware. Don't let the silly name fool you,
> it work for both workstations and servers.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:E2E02DA9-F7B3-48C4-9846-7B0835B4A09D@.microsoft.com...
>
>
|||We use McAfee VirusScan on our clusters. It seems to be working fine. As
Rodney mentioned, do exclude the SQL Server files from scan.
Linchi
"Yuhong" wrote:

> Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
> software I should use. Any information will be greatly appreciated.
>
|||Thanks, Linchi! I will look into these products.
"Linchi Shea" wrote:
[vbcol=seagreen]
> We use McAfee VirusScan on our clusters. It seems to be working fine. As
> Rodney mentioned, do exclude the SQL Server files from scan.
> Linchi
> "Yuhong" wrote:
|||In addition, exclude any backup file locations from virus scan, either on
the local box or on a network share. You don't want to see what happens to
a SQL server if an AV program detects a virus in the backup data stream. It
isn't pretty.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
> Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
> software I should use. Any information will be greatly appreciated.
>
|||OK. Thanks!
Do I need to exclude the MSDTC cluster resource drive from the scan also?
"Geoff N. Hiten" wrote:

> In addition, exclude any backup file locations from virus scan, either on
> the local box or on a network share. You don't want to see what happens to
> a SQL server if an AV program detects a virus in the backup data stream. It
> isn't pretty.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
>
|||I would!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:2CA26428-B8A6-47FB-8DEC-F031CB34F449@.microsoft.com...[vbcol=seagreen]
> OK. Thanks!
> Do I need to exclude the MSDTC cluster resource drive from the scan also?
>
> "Geoff N. Hiten" wrote:

Anti-Virus on SQL Server? - Merits and Arguments?

Do any of you run any anti-virus software on your SQL Servers -- for
dedicated SQL Server boxes?
We have some varying views within our organization on what approach to take
to protecting the SQL Server.
We do not have any file shares, or IIS or any unneeded services running on
our dedicated SQL Server's -- thus I guess I do not see the merit of using
anti-virus software on the SQL Server itself when the attach vectors are
fairly minimized.
Our SQL Servers are all internal, no DMZ, no external. The only major
vulnerability would be internal threats (which are minimized by other
internal controls, i.e. AV at the desktop, etc.).
Is patch management, properly configured SQL Server security, and a good
understanding of what services are open on the particular box enough to
protect against 90-95% of the vulnerabilities that may exist?
Thanks for your opinion,
Aaron"Aaron Vance" <thisisnttheemailyourlookingfor@.nospam.com> wrote in message
news:u$mL3kF4DHA.3576@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Do any of you run any anti-virus software on your SQL Servers -- for
> dedicated SQL Server boxes?

---

We run anti-virus software on ALL of our servers regardless of role.

quote:

---

> We have some varying views within our organization on what approach to

---

take

quote:

---

> to protecting the SQL Server.
> We do not have any file shares, or IIS or any unneeded services running on
> our dedicated SQL Server's -- thus I guess I do not see the merit of using
> anti-virus software on the SQL Server itself when the attach vectors are
> fairly minimized.
> Our SQL Servers are all internal, no DMZ, no external. The only major
> vulnerability would be internal threats (which are minimized by other
> internal controls, i.e. AV at the desktop, etc.).
> Is patch management, properly configured SQL Server security, and a good
> understanding of what services are open on the particular box enough to
> protect against 90-95% of the vulnerabilities that may exist?

---

Let's say you protect against 95% of all virus vulnerabilities, that still
leaves a 5% exposure. I understand the points you are making, however if one
of my servers were compromised, and I had to make an explanation to
management -- I would not be comfortable in saying that I took most steps in
protecting these servers but not all.
Steve|||> "Aaron Vance" <thisisnttheemailyourlookingfor@.nospam.com> wrote in message

quote:

---

> news:u$mL3kF4DHA.3576@.TK2MSFTNGP11.phx.gbl...
We run anti-virus software on ALL of our servers regardless of role.
[QUOTE]
> take
on[QUOTE]
using[QUOTE]
>

---

Let's say you protect against 95% of all virus vulnerabilities, that still
leaves a 5% exposure. I understand the points you are making, however if
one
of my servers were compromised, and I had to make an explanation to
management -- I would not be comfortable in saying that I took most steps
in
protecting these servers but not all.
Steve

Antivirus

I'm looking for a best practice for running antivirus
software on sql servers. Which files to exclude, what
can happen by scanning all files, etc.You'd want to exclude your data and log files. Additionally,
the following article has some guidelines:
INF: Consideration for a Virus Scanner on a Computer That Is
Running SQL Server
http://support.microsoft.com/?kbid=309422
-Sue
On Thu, 18 Mar 2004 10:55:42 -0800, "Thad Molling"
<anonymous@.discussions.microsoft.com> wrote:

>I'm looking for a best practice for running antivirus
>software on sql servers. Which files to exclude, what
>can happen by scanning all files, etc.|||Add don't run it at all on a cluster. Anti-virus can interfere with the
ability of the cluster service to shift disk resources from node to node.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:r9ak50tjjrgb0alt9qa2ali45bk2ame7ia@.
4ax.com...
> You'd want to exclude your data and log files. Additionally,
> the following article has some guidelines:
> INF: Consideration for a Virus Scanner on a Computer That Is
> Running SQL Server
> http://support.microsoft.com/?kbid=309422
> -Sue
> On Thu, 18 Mar 2004 10:55:42 -0800, "Thad Molling"
> <anonymous@.discussions.microsoft.com> wrote:
>
>