SMS: Insufficient Access Permissions Produce Generic Error Message When Running a Crystal Info Report
Article ID: 201718
Article Last Modified on 10/27/2006
APPLIES TO
- Microsoft Systems Management Server 2.0 Standard Edition
This article was previously published under Q201718
SYMPTOMS
When running a Crystal Info for SMS report from the Systems Management Server Administrator Console, the report fails to run, and you receive the following error message:
Cannot open SQL server
CAUSE
The user account being used to run the report does not have appropriate NTFS access permissions to the folder in which the report is stored.
WORKAROUND
Either grant appropriate access permissions to the account being used to run the report, or use an account with the appropriate permissions. The user account that is used to create and run reports needs to have at least read, write, and execute permissions on the CINFO folder and subfolders.
STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0.
Additional query words: prodsms
Keywords: kbbug KB201718