tag:support.appharbor.com,2010-11-23:/discussions/problems/91139-remote-connection-to-sql-server-database-using-management-studioAppHarbor: Discussion 2017-06-29T23:46:12Ztag:support.appharbor.com,2010-11-23:Comment/428217632017-06-21T18:16:02Z2017-06-21T18:22:52ZRemote connection to SQL Server database using Management Studio<div><p>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.</p>
<p>I found that all I do is in code and I don't use the builder in Management Studio plus, the installation <strong>is huge</strong> (for us that use SSD's all space we can save is a must), so <strong>I prefer to work with <a href="https://www.heidisql.com/">HeidiSQL</a></strong> as not only connect to my MS SQL instances but also to MariaDB, MySql and even Postgres instances.</p>
<p>first of all, let's create a new MS SQL for free in your application and go to the SQL Server credentials</p>
<p><a href="http://s6.postimg.org/vfovfi4kh/screenshot_397.png"><img src="http://s6.postimg.org/vfovfi4kh/screenshot_397.png" alt=""></a></p>
<p>then, with those credentials, in HeidiSQL you can simply setup the DB as</p>
<p><a href="http://s6.postimg.org/ipkn2ewm9/screenshot_399.png"><img src="http://s6.postimg.org/ipkn2ewm9/screenshot_399.png" alt=""></a></p>
<p>and soon you save and connect, you get access to the database:</p>
<p><a href="http://s6.postimg.org/p4jnz33c1/screenshot_400.png"><img src="http://s6.postimg.org/p4jnz33c1/screenshot_400.png" alt=""></a></p>
<p>I hope it helps.</p></div>balexandretag:support.appharbor.com,2010-11-23:Comment/428217632017-06-21T18:26:12Z2017-06-21T18:26:12ZRemote connection to SQL Server database using Management Studio<div><p>Hi,</p>
<p>Thanks for you reply.</p>
<p>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.</p>
<p>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.</p>
<p>Mike</p></div>MECresseytag:support.appharbor.com,2010-11-23:Comment/428217632017-06-21T19:00:27Z2017-06-21T19:00:27ZRemote connection to SQL Server database using Management Studio<div><p>you can do so much more than running scripts :)</p>
<p>but yes, just select the database, and click that <strong>Query</strong> 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)</p></div>balexandretag:support.appharbor.com,2010-11-23:Comment/428217632017-06-24T00:11:54Z2017-06-24T00:11:54ZRemote connection to SQL Server database using Management Studio<div><p>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.</p>
<p>Thanks.</p>
<p>Mike</p></div>MECresseytag:support.appharbor.com,2010-11-23:Comment/428217632017-06-24T12:14:22Z2017-06-24T12:14:22ZRemote connection to SQL Server database using Management Studio<div><p>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.</p></div>MECresseytag:support.appharbor.com,2010-11-23:Comment/428217632017-06-29T04:22:07Z2017-06-29T04:22:07ZRemote connection to SQL Server database using Management Studio<div><p>Hi Mike,</p>
<p>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.</p>
<p>Best,<br>
Rune</p></div>runetag:support.appharbor.com,2010-11-23:Comment/428217632017-06-29T12:25:21Z2017-06-29T12:25:21ZRemote connection to SQL Server database using Management Studio<div><p>Hi Rune - I just loosened up my firewall restrictions temporarily to make this work.</p>
<p>Mike</p></div>MECresseytag:support.appharbor.com,2010-11-23:Comment/428217632017-06-29T23:46:09Z2017-06-29T23:46:09ZRemote connection to SQL Server database using Management Studio<div><p>Hi Mike,</p>
<p>Ok great, thanks for the heads up!</p>
<p>Best,<br>
Rune</p></div>rune