First release of SQL Management Console

Finally, I decided to release the second .NET application I am developing: SQL Management Console, now. This version 0.1, which is still in beta phase, still has a lot of room for improvement. Use at your own risk.

Here are some of the screenshots of it:
1) Login screen


2) Main GUI with MSSQL 2005 in action

3) Main GUI with MySQL 5.0 in action

4) Object scripting

5) Dependency viewer

For this version, it will suport MSSQL 2000 & 2005, MySQL 5.0. I am planning to include PostgreSQL connector in the next version. The features include in this version are :

1. (IDE-wise) Open/Save/Drag-and-Drop file
2. (IDE-wise) query pane and result pane
3. (MS SQL 2000 & 2005) Object browser for system objects (Scalar function, Stored procedure, System table, Table function, Trigger, User table, View)
4. (MS SQL 2000 & 2005) Object browser for security (Users, Roles, Schemas)
5. (MS SQL 2000 & 2005) Object browser for constraints, columns, parameters (Columns, Keys, Constraints, Triggers, Indexes, Parameters)
6. (MS SQL 2000 & 2005) Dependencies viewer for objects (Scalar function, Stored procedure, System table, Table function, Trigger, User table, View)
7. (MS SQL 2000 & 2005) Object scripting for non-encrypted objects (Scalar function, Stored procedure, Table function, Trigger, View)
8. (MySQL 5.0) Object browser for system objects (Scalar function, Stored procedure, System table, Trigger, User table, View)
9. (MySQL 5.0) Object browser for security (Users, Privilege)
10. (MySQL 5.0) Object browser for constraints, columns (Columns, Keys, Triggers)
11. (MySQL 5.0) Object scripting for non-encrypted objects (Scalar function, Stored procedure, Trigger, View)

Since parts of the source code is came from MSDN, thus I think it's good to release it under Microsoft Public license (Ms-PL) to prevent any infringement, though the chance are very little.

Since I am not an expert on database, feel free to give to any constructive comment and recommendation. I will try to improve it.

You can get the source code at here and executable files at here.

Make remote connection for MS SQL Express 2005

When one of my company's client uses the application that tries to connect to MS SQL Express 2005 in the main server that resides in LAN, he keeps receiving this error message:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

After a thorough search using Google, I found the MS SQL Express, Evaluation and Developer editions only allow to local connection, be default.

By setting the steps (from MSDN, using "SQL Server Surface Area Configuration") to allow it to make remote connection from remote PC, it works fines for some of the PCs only, using connection string likes:

Data Source=[pc name]\SQLEXPRESS; database=[database name]; uid=[user name]; pwd=[user password]

, when there's only MS SQL Express 2005 resides on PC.

But those PCs which have both MS SQL 2000 & MS SQL Express 2005 and the default instance is MS SQL 2000, it still hits the error message when I try to connect to MS SQL Express 2005:

SQL Server does not exist or access denied.

If connect to MS SQL 2000 using the IP, it works fine again. So I found the root cause again. This time the solution is from connectionstrings.com. By giving the port number used by MS SQL Express 2005 to the connection string, it works and here are the steps:

1) Go to: All Programs>Microsoft SQL Server 2005>Configuration Tools>SQL Server Configuration Manager

2) Then under: SQL Server 2005 Network Configuration>Protocols for SQLEXPRESS

3) Double-click the "TCP/IP", under the "IP Addresses", find the "TCP Dynamic Ports".

4) Use the port number (I think port no. 1433 is used by default MS SQL instance) as part of the connection string likes:

Data Source=[pc name]\SQLEXPRESS, [port number] ; database=[database name =]; uid=[user name]; pwd=[user password]

5) Success!