'Invalid object name' error in SSRS report
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 edited Nov 13 '18 at 2:55
aduguid
2,13661031
asked Nov 13 '18 at 0:35
User27User27
175114
add a comment |
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 edited Nov 13 '18 at 2:55
aduguid
2,13661031
asked Nov 13 '18 at 0:35
User27User27
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 forDataSet3run 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
add a comment |
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 edited Nov 13 '18 at 2:55
aduguid
2,13661031
asked Nov 13 '18 at 0:35
User27User27
175114
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 sql-server reporting-services ssrs-2008 edited Nov 13 '18 at 2:55
aduguid
2,13661031
asked Nov 13 '18 at 0:35
User27User27
175114
edited Nov 13 '18 at 2:55
aduguid
2,13661031
asked Nov 13 '18 at 0:35
User27User27
175114
edited Nov 13 '18 at 2:55
aduguid
2,13661031
edited Nov 13 '18 at 2:55
aduguid
2,13661031
edited Nov 13 '18 at 2:55
aduguid
2,13661031
2,13661031
asked Nov 13 '18 at 0:35
User27User27
175114
asked Nov 13 '18 at 0:35
User27User27
175114
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 forDataSet3run 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
add a comment |
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 forDataSet3run 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
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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
DataSet3run 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