HC Support and SupermanInNY,
Thank you for the postings, I had an idea on how to resolve this issue, but wanted to see if anyone else had a solution.
SupermanInNY, I don’t think that your solutions would work in a shared hosting environment, because it would probably block anyone trying to access the server from a remote sql server client (enterprise manager, etc.) or ip address (website connecting from outside to our sql server).
The problem seems to be related to the sa user which is known as the admin user for ******* hackers.
Solutions I will try:
1. Create my own user on the sql server and set the users permissions to the same privileges as the admin (sa) user. This can probably be further locked down because HC does not seem to need all sa privileges (i.e. HC needs: create/delete user, create/delete database, backup/restore database, anything else?).
2. Lock down the sa user to only allow connections for sa on the local sql server (no remote access for sa), I believe this is the default setup when installing sql 2005.
3. Finally, update HC My Server :: Configure Database :: Configure MS-SQL for the new user create in step 1.
Is there any reason why this would not work?
If it works for mssql I will probably do the same for the root user in mysql.
Any input would be appreciated.