Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Is there any webinterface for administrating MSSQL similar to phpMyAdmin (for MySQL)?

I want a self-service setup where developers can create a database through webinterface and upload/download backups of the database without local access.

I've considered phpMSAdmin, but it hasn't had a release since 2006 so I'm not sure its worth the effort of setting it up. If there is something else (free or not-so-free) that would be great.

My question is similar to this one posted 2 years ago, but no good webinterface was found back then. SQL Web Data Administrator seems interesting, but it lacks a few features - most notably creating new databases (also, not updated since 2007).

share|improve this question

3 Answers 3

up vote 2 down vote accepted

There is MyLittleAdmin that we use. I find it strange that it's not been mentioned here. We've used it for years and I think our developers find it works well for them. I think it's crazy that there's not a official web based tool like phpMyadmin for MSSQL. I don't want to give our developers access to our production SQL Servers so a web based solution is ideal for us.

share|improve this answer
    
Sir, Thank You! As you see my question was from almost 1,5 years agso, and it mentions that it was a re-post of a question from 2 years before that. I had given up and settled with Management Studio. –  Tedd Hansen Sep 7 '12 at 9:31

There's no default web interface like phpMyAdmin. Typically you wouldn't want to expose your Microsoft SQL Servers to the public net. You would normally connect via VPN then use SQL Server Management Studio to connect.

The web interfaces that you found will probably do the trick, but without providing access to some of the newer features. If you are just looking for basic functionality those will work just fine. The nice thing about SQL Server is that anything you can do in SSMS you can do in T/SQL so if the web interface you have doesn't provide functionality you can still manage and use those features using T/SQL.

share|improve this answer
2  
The exact same applies to MySQL - you don't want to expose 3306, and you can do everything in SQL commands. I can name several reasons why webinterface with proper login system is better than opening 1433 directly. But thats not the issue here, the server is protected behind FW+VPN anyway. What I want is a self-service webinterface, specifically for uploading/downloading backups and creating new DB's. phpMyAdmin is a perfect example. –  Tedd Hansen Jun 22 '11 at 7:10
1  
Btw! For those of us that had the pleasure of reinstalling customer servers after the MSSQL worms that roamed in the early 2k we NEVER expose MSSQL-ports to the net. ;) –  Tedd Hansen Jun 22 '11 at 7:12
1  
I try not to expose any management tools to be accessable via the net, including any sort of web interface. If I need to manage a server I VPN in. If VPN isn't an option I RDP to a server on the network and use SSMS from there. Microsoft is always adding features to SQL Server, keeping a 3rd party web tool up to date would be tough to say the least for a company. –  mrdenny Jun 22 '11 at 19:06

As mrdenny says, there is no default web interface for mssql. And I rather not use third party program that hasn't released update since more than 3 years... pretty dangerous if the security isn't improved.

As form me, I use RazorSQL for my database managing. It's a good tool, you just have to create a connection (ip, port, databasename, and so on...) And you can interact with your database, you can do almost anything (if you're connected as root), a very complete tool. But it's not as friendly as phpmyadmin, but still better (well, at least for me.)

Give it a try.

share|improve this answer
1  
But then I can just as well use Management Studio? I need a webinterface. –  Tedd Hansen Jun 22 '11 at 7:43
    
Using Web interface is good only if you work on the server intranet (at some peculiar time only!). If you want to work on you database with a security point of view, web interface is not really what you need. Also if I recall good (not use it everyday), but you can't access database with management studio when you not on the server intranet. But you can easily with razosql. As for web interface applet for database managing, once I used mylittleadmin. As far as I recall, was a good web interface. Try it, and see if it's what you were looking for. ;) –  Anarko_Bizounours Jun 22 '11 at 8:29
    
There is no good web interface apparently, thanks for the RazorSQL just installed and managed to get decent csv and xlsexport from MSSQL! –  anteatersa Dec 13 '11 at 16:42
    
good to know. ^^ –  Anarko_Bizounours Dec 15 '11 at 9:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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