As you know you can create a database with SQL Server using the SQL Server configuration manager and SQL Server Management Studio. You know this - just typing that to tell that I checked the whole internet but didn't find answer to my problem. Let's go back to question.
I installed servers - one with default instance (
MSSQLSERVER) and one with my own instance name. I want to configure that server so I can connect to it over the internet - from everywhere I am. I did some changes as I see on the internet - TCP Ports are enable and Named Pipes too. I set same ports on my server everywhere - to execute chance to be changed after restart (Many people say it - so I did it). OK good. When I open SQL Server Management Studio, I need to type in the Server name - here are three ways to do it - that is what I know:
Computer name\SQL server name
Local IP(given by the router)\SQL server name
This is what I need - network one: Typing:
IP Adress(check in internet on one of many websites that says your real IP that comes to router\SQL SERVER NAME
And my question is - why can I do first and 2nd connections, but in the 3rd one I get an error... The one that says there is no such a server. I did changes to router that allow ports on SQL Server and SQL Browser and nothing ... but everyone says i need to find port forwarding on router settings. I'm using Tenda W541R and I don't have such as "Port forwarding" but I have some kind of that - "Virtual Server" - I think that must be the same.
Thanks in advance !