Server

Set up SQL Server as a database

By default ManicTime uses SQL Ce database. The good thing about this database is that it doesn't have to be installed, the bad is that it is not very scalable. So if more then three ManicTime instances will connect to the server, we recommend that you use SQL Server as a database. You can use any version of MS SQL, starting with SQL Express which is free.

Once you have SQL Server up and running, you need to create ManicTimeServer database. In the folder where ManicTimeServer is located, find the file CreateManicTimeServerDatabase.sql. Run the contents on your SQL Server, it should create a database.

If ManicTimeServer is running, stop it. Next open file ManicTimeServer.exe.config.

You need to change two things:

1. Change <add key="DatabaseType" value="sqlce"/> to <add key="DatabaseType" value="sql"/>
2. Change the connection string so that it points to your database. Locate line <add name="ManicTimeServer" connectionString="Data Source=Data\ManicTimeServer.sdf;Max Database Size=4000"/> and change with <add name="ManicTimeServer" connectionString="Server=localhost;Database=ManicTimeServer;Trusted_Connection=True" />

Both lines are already included as comments, so you can just uncomment them. Once you are done, save the file and start ManicTimeServer.