How to connect to SQL Server from remote computer where computer A is able to connect while computer B is notHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?How do I UPDATE from a SELECT in SQL Server?Unable to connect to SQL Server instance remotelyHow do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual MachineHow to Delete using INNER JOIN with SQL Server?Check client connection to SQL Server 2008 ExpressCan't connect to SQL Server remotely
How to make a language evolve quickly?
How did Thanos not realise this had happened at the end of Endgame?
Why in a Ethernet LAN, a packet sniffer can obtain all packets sent over the LAN?
c++ what does , means after if
Why didn't Aeroflot Flight 1492 dump its fuel first?
Why was castling bad for white in this game, and engine strongly prefered trading queens?
use the oversamplling followed by '' decimation method ''to increasee the ADC resolution and not normal averaging
Create a list of all possible Boolean configurations of three constraints
Why does getw return -1 when trying to read a character?
Why does the Earth follow an elliptical trajectory rather than a parabolic one?
What to do if SUS scores contradict qualitative feedback?
Usefulness of complex chord names?
What is Plautus’s pun about frustum and frustrum?
Can I make ravioli dough with only all-purpose flour or do I NEED semolina flour?
What food production methods would allow a metropolis like New York to become self sufficient
Run script for 10 times until meets the condition, but break the loop if it meets the condition during iteration
How does Howard Stark know this?
Meaning of「〜てみたいと思います」
Find the cipher used
What does 松の木に吊るされた mean in this sentence?
"Right on the tip of my tongue" meaning?
Why doesn't Rocket Lab use a solid stage?
What stroke width Instagram is using for its icons and how to get same results?
Does the 500 feet falling cap apply per fall, or per turn?
How to connect to SQL Server from remote computer where computer A is able to connect while computer B is not
How to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?How do I UPDATE from a SELECT in SQL Server?Unable to connect to SQL Server instance remotelyHow do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual MachineHow to Delete using INNER JOIN with SQL Server?Check client connection to SQL Server 2008 ExpressCan't connect to SQL Server remotely
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
There are 3 computers on LAN say server, A and B. A connects to the server with no issues through a client application while B does not. The server is configured properly with remote connections enabled, port open and firewall configurations too. How to troubleshoot computer B to access server? Ping works from B to server.
Tried using ip address and server name, installed ssms and tried to connect to server. But B doesn't connect to the server. What might be wrong?
sql-server connection edited Mar 23 at 11:35
marc_s
589k13111281276
asked Mar 23 at 11:31
user1994366user1994366
1314
add a comment |
There are 3 computers on LAN say server, A and B. A connects to the server with no issues through a client application while B does not. The server is configured properly with remote connections enabled, port open and firewall configurations too. How to troubleshoot computer B to access server? Ping works from B to server.
Tried using ip address and server name, installed ssms and tried to connect to server. But B doesn't connect to the server. What might be wrong?
sql-server connection edited Mar 23 at 11:35
marc_s
589k13111281276
asked Mar 23 at 11:31
user1994366user1994366
1314
1
Verify connectivity to the port using TELNET or PowerShell. Powershell example:powershell -Command echo ((new-object Net.Sockets.TcpClient).Client.Connect('YourServerNameOrIpAddress', 1433)) 'success'. If the command fails, the most likely cause is the port is blocked from the problem client.
– Dan Guzman
Mar 23 at 11:34
powershell command executed and returned "success"
– user1994366
Mar 23 at 12:02
Network connectivity looks good, then. Add the SQL Server error message to your question. There may be additional information in the SQL Server error log if due to a login failure.
– Dan Guzman
Mar 23 at 12:32
add a comment |
There are 3 computers on LAN say server, A and B. A connects to the server with no issues through a client application while B does not. The server is configured properly with remote connections enabled, port open and firewall configurations too. How to troubleshoot computer B to access server? Ping works from B to server.
Tried using ip address and server name, installed ssms and tried to connect to server. But B doesn't connect to the server. What might be wrong?
sql-server connection edited Mar 23 at 11:35
marc_s
589k13111281276
asked Mar 23 at 11:31
user1994366user1994366
1314
There are 3 computers on LAN say server, A and B. A connects to the server with no issues through a client application while B does not. The server is configured properly with remote connections enabled, port open and firewall configurations too. How to troubleshoot computer B to access server? Ping works from B to server.
Tried using ip address and server name, installed ssms and tried to connect to server. But B doesn't connect to the server. What might be wrong?
sql-server connection sql-server connection edited Mar 23 at 11:35
marc_s
589k13111281276
asked Mar 23 at 11:31
user1994366user1994366
1314
edited Mar 23 at 11:35
marc_s
589k13111281276
asked Mar 23 at 11:31
user1994366user1994366
1314
edited Mar 23 at 11:35
marc_s
589k13111281276
edited Mar 23 at 11:35
marc_s
589k13111281276
edited Mar 23 at 11:35
marc_s
589k13111281276
589k13111281276
asked Mar 23 at 11:31
user1994366user1994366
1314
asked Mar 23 at 11:31
user1994366user1994366
1314
asked Mar 23 at 11:31
user1994366user1994366
1314
1314
1
Verify connectivity to the port using TELNET or PowerShell. Powershell example:powershell -Command echo ((new-object Net.Sockets.TcpClient).Client.Connect('YourServerNameOrIpAddress', 1433)) 'success'. If the command fails, the most likely cause is the port is blocked from the problem client.
– Dan Guzman
Mar 23 at 11:34
powershell command executed and returned "success"
– user1994366
Mar 23 at 12:02
Network connectivity looks good, then. Add the SQL Server error message to your question. There may be additional information in the SQL Server error log if due to a login failure.
– Dan Guzman
Mar 23 at 12:32
add a comment |
1
Verify connectivity to the port using TELNET or PowerShell. Powershell example:powershell -Command echo ((new-object Net.Sockets.TcpClient).Client.Connect('YourServerNameOrIpAddress', 1433)) 'success'. If the command fails, the most likely cause is the port is blocked from the problem client.
– Dan Guzman
Mar 23 at 11:34
powershell command executed and returned "success"
– user1994366
Mar 23 at 12:02
Network connectivity looks good, then. Add the SQL Server error message to your question. There may be additional information in the SQL Server error log if due to a login failure.
– Dan Guzman
Mar 23 at 12:32
1
1
Verify connectivity to the port using TELNET or PowerShell. Powershell example:
powershell -Command echo ((new-object Net.Sockets.TcpClient).Client.Connect('YourServerNameOrIpAddress', 1433)) 'success'. If the command fails, the most likely cause is the port is blocked from the problem client.– Dan Guzman
Mar 23 at 11:34
Verify connectivity to the port using TELNET or PowerShell. Powershell example:
powershell -Command echo ((new-object Net.Sockets.TcpClient).Client.Connect('YourServerNameOrIpAddress', 1433)) 'success'. If the command fails, the most likely cause is the port is blocked from the problem client.– Dan Guzman
Mar 23 at 11:34
powershell command executed and returned "success"
– user1994366
Mar 23 at 12:02
powershell command executed and returned "success"
– user1994366
Mar 23 at 12:02
Network connectivity looks good, then. Add the SQL Server error message to your question. There may be additional information in the SQL Server error log if due to a login failure.
– Dan Guzman
Mar 23 at 12:32
Network connectivity looks good, then. Add the SQL Server error message to your question. There may be additional information in the SQL Server error log if due to a login failure.
– Dan Guzman
Mar 23 at 12:32
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%2f55313285%2fhow-to-connect-to-sql-server-from-remote-computer-where-computer-a-is-able-to-co%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.
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%2f55313285%2fhow-to-connect-to-sql-server-from-remote-computer-where-computer-a-is-able-to-co%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
1
Verify connectivity to the port using TELNET or PowerShell. Powershell example:
powershell -Command echo ((new-object Net.Sockets.TcpClient).Client.Connect('YourServerNameOrIpAddress', 1433)) 'success'. If the command fails, the most likely cause is the port is blocked from the problem client.– Dan Guzman
Mar 23 at 11:34
powershell command executed and returned "success"
– user1994366
Mar 23 at 12:02
Network connectivity looks good, then. Add the SQL Server error message to your question. There may be additional information in the SQL Server error log if due to a login failure.
– Dan Guzman
Mar 23 at 12:32