-
1. Re: MS SQLServer2000 set up
lirox Jan 24, 2003 1:23 AM (in response to gmunde)follow me!
1:copy mssql-service.xml from jboss-3.0.4_tomcat-4.0.6\docs\examples\jca to jboss-3.0.4_tomcat-4.0.6\server\default\deploy
2:open it via notepad.
find following lines.
MSSQLDS
<config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver://localhost:1433;DatabaseName= YOURDATABASE!!!! </config-property>
<config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
<!--set these only if you want only default logins, not through JAAS-->
<config-property name="UserName" type="java.lang.String">USERNAME!!!!</config-property>
<config-property name="Password" type="java.lang.String">PASSWORD!!!!!</config-property>
3. change databaseName,UserName and Password!!!
4. copy msbase.jar,mssqlserver.jar,msutil.jar (download from M$)
to jboss-3.0.4_tomcat-4.0.6\server\default\deploy\lib
5. notice. default JndiName is "MSSQLDS"!
6. good luck &&& enjoy it ! -
2. Re: MS SQLServer2000 set up
gmunde Jan 24, 2003 6:38 AM (in response to gmunde)Thanks for your reply. I will follow the steps. Before I do, will the MS JDBC Driver work with JBoss running on Windows NT?