Maximum Community Edition Projects Reached error

[Calvin]

I installed the Team Pulse community edition sucessfully onto my server. I created one project.  When I changed the domain of the administrator from the machine name to the actual static ip, I was not able to logon anymore.  I had to unstall Team Pulse communicty edition and reinstall it.  After the re-installation, the project that I had created is no longer avaialble and I get the following error:
   "Maximum Community Edition Projects Reached error".

How do I reset the installation so I can create a new project again?  Thanks.

[Jordan]

Hi Calvin,

 The easiest thing is to uninstall TeamPulse and delete the TeamPulse database. After that install TeamPulse again. This will delete your existing project. Link to how to delete database.

If you don't want to delete your existing project you need to run an  sql script that will add your new user to the existing project. You can find ProjectID and UserID from the database.

SELECT * FROM Project
SELECT * FROM [User]

INSERT INTO [TeamPulse].[dbo].[ProjectUser]
           ([ProjectID]
           ,[UserID]
           ,[CreatedBy]
           ,[CreatedDateUtc]
           ,[CreatedSystemID]
           ,[LastModifiedBy]
           ,[LastModifiedDateUtc]
           ,[LastModifiedSystemID])
     VALUES
           (<ProjectID, int,>
           ,<UserID, int,>
           ,'admin'
           ,GETDATE()
           ,999
           ,'admin'
           ,GETDATE()
           ,999)
GO

Regards,
Jordan
the Telerik team