SMS: Insufficient Access Permissions Produce Generic Error Message When Running a Crystal Info Report (201718)

The information in this article applies to:

Microsoft Systems Management Server 2.0

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.

MORE INFORMATION

For additional information about potential errors running Systems Management Server reports, click the article number below to view the article in the Microsoft Knowledge Base:

244959 Error Message Refreshing Report in SMS Administrator Console

Modification Type:	Minor	Last Reviewed:	4/25/2006
Keywords:	kbBug KB201718