Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1521
  • 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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