Guys, Any webadmin tool to manage mssql databases and users like phpMyAdmin?
I’m looking for something similar like phpMyAdmin (Open Source), suggestions?
As far as I’m aware there is no free phpMyAdmin for MsSQL.
There is myLittleAdmin but this is not free.
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:
DENY VIEW ANY DATABASE TO PUBLIC
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.
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/
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.”
What you have to do is add the extensions in the ext folder of PHP installation, in my case PHP 7.0 and in my case required by adminer (php_pdo_sqlsrv_7_nts_x64.dll and php_sqlsrv_7_nts_x64.dll)Non-Thread Safe version (NTS) in my case as I’m using PHP as CGI binary otherwise you need the Thread Safe version (TS) but the must common way using the PHP requests as CGI binaries, then go with the (NTS), also according a 64 bits OS that must have to use nowadays, 32 bits OS are deprecated. Browse in internet and add to the EXT folder and activate the extensions by the config file or directly in the PHP Manager on IIS.
Also there is a new way to add mssql connnection support for PHP Apps here:
From Costa Rica!
Thanks for your response. Unfortunately, adminer is on a shared webhost that I don’t control so adding the extensions as you mention will not be possible. The webhost I am using (free) has the ability for me to enter queries but in many cases that is not going to work for me. I will have to look for other options.
I think the problem is my free webhost that is not allowing access to the sql database from a third party application. I will try mylittleadmin, but I expect to get the same result. Thanks again for your response.
- Views4827 times
- Answers8 answers