?
Solved

How to configure connection strings

Posted on 2008-06-23
6
Medium Priority
?
1,485 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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 1500 total points
ID: 21862691
0
 

Author Closing Comment

by:deNZity
ID: 31470043
cheers
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

752 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