INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

HANDLE


PASSWORD
Remember Me
Forgot Password?

Come Join Us!

  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • Turn Off Ad Banners
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

E-mail*
Handle

Password
Verify P'word
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Member Feedback

"...This was the ONLY place that I could find information that I could use to resolve the problem. So thanks once again to member TomSark and the SQL forum!..."

Geography

Where in the world do Tek-Tips members come from?
dbew (MIS)
27 Jan 03 13:05
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
Check Out Our Whitepaper Library. Click Here.
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.

 
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close