[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1512
  • Last Modified:

How to configure connection strings

I have imported some rdl files into rs that use a different credential type than our current reports.I need to to change the connection string for the new reports to be the same as our current reports use.

this is the error msg I get.

A connection cannot be made to the database.
Set and test the connection string.


------------------------------
ADDITIONAL INFORMATION:

You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server. (Microsoft.ReportingServices.DataExtensions)
0
deNZity
Asked:
deNZity
  • 3
  • 2
1 Solution
 
JuckManCommented:
Here is a link that can help you set the connection strings
http://www.connectionstrings.com/?carrier=sqlserver2005
Based on your error message you are trying connect to the database using integrated authentication, where as the database is not supported to do.

Based on this error message, if you want to use integrated security ensure the windows/domain user Id running the sql report services has access to the database

hope this helps
0
 
deNZityAuthor Commented:
Thanks for the reply, where do I find the connection string so I can edit it?

I have looked in the report properties and the code view but cannot find connectstring tag or property.
0
 
sm394Commented:
in the data tab next to Layout and Preview  click on ... which is (edit selected dataset)  there you can change/edit the data source
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
deNZityAuthor Commented:
Thanks for the reply, I have already done that . the error msg I receive comes after I change the dataset to one we already use.

"You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server. (Microsoft.ReportingServices.DataExtensions)"
0
 
JuckManCommented:
0
 
deNZityAuthor Commented:
cheers
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now