Activities

July 2014
M T W T F S S
« Jun   Aug »
 123456
78910111213
14151617181920
21222324252627
28293031  

web-based MS SQL administration tool for MSSQL server 2012

While I’m setting up a Windows 2012 server for a small .Net project, I have a need of providing MSSQL server 2012 Express access to Developers. Following are the options normally a admin will do,

1. Create a normal user having Remote Desktop access and provide SQL user account.
2. Open Remote MSSQL server access on a different port. You may need to do some extra SQL server settings and firewall settings.
3. Providing a Web interface to access database remotely over SSL.

I do not want to go with 1 and 2 options since it may cause users/others to have unwanted information and may have security challenges. Because RDP connections are limited to offices IP and MySQL remote connections are not encrypted. Also firewall has to modify. If somebody want to edit on a table , they would have Management Studio installed on their desktop.

This time, I go with a freeware software mylittleadmin.com. I uses it’s freeware version since my project is a small one 🙂

How do I install it.

a. Download the software from this link http://www.mylittleadmin.com/zip/mla_sql_3.8.zip and extract it to a weblocation like http://myaspx.com/mla/

b. Edit the file “config.xml” and add a server name entry for your Database server. My entry will look like this(I removed the sample entries from there,

<sqlservers>
<sqlserver address="MST-WEB01\SQLEXPRESS" name="MST_DBServer" />
</sqlservers>

You can get the server name from this screen,
MLA-Servername

c. Next you need to “publish” your MLA application in IIS8 server. See the screen below,

MLA-_1

There will not be any configuration changes required for setting this up. You can download my configuration files (config.xml and web.config) files here

d. Enable MSSQL server protocol to listen to TCP/IP or NamedPipe access.

Now you need to enable the TCP/IP protocol access and set the TCP port to 1433. Then you need to restart MSSQL service to make this effect.

MLA-_3

MLA_4

Once everything is set, you will see the UI as shown below,

MLA-_2

MLA-last

cheers

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>