Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to access a SQL Server database housed on a ISP. Normally one would simply install an express version of SQL server and use the Management Studio therein. Yeah, not me!

Are there any third party tools that will allow me to manage my database? Lightweight ones would be the best but I'm not that picky. :)

share|improve this question

closed as off-topic by masegaloeh, mdpc, 84104, Katherine Villyard, Ward Apr 21 '15 at 4:33

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

Why don't you want to use SQL Server Management Studio Express? – joeqwerty Oct 2 '09 at 18:19
Because I like options. :) – Craig Oct 2 '09 at 22:41
Can you discuss what you've found lacking or otherwise undesirable about SSMS? – mfinni Jun 18 '10 at 19:32
up vote 3 down vote accepted

If your ISP blocks incoming requests to SQL ports and you can't RDP into the box then you're relinquished to something they provide, which is probably going to be one of the crappy web front-ends that are out there.

That said, and if you insist on not using SSMS Express, have a look at

  • Query Express (as recommended by Scott Hanselman! "Wow, a Query Analyzer look-alike that doesn't suck, doesn't need an install, is wicked fast, is free and is only 100k. Pinch me, I'm dreaming.")
  • SQuirreL SQL Client (maybe not ideal if you're not keen on talking to SQL Server via jdbc, though)
share|improve this answer
Yeah but ADOQuery will actually give you editability of tables you query and its a smaller executable. I tried Query Express and it was all read-only. – djangofan Jun 21 '10 at 15:53

If you are not picky, why not use Management Studio? Its free and it works....

share|improve this answer

I'd be very worried if you can connect to the SQL Server instance remotely. That is, without using Citrix, say, or their web UI.

If you do remote in, then you'll have SSMS somewhere (or SQuirrel etc)

Seriously: either use what the ISP provides or change ISP...

share|improve this answer

try aqua data studio from it's jdbc based and talks to SQL server but also to Oracle, Mysql, Posgres, etc...

share|improve this answer

Personally, I'd still be using SSMS... but if you really don't want to, apart from the other good alternatives listed, you could consider a web-based app like SQL Web Administrator.

share|improve this answer

We have used SQL Developer for certain edge case functionality (like exporting all of the data from a table to a .sql file with all the records as insert statements) but it works well as a standard SQL management application as well.

share|improve this answer

There is a program called ADOQuery that is a great way to get quick connectivity before you have installed SQL Server Management Studio. It only weights 1KB. The smallest that you'll find.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.