Go Daddy SQL Server 2005 Remote Connection

Question

Hi Guys,

Is it possible to connect to my remote database hosted at godaddy from locally from my PC?

And if yes how?

I tried the connection string provided to me but it didn't work.

Thanks

Answer 1

This is not really a programming question, and honestly depends on your plan and the hosting provider. I would contact GoDaddy for assistance.

Answer 2

Hi, i have the same question .have a hosting account in godaddy.Need the answer soon .Please help

Answer 3

I called GoDaddy support and confirmed they do not support remote connections through their hosted service.

Answer 4

Have had a GoDaddy account for just a couple of months, so this may be a new feature, but you CAN connect to it with Sql Server Management Studio if you choose to "Allow Direct Database Access" when you create it.

Seems like they host them on different servers...have had some problems using it, but I am by all means no SSMS-ninja ;-)

Managed to see all the databases that where hosted on the server though...don't now if that's a sign of lax security or something else completely.

Answer 5

GoDaddy does not provide external access (yes, its a PITA)

Answer 6

You can connect directly. This is a recently added feature.

See the following help articles:

Why Connect Remotely to Shared Hosting Databases
Connecting Remotely to Shared Hosting Databases
Setting up a SQL Server Database on Your Hosting Account

Hope this helps!

Answer 7

I'm on phone with GoDaddy right now, and they just started offering this service on the databases that are hosted on IIS7 servers. If your database is on IIS6, you cannot access remotely.

Answer 8

YES you can. Using SQLYog and a php hosting. SQLYog has a php file you have to upload to your hosting. This file provides the "bridge" to connect to your databases in GoDaddy. I have been using this for at least 4 years now (it´s time to share it with the crowds)

Answer 9

When creating your database you MUST select the "Direct Acccess" radio button to turn on the option the will enable you to connect using Mgmt Studio. Apparently if you don't do this at time of creation you cannot enable it later and must drop and recreate the db.

Answer 10

i had no option for direct access, but when i called them they updated me to "grid hosting plan" which supposedly will allow me to select direct access option. I guess grid hosting is a newer option, same price and stuff as whatever delux shared hosting plan i had before, so the update was free... caused a bunch of lame issues though that i had to correct in a whole bunch of code on multiple domain names. I mainly recommend DROPPING GO DADDY! :-)