I have not tried with sqljdbc4.jar but sqljdbc.jar worked fine for me. I have specified userid and passoword as separate properties. <property name="connection.username">xxxx</property>
<property name="connection.password">xxxx</property> I had to change the connection URL to the format below for it to work. <property name="connection.url">jdbc:sqlserver://127.0.0.1:1433;databaseName=openmeetings;autoReconnect=true;useUnicode=true;createDatabaseIfNotExist=true;characterEncoding=utf-8</property> Hope this helps. On Tue, Dec 29, 2009 at 12:03 PM, HMiles <[email protected]> wrote: > I have a couple of questions about the configuration for a mssql > database. > Can you tell me what I am doing wrong? > > 1. Does anyone know where I can get the mssql-jdbc.jar from.. > 2. Will the sqljdbc4.jar from microsoft work with openmeetings? > 3. Does anyone have the syntax that will make it auto create the > database is in MYSQL configuration? > I taken the following steps and I am still unable to connect to my MS > SQL SERVER: > > I copied the sqljdbc4.jar into the red5\webapps\openmeetings\WEB-INF > \lib directory > I changed the following lines in the hibernate.cfg.xml file > > 'Rem the User /Password are included in the connection.url > 'Rem the dialect was changed to > "org.hibernate.dialect.SQLServerDialect" > 'Rem the connection.driver_class was changed to > "com.microsoft.sqlserver.jdbc.SQLServerDriver" > 'Rem the connection.url was change to " jdbc:sqlserver:// > xxx.xxx.xxx.xxx:1433;user=xxx;password=xxx;databasename=openmeetings? > > autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8" > > -- > > You received this message because you are subscribed to the Google Groups > "OpenMeetings User" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<openmeetings-user%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/openmeetings-user?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en.
