The following error occurs when attempting to add a new server in the Messagestats console:
"Could not allocate new page for database 'Messagestats'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth error while adding a server in the Messagestats console."
This error indicates that the Messagestats database has run out of space.
To resolve the issue take the following steps:
1. Open SQL Enterprise Manager and drill down to the Messagestats database.
2. Right-click on the Messagestats database and select Properties.
3. Select the Data Files tab and increase the space allotted and ensure the 'automatically grow file' option is selected.
4. Specify unrestricted file growth in the maximum file size and give about 30 % of file growth.