This is I have found out. Indeed, it seems like some buggy. We have corrected it now.
1. download both kooboo_cms.zip and the content_provider.zip
2. setup Kooboo website and copy the SQL content provider into Kooboo CMS bin folder.
3. run the CMS and try to create a new site, get the error of authorization failed.
4. Open the Kooboo disk folder, find the sqlserver.config, create a new blank SQL database and correct the connection string there.
5. Go back to Kooboo CMS, delete the previously created website and recreate a new website.
Everything works fine after all these troubles.
Agreed that is not a nice solution, we have changed this part now. Will be updated soon.
Regards,
Vincent
Kooboo Team