Sage 100

Been a while since I've installed a new Sage 100 Premium. Everything seemed to go fine but no MAS_System database (or MAS_ABX) was created in the SQL server instance. Our user had admin rights. Now we get a SQL not enable message - I'm thinking because there is no database for the Sage workstation to connect to. Any ideas?

During the installation itself you are asked how to login - via Window authentication (who you are currently logged into Windows as) OR SQL auth. I always choose the latter and put in the sa account as the user, even if it means the IT guy has to remote in and type in the password for me. Otherwise, in SQL Mgmt Studio, login there as the same exact user you used during the installation (same Windows auth vs SQL auth . Then click on New Query and type in: CREATE DATABASE MAS_SYSTEM If you got an error then note the error and troubleshoot that. It may or may not have anything to do with permissions.

thanks Alnoor - we're going to uninstall and reinstall with sa tomorrow. I'll also try that ""Create database mas_system"" query

You can also find more helpful information about the errors in the SQL logs. When I had this situation is was because I did not have an exclusive lock on the 'model' database.

IT uninstalled an reinstalled (without me) and apparently changed something or took our advice and used sa user - but it works now