I want to use a local SQL Server Db installed on my PC with an ASP.NET website that I will host with a hosting provider.
I know how to connect to the DB from my ASP.net code while I develop with Visual Studio on my PC (I have the name of the server) but I do not know what the name of my SQL Server will be once I want to access it from my code installed on the hosting provider. I guess that it is a matter of substituting the PC name with an IP address, but I do not know what that IP is or where to obtain it from.
Any help will be most welcome.
Thanks a lot in advance and regards.