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
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
Comments