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

Tek-Tips Forums is Member Supported. Click Here to donate.

rhinok (TechnicalUser)

27 Jan 03 14:58

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/details.aspx?FamilyId=9032F608-160A-4537-A2B6-4CB265B80766&displaylang=en#filelist

dbew (MIS)

27 Jan 03 16:19

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 (Programmer)

27 Jan 03 16:50

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 (MIS)

27 Jan 03 16:59

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 (Programmer)

27 Jan 03 17:58

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 (MIS)

27 Jan 03 18:23

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 (Programmer)

28 Jan 03 13:09

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.

Start A New Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Promoting, selling, recruiting and student posting
are not allowed in the forums.
Posting Policies

LINK TO THIS FORUM!

(Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum)

TITLE: Business Objects:Crystal Enterprise Forum at Tek-Tips

URL: http://www.tek-tips.com/threadminder.cfm?pid=782

DESCRIPTION: Business Objects:Crystal Enterprise technical support forum and mutual help system for computer professionals. Selling and recruiting forbidden.

Back To Forum

Back To Business Objects:Crystal Enterprise

Member Login

Navigation

Come Join Us!

Partner With Us!

Member Feedback

Geography

Crystal Enterprise & new SQL/Slammer Worm

Start A New Thread

Posting in the Tek-Tips forums is a member-only feature.

Promoting, selling, recruiting and student postingare not allowed in the forums.Posting Policies

LINK TO THIS FORUM!

Back To Forum

Join Tek-Tips® Today!

Promoting, selling, recruiting and student posting
are not allowed in the forums.
Posting Policies

Join Tek-Tips^® Today!