I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error
Justin Song
SQL Express does not allow access to data sources not on the local machine. You will need to point to local data in your report.|||I'm new user of Reporting Services. I'm trying use Samples (AdventureWorks) and can't use it because this error. How do I point to local data in this samples? I create a Data Source named AdventureWorks with this string:
data source="(local)";persist security info=False;initial catalog=AdventureWorks
but is not working...
|||I've seen this problem before. The way I solved it previously was to update the connectionstring from an old-style ADO format to the new SQL 2005 format.
Old:
data source=(local);persist security info=False;initial catalog=AdventureWorks
New:
Server=(local); Database=AdventureWorks; Trusted_Connection=yes;
Hope this helps. Mark
No comments:
Post a Comment