1

I used a shared windows hosting for one of my customers. The hosting company does not provide remote access to databases (e.g connecting through Microsoft Sql management studio). How do you work with such servers? Do you also set a web based database manager for every website? (or perhaps this special company is too restricted?)

2
  • 1
    Blocking direct remote database access is pretty common. For Linux, most hosts allow you to ssh in and then access the database. Maybe there is some equivalent access mechanism for Windows available from your host? Sep 18, 2021 at 12:16
  • Plesk Onyx has firewall settings to allow remote access from specific IP addresses. I am not sure what your hosting provider is using but it might have equivalent settings.
    – Partho
    Sep 20, 2021 at 22:30

1 Answer 1

3

Its difficult to give a good answer without knowing more specifics, but -

Remote access to databases is usually disabled because its a security risk with limited upside. In the MySQL world it is common to provide access to PHPMyAdmin. I dont get involved with Windows much, but there are no doubt equivalent tools (eg https://sourceforge.net/projects/mammo/ - just from googling).

If you have a static IP address you may be able to request access directly from your hosting provider. You might also be able to enable some kind of port forwarding (in the Linux world a tunnel over SSH)

It may even be possible (but mind you secure it) to use something like https://github.com/ngharo/Random-PHP-Classes/blob/master/Telnet.class.php to create a telnet proxy using php.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.