Troubleshooting Reports

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.