Any webadmin tool t...
 
Notifications
Clear all

Any webadmin tool to manage mssql databases and users like phpMyAdmin?

9 Posts
3 Users
1 Likes
5,138 Views
Posts: 19
Topic starter
(@abarboza19)
Active Member
Joined: 5 years ago

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!

8 Replies
Posts: 1456
Admin
(@trobinson)
Noble Member
Joined: 8 years ago

Hello,

As far as I'm aware there is no free phpMyAdmin for MsSQL.

There is myLittleAdmin but this is not free.

Thanks,

Trevor

Reply
Posts: 19
Topic starter
(@abarboza19)
Active Member
Joined: 5 years ago

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:

https://www.mssqltips.com/sqlservertip/2995/how-to-hide-sql-server-user-databases-in-sql-server-management-studio/

So, Adminer can works as a SQL Web Admin Tool.

Thanks!

Reply
Posts: 19
Topic starter
(@abarboza19)
Active Member
Joined: 5 years ago

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/

Reply
Posts: 3
(@metroman90210)
New Member
Joined: 4 years ago

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."

Reply
Page 1 / 2
Share: