The message that you report is displayed when JMS need to create a DB for the slave site and for which it does not has a MySQL user that has the permission to create the DB.
In general, under cPanel, it is easier to create the DB under cPanel before proving the information to JMS.
OR you should have to provide to JMS the MySQL "root" login to allows creating DB dynamically. Such "root" login and password can be setup inside the "Setttings" menu present in JMS.
If you share the "RSForm" extension, this mean that you will have the same RS Form content in each website.
You mention publish content from category.
I don't remember that RS Form has categories for the display of their content.
If you make reference to the Joomla / Content menu and categories then you make reference to the Joomla articles and their categories.
In this case, if you want to diplay the articles present in a specific category of article, this is possible with the "Article sharing for JMS" that allows displaying an the articles coming from another websites.
www.jms2win.com/en/joomla-multisite?page...67&category_id=1