'Invalid object name' error in SSRS report












0














I am getting Invalid object name Clients error in my SSRS reports.
I have 2 reports connected to separate db. Both the db are same, first one works but not another one.



Error is:




An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet3'. (rsErrorExecutingCommand)
Invalid object name 'Clients'.











share|improve this question
























  • Somewhere along the way you have made a mistake - but no one can really tell you where it is from the information you have provided. You have to debug the situation, starting the verifying that the datasource does indeed point to the correct database, and that your report has permissions to access it. And then check that the query is in fact referencing real tables from the connected database...
    – Dale Burrell
    Nov 13 '18 at 1:00










  • Does the query for DataSet3 run in SSMS?
    – aduguid
    Nov 13 '18 at 2:55










  • solved! stupid mistake, I was not able to connect to db properly. added correct connection string and solved the issue.
    – User27
    Nov 13 '18 at 5:06
















0














I am getting Invalid object name Clients error in my SSRS reports.
I have 2 reports connected to separate db. Both the db are same, first one works but not another one.



Error is:




An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet3'. (rsErrorExecutingCommand)
Invalid object name 'Clients'.











share|improve this question
























  • Somewhere along the way you have made a mistake - but no one can really tell you where it is from the information you have provided. You have to debug the situation, starting the verifying that the datasource does indeed point to the correct database, and that your report has permissions to access it. And then check that the query is in fact referencing real tables from the connected database...
    – Dale Burrell
    Nov 13 '18 at 1:00










  • Does the query for DataSet3 run in SSMS?
    – aduguid
    Nov 13 '18 at 2:55










  • solved! stupid mistake, I was not able to connect to db properly. added correct connection string and solved the issue.
    – User27
    Nov 13 '18 at 5:06














0












0








0







I am getting Invalid object name Clients error in my SSRS reports.
I have 2 reports connected to separate db. Both the db are same, first one works but not another one.



Error is:




An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet3'. (rsErrorExecutingCommand)
Invalid object name 'Clients'.











share|improve this question















I am getting Invalid object name Clients error in my SSRS reports.
I have 2 reports connected to separate db. Both the db are same, first one works but not another one.



Error is:




An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet3'. (rsErrorExecutingCommand)
Invalid object name 'Clients'.








sql-server reporting-services ssrs-2008






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 13 '18 at 2:55









aduguid

2,13661031




2,13661031










asked Nov 13 '18 at 0:35









User27User27

175114




175114












  • Somewhere along the way you have made a mistake - but no one can really tell you where it is from the information you have provided. You have to debug the situation, starting the verifying that the datasource does indeed point to the correct database, and that your report has permissions to access it. And then check that the query is in fact referencing real tables from the connected database...
    – Dale Burrell
    Nov 13 '18 at 1:00










  • Does the query for DataSet3 run in SSMS?
    – aduguid
    Nov 13 '18 at 2:55










  • solved! stupid mistake, I was not able to connect to db properly. added correct connection string and solved the issue.
    – User27
    Nov 13 '18 at 5:06


















  • Somewhere along the way you have made a mistake - but no one can really tell you where it is from the information you have provided. You have to debug the situation, starting the verifying that the datasource does indeed point to the correct database, and that your report has permissions to access it. And then check that the query is in fact referencing real tables from the connected database...
    – Dale Burrell
    Nov 13 '18 at 1:00










  • Does the query for DataSet3 run in SSMS?
    – aduguid
    Nov 13 '18 at 2:55










  • solved! stupid mistake, I was not able to connect to db properly. added correct connection string and solved the issue.
    – User27
    Nov 13 '18 at 5:06
















Somewhere along the way you have made a mistake - but no one can really tell you where it is from the information you have provided. You have to debug the situation, starting the verifying that the datasource does indeed point to the correct database, and that your report has permissions to access it. And then check that the query is in fact referencing real tables from the connected database...
– Dale Burrell
Nov 13 '18 at 1:00




Somewhere along the way you have made a mistake - but no one can really tell you where it is from the information you have provided. You have to debug the situation, starting the verifying that the datasource does indeed point to the correct database, and that your report has permissions to access it. And then check that the query is in fact referencing real tables from the connected database...
– Dale Burrell
Nov 13 '18 at 1:00












Does the query for DataSet3 run in SSMS?
– aduguid
Nov 13 '18 at 2:55




Does the query for DataSet3 run in SSMS?
– aduguid
Nov 13 '18 at 2:55












solved! stupid mistake, I was not able to connect to db properly. added correct connection string and solved the issue.
– User27
Nov 13 '18 at 5:06




solved! stupid mistake, I was not able to connect to db properly. added correct connection string and solved the issue.
– User27
Nov 13 '18 at 5:06












0






active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272110%2finvalid-object-name-error-in-ssrs-report%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272110%2finvalid-object-name-error-in-ssrs-report%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







這個網誌中的熱門文章

Post-Redirect-Get with Spring WebFlux and Thymeleaf

Xamarin.form Move up view when keyboard appear

JBPM : POST request for execute process go wrong