Solved

How to configure connection strings

Posted on 2008-06-23
6
1,473 Views
Last Modified: 2010-04-21
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
Comment
Question by:deNZity
  • 3
  • 2
6 Comments
 
LVL 5

Expert Comment

by:JuckMan
Comment Utility
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
 

Author Comment

by:deNZity
Comment Utility
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
 
LVL 13

Expert Comment

by:sm394
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:deNZity
Comment Utility
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
 
LVL 5

Accepted Solution

by:
JuckMan earned 500 total points
Comment Utility
0
 

Author Closing Comment

by:deNZity
Comment Utility
cheers
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now