This has probably been covered somewhere but can’t find the answer.
I’ve installed opefire before in a test environment but with the internal db and never with SQL and I can’t get it the SQL to work. How do I configure both SQL and Openfire to work together?
AD running at 2008 forest level
Server 2008R2 (called - SRV1) running on ESXi 4.1U1
SQL 2008 (instance called – MSSQL)
Installed openfire on different server (SRV2) but cannot make a connection to the database, I’ve read quite a few post but had no luck.
I created a user in AD called openfire_admin.
Created a new database in SQL called openfire
Run the script to create a new db
made openfire_admin the owner of the db
Can some please give me the correct string to enter into openfire to make the connection work, i’ve run out of combinations to try. so given up for tonight.