Crystal Enterprise & new SQL/Slammer Worm

[dbew]

Hi everyone,

The company I work for has Crystal Enterprise 8.0 and the IT Department has informed me that there is a worm called the "SQL/Slammer Worm" which affects MS SQL Server 7.0.

I was wondering if Crystal Enterprise is susceptible to this worm and what do I need to do to protect it?

Thanks so much for your help.
dbew

 

[rhinok]

Crystal Enterprise itself will not be directly affected by the Worm, however, your network connectivity may be adversely affected if your network is infected. Your best bet is to upgrade all machines with SQL Server or MSDE to use Service Pack 3. This means your desktop machines, too. In the meantime, you can disable a specific port used by the worm.

Check out the following links:

http://vil.nai.com/vil/content/v_99992.htm

http://www.microsoft.com/downloads/...537-A2B6-4CB265B80766&displaylang=en#filelist

 

[dbew]

Hi rhinok,

Thanks for replying and providing the links above! Just wanted to know, however, does Cystal Enterprise utilize Microsoft SQL Server 7.0? If not, then I probably do not need to worry about the worm and applying the service pack. Correct?

Thanks again,
dbew

 

[lyanch]

It depends on your setup of Enterprise. You may be using SQL server as Enterprise's internal DB. I believe it is the default on install (been toooooo long I don't remember).

Lisa

 

[dbew]

Hi Lisa,

I wasn't responsible for setting up Crystal Enterprise and the person who was is not here. Can you please let me know if there's a simple way for me to check whether I may be using SQL server for my Crystal Enterprise?

From the server terminal, I choose START -> Programs and I don't see MS SQL server. If I had it, should I be seeing it there?

Thanks,
dbew

 

[lyanch]

In the CMC select settings and then the properties tab. There is a line called database. The type etc of database you are using should be displayed.

Lisa

 

[dbew]

Thanks again, Lisa.

I checked Crystal Management Console and this is what it has:

Database Name: crystal;ce8;microsoft sql server;07.00.0623

I guess I am using MS SQL Server 7.0

 

[kuo]

Hi.

I am trying to pass a date filed from my web page to crystal report, in the form field user type 1/13/2002, crystal report doesn't reconize it, how to pass it.