WIRED - WIRELESS REMOTE CONNECTION TO SQL SERVER ON SAME NETWORK PROBLEM

Rbegn 101 Reputation points
2021-10-05T10:04:45.543+00:00

I can connect to a Sql Server Installed PC wirelessly from another PC on the same network.
But when I connect the PC with the server installed to the modem via cable, I cannot connect from the remote PC.
Note: Port forwarding has been done in the modem settings.
Can you help with this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,645 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.8K Reputation points MVP
    2021-10-05T21:53:58.49+00:00

    I'm not sure we can't, because we don't see your network setup. And it does sound more like a general network problem to me than an SQL Server problem.

    Also, you shared very little information. No error message. No details about the network.

    Can you access other resources on that other PC when you connect other cable? If so, what you do specify when you do that?

    What error message do you get?

    What does "SELECT @@version" report?

  2. Seeya Xi-MSFT 16,436 Reputation points
    2021-10-06T03:29:12.357+00:00

    Hi @Rbegn ,

    If it is the difference between wired and wireless, this should be a network problem.
    Here is a troubleshooting you can refer to: Troubleshoot connecting to the SQL Server Database Engine.

    Best regards,
    Seeya

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.