Crystal Reports - Linked Server Connection
We have SQL server 2012 and we connect another server which is on different domain using a Linked Server name-> 192.xx.xx.xx.
I can query and view the 192.xx.xx.xx data using SQL Server.
Now have a Crystal Report, using ODBC. If I try to connect to 192.xx.xx.xx (SQL authentication), it's not connecting.
Can someone please help...
sql-server sql-server-2008 linked-server
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
asked Apr 26 '17 at 18:50
user112359user112359
3315
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
We have SQL server 2012 and we connect another server which is on different domain using a Linked Server name-> 192.xx.xx.xx.
I can query and view the 192.xx.xx.xx data using SQL Server.
Now have a Crystal Report, using ODBC. If I try to connect to 192.xx.xx.xx (SQL authentication), it's not connecting.
Can someone please help...
sql-server sql-server-2008 linked-server
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
asked Apr 26 '17 at 18:50
user112359user112359
3315
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
We have SQL server 2012 and we connect another server which is on different domain using a Linked Server name-> 192.xx.xx.xx.
I can query and view the 192.xx.xx.xx data using SQL Server.
Now have a Crystal Report, using ODBC. If I try to connect to 192.xx.xx.xx (SQL authentication), it's not connecting.
Can someone please help...
sql-server sql-server-2008 linked-server
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
asked Apr 26 '17 at 18:50
user112359user112359
3315
We have SQL server 2012 and we connect another server which is on different domain using a Linked Server name-> 192.xx.xx.xx.
I can query and view the 192.xx.xx.xx data using SQL Server.
Now have a Crystal Report, using ODBC. If I try to connect to 192.xx.xx.xx (SQL authentication), it's not connecting.
Can someone please help...
sql-server sql-server-2008 linked-server
sql-server sql-server-2008 linked-server
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
asked Apr 26 '17 at 18:50
user112359user112359
3315
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
asked Apr 26 '17 at 18:50
user112359user112359
3315
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
edited Apr 26 '17 at 20:02
Erik Darling
21.1k1263103
21.1k1263103
asked Apr 26 '17 at 18:50
user112359user112359
3315
asked Apr 26 '17 at 18:50
user112359user112359
3315
asked Apr 26 '17 at 18:50
user112359user112359
3315
3315
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Are you configuring the ODBC connection to talk directly to the 192.x server? If so, this could easily be a firewall issue, especially since you're talking cross-domains.
It would be standard in situations like this to only poke a hole in the firewall for that one SQL server in your domain to talk to the SQL server in the other domain, by hard-coding the source and destination IPs.
Talk to your network team.
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f172075%2fcrystal-reports-linked-server-connection%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Are you configuring the ODBC connection to talk directly to the 192.x server? If so, this could easily be a firewall issue, especially since you're talking cross-domains.
It would be standard in situations like this to only poke a hole in the firewall for that one SQL server in your domain to talk to the SQL server in the other domain, by hard-coding the source and destination IPs.
Talk to your network team.
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
add a comment |
Are you configuring the ODBC connection to talk directly to the 192.x server? If so, this could easily be a firewall issue, especially since you're talking cross-domains.
It would be standard in situations like this to only poke a hole in the firewall for that one SQL server in your domain to talk to the SQL server in the other domain, by hard-coding the source and destination IPs.
Talk to your network team.
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
add a comment |
Are you configuring the ODBC connection to talk directly to the 192.x server? If so, this could easily be a firewall issue, especially since you're talking cross-domains.
It would be standard in situations like this to only poke a hole in the firewall for that one SQL server in your domain to talk to the SQL server in the other domain, by hard-coding the source and destination IPs.
Talk to your network team.
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
Are you configuring the ODBC connection to talk directly to the 192.x server? If so, this could easily be a firewall issue, especially since you're talking cross-domains.
It would be standard in situations like this to only poke a hole in the firewall for that one SQL server in your domain to talk to the SQL server in the other domain, by hard-coding the source and destination IPs.
Talk to your network team.
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
answered Apr 26 '17 at 20:10
BradCBradC
6,32563460
6,32563460
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f172075%2fcrystal-reports-linked-server-connection%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
