1. Download MS SQL 2008 Express from http://www.microsoft.com/express/sql/download/ 2. Install MS SQL 2008 Express 3. SQL Server Configuration Manager => Set IPAll => TCP port = 1433 4. SQL Server Management Studio => set security to mixed mode authentication => restart SQL Server http://www.hostmysite.com/support/vps/windows/mixedmode/ 5. Create login as you need 6. Use sqljdbc.jar as MS SQL JDBC Connection Driver <= It doesn't work 7. Go to Data Source Explorer 8. Create New data source -> choose SQL Server -> Choose driver Microsoft SQL Server 2000 Driver for JDBC 9. Jar list required msbase.jar, mssqlserver.jar, msutil,jar 10. Test connection 11. Create Seam web project -> choose data source which we just created