| |
| |
Can I access my MS-SQL database remotely?
| Reference Number: AA-00122 Views: 1438 Created: 2010-07-30 11:59 Last Updated: 2011-06-27 16:55 |
0 Rating/ 0 Voters
|
    |
Question
I would like to be able to connect to my MS-SQL database remotely,
perhaps using a 3rd party application or using Management Studio. Is
this possible?
Answer
Yes, it is possible for our Microsoft SQL 2008 databases. You will be able to connect remotely from any web script or Management Studio. Unfortunately it is not possible for our SQL 2005 database plans due to security reasons. Consider upgrading to SQL 2008 if you wish to have remote functionality. Alternatively, if you wish to make extensive changes to your SQL 2005 databases, another solution would be to use MyLittleBackup to create a
backup of the database that you can then restore locally to your own
server. After making the changes required, create a backup file locally
that you can then restore using MyLittleBackup.
You can access the MyLittleAdmin and MyLittleBackup SQL tools here: http://mssql.hosting.isx.net.nz
|
|
|
|