question

RabiaEin-1936 avatar image
0 Votes"
RabiaEin-1936 asked SeeyaXi-msft commented

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

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered SeeyaXi-msft commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I have enabled both wired and wireless connections in the port forwarding section of the modem settings.
When I enabled only one, the problem went away.
Thanks.138468-1.png


0 Votes 0 ·
1.png (23.8 KiB)

Hi @RabiaEin-1936,

Do you check any error message?
The error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG.

Best regards,
Seeya

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered RabiaEin-1936 commented

Hi @RabiaEin-1936,

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.