Mirth on Windows Server 2008 and SQL server 2008
If you are in HL7 business and have not looked at Mirth, you must. Kudos to the Mirth team, they have brought out a phenominal product. More I use it more I get amazed with its capabilities. In one of my recent project I had to install Mirth on a brand new Windows server 2008 running SQL Server 2008. I had not done this kind of implementation earlier and was skeptical as to how it will work. My previous installations on Windows and Linux boxes used MySQL as the internal datbase, this one was different, I had to use SQL Server 2008 for internal database. But it is quite simple, here are the steps:
1. Edit “C:\Program Files (x86)\Mirth\conf\mirth.properties” and make sure the database property is set to sqlserver2005
database=sqlserver2005
2. Login to SQL Server management studio and create an database called “mirthdb”
3. Inside SQL Server Management Studio, execute the script “C:\Program Files (x86)\Mirth\sqlserver2005-database.sql” which creates all the necessary tables within mirthdb database.
4. Create an account called “mirthdb” and grant necessary priviledges to this account for mirthdb database.
5. Edit “C:\Program Files (x86)\Mirth\conf\sqlserver2005-SqlMapConfig.properties” and add the username and password for the SQL Server user created above.
Thats it, restart the Mirth servcie and login to Mirth. It is as simple as that.
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Great article, simple and to the point. It should be helpful for people getting started with MS SQL & Server 08 and Mirth.