Installing SQL Server 2005 Express

Here’s the guide to install the SQL Server Express Edition into your system. Firstly, grab the installation program from the ms msdn web site. The required programs are as follow: .Net Framework 2.0, SQL Server 2005 Express Ed., SQL Server Mgmt Studio Express and the MSXML 6.0.

1. install the dotnetfx.exe (MS .Net framework)
2. install the msxml6.msi (latest MS XML Parser)
3. run the SQLEXPR.exe installation (SQL Server Express Ed.)
4. run the SQLServer2005_SSMSEE.msi installation(SQL Management Studio Express)

If you are switching from SQL Server 2000 to SQL Server 2005, you need to transfer your SQL Server 2000 database to SQL Server 2005 by using the backup db and restore db function. After restoring the backup, you need to remap the user login to the db. In this case, there may be some existing login for the table. In order to remove it, you need to remove the login user schema, then only the user in security.

For J2EE database connection, the TCP/IP protocol need to be enabled in the SQL Server Configurations Manager. Under Network Configurations, double click on the TCP/IP protocol, enable the protocol as well as the ip address. In the IP address portion, you can choose to open your LAN IP, localhost or both. Another portion is the TCP port, the port number that J2EE used to establish connection. Mine is defaulted at 3408. FYI, the defined port number for SQL Server is 1433. I wonder the port number may be vary because i installed the SQL Express on top of SQL Server 2000. Make sure there's no port conflict. Finally, change your port number, normally in .properties file to be the same as SQL Express TCP port.