SharePoint Report Error: Cannot create a connection to data source ‘dataSource1’.

2010-05-10 / SharePoint, SQL / 1 Comments

Problem:
You recieve the following error when running a report from report builder.

Report Execution error the report might not be vaild or the server could not process the data.
for more information about this error navigate to the report server on the local server machine, or enable remote errors
—-
Cannot create a connection to data source ‘dataSource1’.

An error has occurred during report processing.

 

Resolution
In my case the problem was the login that was used when running the report did not have access to the catalog and the sql server. I granted the correct access to the databases in sql manager and the user was able to run the report.

Read More

Delete Orphaned Distribution Points From SCCM Packages

2010-03-09 / Configuration Manager / 1 Comments

1. Backup the database.

2. Find the entries for the DP package share:

Select * from pkgservers where NALpath like ‘%\\Server%’
Select * from pkgstatus where pkgserver like ‘%\\Server%’
Select * from contentdpmap where serverpath like ‘%\\Server%’
Select * from DPinfo where servername like ‘%Server%’
3. Delete any entries from any of the above tables that point to the nonexistent share:

Delete from pkgservers where NALpath like ‘%COMPUTERNAME’ 
Delete from pkgstatus where pkgserver like ‘%Server%’
Delete from contentdpmap where serverpath like ‘%Server%’ 
Delete from DPinfo where servername like ‘%Server%’

Read More