Solved

How to configure connection strings

Posted on 2008-06-23
6
1,479 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
ID: 21852539
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
ID: 21853239
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
ID: 21853451
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:deNZity
ID: 21859729
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
ID: 21862691
0
 

Author Closing Comment

by:deNZity
ID: 31470043
cheers
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

790 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