Change or Move Sophos PureMessage SQL Database
Written on February 22, 2011

Migrating Sophos PureMessage to another SQL database is a simple process. On the server you wish to modify, open C:\Program Files\Sophos\PureMessage\Config\LastKnown\LocalConfig.xml.

Under the <LocalConfig> tag there are four DBSettings tags, one for each database. These are called ConfigDBSettings, QuarDBSettings, ReportingDBSettings and DirectoryDBSettings. Inside each of these is another called <DatabaseName>. By modifying this DatabaseName you are able to change where Sophos PureMessage stores its data. This is useful if using an SQL server with more than a few databases. I like to prefix all of my Sophos PureMessage databases with “PM” to make them stand out. An extract of my completed config file looks like this:

<LocalConfig>
	<ConfigDataVersion>2</ConfigDataVersion>
	<Capabilities>23</Capabilities>

	<ConfigDBSettings>
		<ServerName>vsql01</ServerName>
		<DatabaseName>PMSavexCnfg</DatabaseName>
		<AuthType>0</AuthType>
		<UserName></UserName>
		<Password></Password>
		<ConnectionTimeOut>30</ConnectionTimeOut>
		<CommandTimeOut>60</CommandTimeOut>
	</ConfigDBSettings>

	<QuarDBSettings>
		<ServerName>vsql01</ServerName>
		<DatabaseName>PMSavexQuar</DatabaseName>
		<AuthType>0</AuthType>
		<UserName></UserName>
		<Password></Password>
		<ConnectionTimeOut>30</ConnectionTimeOut>
		<CommandTimeOut>60</CommandTimeOut>
	</QuarDBSettings>

	<ReportingDBSettings>
		<ServerName>vsql01</ServerName>
		<DatabaseName>PMSavexRprt</DatabaseName>
		<AuthType>0</AuthType>
		<UserName></UserName>
		<Password></Password>
		<ConnectionTimeOut>30</ConnectionTimeOut>
		<CommandTimeOut>60</CommandTimeOut>
	</ReportingDBSettings>

	<DirectoryDBSettings>
		<ServerName>vsql01</ServerName>
		<DatabaseName>PMSavexDir</DatabaseName>
		<AuthType>0</AuthType>
		<UserName></UserName>
		<Password></Password>
		<ConnectionTimeOut>30</ConnectionTimeOut>
		<CommandTimeOut>60</CommandTimeOut>
	</DirectoryDBSettings>
</LocalConfig>

Comments/questions

There's no commenting functionality here. If you'd like to comment, please either mention me (@chris@aus.social) on Mastodon or email me. I don't have any logging or analytics running on this website, so if you found something useful or interesting it would mean a lot to hear from you.