dcsimg

Troubleshooting Reports

By ServerWatch Staff (Send Email)
Posted Mar 8, 2000


A.Stokes

There you are with a newly installed SMS site. You've got clients discovered and installed, you've looked at all the logs, and now you are ready to try out the canned reports for the Crystal Reports plug-in that comes with SMS.

There you are with a newly installed SMS site. You've got clients discovered and installed, you've looked at all the logs, and now you are ready to try out the canned reports for the Crystal Reports plug-in that comes with SMS.

If you are like most people, you've figured out that the report needs to be scheduled and you have entered all the necessary information. You've even tried several different accounts. (Here's where the "but" comes in...)  BUT, the report never runs and it gives you an error that says, "Cannot open SQL server".

Many people have run into this problem. The reports won't run no matter which account you use.

Here's the solution that many people have seen in the newsgroups:

Run the report using your sa or smsservice account, but don't enter a password.

The report should run just fine after that.

Page 1 of 1


Comment and Contribute

Your name/nickname

Your email

(Maximum characters: 1200). You have characters left.