MDAC Hot patch

With regards to MS04-003 that just came out a few days ago,does one need to
install this MDAC update on SQL Servers servers and on
clients ? Can I just go ahead and apply it on our production systems without
testing ? If i install it only on the server, does it still leave me
vulnerable if I dont apply it on the clients ? Does this require a server
reboot ?> Can I just go ahead and apply it on our production systems without

quote:

---

> testing ?

---

LOL !!!!! Famous last words, if I've ever heard any.
Ideally, you would install the patch on clients and servers in your test
environment, run a battery of sanity tests just to make sure you don't miss
anything. I've witnessed many problems where the client and server had
provider versions out of sync, so you would be best off making sure both the
server and all of its clients have the same version / patch level applied.
NOTHING in your environment should change, ever, without testing first!
You're begging for disaster. Just because it worked for someone else,
doesn't mean it will work for you, unless they have the exact same
network/hardware/software config and are using the exact same applications
and the same users.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Thanks Aaron... That got me laughing too.. I guess I was serious when I
issued the post and really would have thought about applying without testing
it if I just got a reply from somone stating that its safe..
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:ul1BZ$F3DHA.556@.TK2MSFTNGP11.phx.gbl...

quote:

---

> LOL !!!!! Famous last words, if I've ever heard any.
> Ideally, you would install the patch on clients and servers in your test
> environment, run a battery of sanity tests just to make sure you don't

---

miss

quote:

---

> anything. I've witnessed many problems where the client and server had
> provider versions out of sync, so you would be best off making sure both

---

the

quote:

---

> server and all of its clients have the same version / patch level applied.
> NOTHING in your environment should change, ever, without testing first!
> You're begging for disaster. Just because it worked for someone else,
> doesn't mean it will work for you, unless they have the exact same
> network/hardware/software config and are using the exact same applications
> and the same users.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>

---

McAfee VirusScan vs MS SQL Server 2000?

Hello, all!
I wonder if anybody here has anything to say about my planning to
install the latest version of McAfee's anti-virus software, VirusScan,
on a Windows 2003 Standard server, running MS SQL Server 2000 (with the
latest patches).
I've read that some have reported problems with VirusScan when they're
running Banyan Vines, but this is strictly TCP/IP.
If you have any recommendations or warnings to give me about this, I
would really like to hear it.
Sincerely,
NiklasCheck the following article, while it does not mention McAfee specifically
it gives some general suggestions for antivirus software on SQL Servers:
http://support.microsoft.com/defaul...kb;en-us;309422
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Niklas" <npivic@.gmail.com> wrote in message
news:1109598431.924015.13650@.o13g2000cwo.googlegroups.com...
> Hello, all!
> I wonder if anybody here has anything to say about my planning to
> install the latest version of McAfee's anti-virus software, VirusScan,
> on a Windows 2003 Standard server, running MS SQL Server 2000 (with the
> latest patches).
> I've read that some have reported problems with VirusScan when they're
> running Banyan Vines, but this is strictly TCP/IP.
> If you have any recommendations or warnings to give me about this, I
> would really like to hear it.
> Sincerely,
>
> Niklas
>|||I just got out of the same fight with our server team and ended up having to
have a third-level tech representative conference in with us. Our concerns
where justified by the vendor.
Limit the Active Screening and Passive Scanning to exclude the data, log,
and database backup files.
If you are inside your LAN/WAN, you should not be runing inbound email nor
should you be using any network shares on a dedicated SQL Server
installation. In this case, there would be very little risk to virus attack
on the server.
Sincerely,
Anthony Thomas
"Simon Lidberg [MSFT]" <simonlid@.online.microsoft.com> wrote in message
news:utOgFidHFHA.904@.tk2msftngp13.phx.gbl...
Check the following article, while it does not mention McAfee specifically
it gives some general suggestions for antivirus software on SQL Servers:
http://support.microsoft.com/defaul...kb;en-us;309422
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Niklas" <npivic@.gmail.com> wrote in message
news:1109598431.924015.13650@.o13g2000cwo.googlegroups.com...
> Hello, all!
> I wonder if anybody here has anything to say about my planning to
> install the latest version of McAfee's anti-virus software, VirusScan,
> on a Windows 2003 Standard server, running MS SQL Server 2000 (with the
> latest patches).
> I've read that some have reported problems with VirusScan when they're
> running Banyan Vines, but this is strictly TCP/IP.
> If you have any recommendations or warnings to give me about this, I
> would really like to hear it.
> Sincerely,
>
> Niklas
>|||Thank you, both Simon and Anthony. You've provided me with good info,
and the URL to the recommendations from Microsoft hands me a solid base
for further internal discussions on this matter.
Sincerely,
Niklas

McAfee VirusScan vs MS SQL Server 2000?

Hello, all!
I wonder if anybody here has anything to say about my planning to
install the latest version of McAfee's anti-virus software, VirusScan,
on a Windows 2003 Standard server, running MS SQL Server 2000 (with the
latest patches).
I've read that some have reported problems with VirusScan when they're
running Banyan Vines, but this is strictly TCP/IP.
If you have any recommendations or warnings to give me about this, I
would really like to hear it.
Sincerely,
Niklas
Check the following article, while it does not mention McAfee specifically
it gives some general suggestions for antivirus software on SQL Servers:
http://support.microsoft.com/default...b;en-us;309422
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Niklas" <npivic@.gmail.com> wrote in message
news:1109598431.924015.13650@.o13g2000cwo.googlegro ups.com...
> Hello, all!
> I wonder if anybody here has anything to say about my planning to
> install the latest version of McAfee's anti-virus software, VirusScan,
> on a Windows 2003 Standard server, running MS SQL Server 2000 (with the
> latest patches).
> I've read that some have reported problems with VirusScan when they're
> running Banyan Vines, but this is strictly TCP/IP.
> If you have any recommendations or warnings to give me about this, I
> would really like to hear it.
> Sincerely,
>
> Niklas
>
|||I just got out of the same fight with our server team and ended up having to
have a third-level tech representative conference in with us. Our concerns
where justified by the vendor.
Limit the Active Screening and Passive Scanning to exclude the data, log,
and database backup files.
If you are inside your LAN/WAN, you should not be runing inbound email nor
should you be using any network shares on a dedicated SQL Server
installation. In this case, there would be very little risk to virus attack
on the server.
Sincerely,
Anthony Thomas

"Simon Lidberg [MSFT]" <simonlid@.online.microsoft.com> wrote in message
news:utOgFidHFHA.904@.tk2msftngp13.phx.gbl...
Check the following article, while it does not mention McAfee specifically
it gives some general suggestions for antivirus software on SQL Servers:
http://support.microsoft.com/default...b;en-us;309422
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Niklas" <npivic@.gmail.com> wrote in message
news:1109598431.924015.13650@.o13g2000cwo.googlegro ups.com...
> Hello, all!
> I wonder if anybody here has anything to say about my planning to
> install the latest version of McAfee's anti-virus software, VirusScan,
> on a Windows 2003 Standard server, running MS SQL Server 2000 (with the
> latest patches).
> I've read that some have reported problems with VirusScan when they're
> running Banyan Vines, but this is strictly TCP/IP.
> If you have any recommendations or warnings to give me about this, I
> would really like to hear it.
> Sincerely,
>
> Niklas
>
|||Thank you, both Simon and Anthony. You've provided me with good info,
and the URL to the recommendations from Microsoft hands me a solid base
for further internal discussions on this matter.
Sincerely,
Niklas
sql