Trouble with MS SQL Installation

Openfire Openfire Support
1

Hey guys,

Im trying to setup an SQL installation for Openfire so far without any luck.

Could anyone help me with the pointers below.

I have the string;

jdbc:mysql://bridges2/openfire;instance=SQLEXPRESS

I’ve setup the database called openfire which is within an SQLEXPRESS instance on a server called Bridges2.

Can anyone tell me the easiest way to setup a username/password for the spark instance to authenticate with the instance?

on the instance security logins I have domain/administrator which is also present on the database logins, but ive not been able to login.

Any pointers would be a big help.

2

Wonder why are you using mysql url if you are using ms sql Read the SQL Server part here http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html

To setup a user you can do it in Admin Console or via any client if inbound registration is enabled on your server.

Btw, you may hit the same problem if you plan to use Monitoring plugin http://community.igniterealtime.org/message/176422#176422