Help with SQL Server object, please don't bump!

[MikeB]

I am a little new to SQL. I have a website and I want to be able to connect with a database.

I already created an sql database on my server. I don't understand why it is not connecting.

I have a plan with hostica.com as my hosting provider.

When the SQL objects asks for the server name or host I enter
what the database shows on the cpanel of my website:

mysql1.hostica.com

Is that the actual host or is it just a localhost.

I am confused, can someone provide me with an example or a good explaination.

Thanks.

[Corentin]

Most SQL servers don't accept connections from outside. You'll have to run the program on the same computer, or in local network.

This is for security reasons.

[DJFuego]

You can configure the sql server to accept connections from your external IP so technically it is possible. The Sql manager on the server may have a web interface so you can configure this access. Or you can configure it with sql management studio.

[Jeff]

Yes just ask your host to allow remote connections.

Most will say no due to security reasons but if you run your own server they can help you turn it on if you really want to.

[MikeB]

Thanks a lot! I was wondering what I was doing wrong.