dcsimg

Troubleshooting Reports


Download the authoritative guide: Data Center Guide: Optimizing Your Data Center Strategy

Download the authoritative guide: Cloud Computing: Using the Cloud for Competitive Advantage

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.

This article was originally published on Mar 9, 2000
Page 1 of 1

Thanks for your registration, follow us on our social networks to keep up-to-date