Archived Support Site

This support site is archived. You can view the old support discussions but you cannot post new discussions.

Remote connection to SQL Server database using Management Studio

Edit

MECressey

21 Jun, 2017 05:32 PM

Hi,

Do you have a set of instructions for using Management Studio to connect to my SQL Server database at Appharbor? I am getting a network error when I try to connect - error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53. Do I need to configure some port or something on my computer to get this to work? I've searched the KB and seen others have had this problem but I can't seem to get the right answer.

Thanks.

Mike

1 Posted by balexandre on 21 Jun, 2017 06:16 PM

in direct answer to your question, I think it's because you need to enable TCP/IP connection in the management studio, some years back I had such issue... but nevertheless, continuing with what I currently do.

I found that all I do is in code and I don't use the builder in Management Studio plus, the installation is huge (for us that use SSD's all space we can save is a must), so I prefer to work with HeidiSQL as not only connect to my MS SQL instances but also to MariaDB, MySql and even Postgres instances.

first of all, let's create a new MS SQL for free in your application and go to the SQL Server credentials

then, with those credentials, in HeidiSQL you can simply setup the DB as

and soon you save and connect, you get access to the database:

I hope it helps.
- Edit
2 Posted by MECressey on 21 Jun, 2017 06:26 PM

Hi,

Thanks for you reply.

I have an AppHarbor SQL Server database that's been created already for me. I am trying to connect to it using SQL Server Management Studio using the credentials that AppHarbor provides. I already have Management Studio installed on my computer and use it to work with my local SQL Server databases. I need to run an SQL Script in the AppHarbor database and I need to check some things in the database as well, as my application is not working quite right.

I gather that you are recommending that I use HeidiSQL instead? I can certainly do this if it allows me to run SQL scripts and open tables.

Mike
- Edit
3 Posted by balexandre on 21 Jun, 2017 07:00 PM

you can do so much more than running scripts :)

but yes, just select the database, and click that Query tab, paste your script there and run (you can also run a script file directly, but fell free to download, install, connect and run through it, you will see how easy and so much lighter that HeidiSQL is in comparison to Management Studio)
- Edit
4 Posted by MECressey on 24 Jun, 2017 12:11 AM

Hi, I finally got around to following up on this. I installed HS and attempted to connect to the AppHarbor SS database and I'm getting an error there as well: SQL Error (17): DBNETLIB. Sql Server does not exist or access denied. So I'm wondering if there isn't something else going on here. Is there a way to submit a ticket to AppHarbor.

Thanks.

Mike
- Edit
5 Posted by MECressey on 24 Jun, 2017 12:14 PM

After lowering my Firewall settings on my router, I am able to connect using SQL Management Studio and HeidiSQL. I would like to enable the firewall just to allow for SQL Sever.
- Edit
Support Staff 6 Posted by rune on 29 Jun, 2017 04:22 AM

Hi Mike,

Ok so it sounds like you've figured this one out, but in case you want to limit your router's firewall and haven't done so already: You only need to open up port 1433 to access the SQL server instance -- how you configure that will depend on the router and software installed on it.

Best,
Rune
- Edit
rune closed this discussion on 29 Jun, 2017 04:22 AM.
MECressey re-opened this discussion on 29 Jun, 2017 12:25 PM
7 Posted by MECressey on 29 Jun, 2017 12:25 PM

Hi Rune - I just loosened up my firewall restrictions temporarily to make this work.

Mike
- Edit
Support Staff 8 Posted by rune on 29 Jun, 2017 11:46 PM

Hi Mike,

Ok great, thanks for the heads up!

Best,
Rune
- Edit
rune closed this discussion on 29 Jun, 2017 11:46 PM.