Hi!
Guys, Any webadmin tool to manage mssql databases and users like phpMyAdmin?
I'm looking for something similar like phpMyAdmin (Open Source), suggestions?
Thanks!
Hello,
As far as I'm aware there is no free phpMyAdmin for MsSQL.
There is myLittleAdmin but this is not free.
Thanks,
Trevor
Hi Trevor
Thanks for the recommendation, I found Adminer based in PHP and can connect via web for this databases: MySQL, MariaDB (Used the same connector of MySQL) SQLite3, SQLite2, PostgreSQL, Oracle (beta), MS SQL (beta) but works, Firebird (alpha), SimpleDB, MongoDB, Elasticsearch (beta), clickHouse (alpha) MariaDB (Used the same connector of MySql that can be find in https://www.adminer.org
So in my case for MySQL/MariaDB I use phpMyAdmin, and now for MS SQL 2016 in my case I'm now using adminer. But for security reason I run the SQL code as a sa for hide all databases in shows just the database of the owner logged in, the same on SQL managment Studio after runing this code:
USE MASTER
GO
DENY VIEW ANY DATABASE TO PUBLIC
GO
So, just sysadmin and database owners can see the databases.
I found some tips here:
So, Adminer can works as a SQL Web Admin Tool.
Thanks!
I forgot to say that Adminer is Open Source and is a Free Web Database Management in a single PHP file, working on PHP 5.x, PHP 7.x . https://www.adminer.org/
abarboza19,
How did you get adminer to work with mssql...I keep getting an error message that says "None of the supported PHP extensions (SQLSRV, MSSQL, PDO_DBLIB) are available."