ITWorx MLG Catalyst error while creating database

While configuring Catalyst School Provisioning tool you sometimes receive an error:
CREATE DATABASE permission denied in database ‘master’.

The problem is that some people get misleaded by the Provisioning Account and start elevating his permissions on the database, but this does not solve the problem. The trick is that the database is created by the SharePoint Central Administration App pool User.

So in order to fix this problem you need to do the following:

1- Check on the IIS  the account that the central administration App pool is using, App pool Identity.

2- Elevate the account’s permissions to DBCreator on the SQL server.

Advertisements

Live webinar: Accelerate the deployment and provisioning of your SharePoint e-learning platform

Live webinar: Accelerate the deployment and provisioning of your SharePoint e-learning platform

Challenges faced by today’s educational institutions typically lie in three main areas: efficiency, security, and accuracy.  

When it comes to building a Microsoft based e-learning platform, thousands of students, teachers, and parents’ accounts should be provisioned for tens or hundreds of your schools on an interrelated set of Microsoft application servers such as Active directory, SharePoint, Exchange, and Office Communication Server (OCS). In reality, these activities are painful. In such large-scale deployments of Microsoft Learning Gateway (MLG) or other connected e-learning solutions, manual provisioning becomes practically impossible. Consider data incompleteness and inconsistency. And add the fact that mass provisioning is needed every new academic year and ongoing re-provisioning is needed through the year.

 
Build your Microsoft e-learning platform. Automate your most mission-critical provisioning and ongoing management activities. Rely on a secure, reliable, and scalable provisioning solution; ITWorx Education Catalyst Provisioning Suite.
 
ITWorx introduces Catalyst 2.0, the second release of its market- sweeping provisioning product, with a richer set of functions and capabilities to further expedite and facilitate your provisioning processes.  

In this webinar you will learn how Catalyst can:

  • Decrease the provisioning time from weeks to hours.
  • Meet the real education business challenges.
  • Automate the synchronization with Schools’ Management Information Systems.
  • Guarantee data consistency and accuracy across the board.
  • Tailor to administrator needs for reduced complexity.