Submitted by 1546322 on Mon, 10/03/2016 - 17:37
Symptom
Attempting to create a new database and getting error “Failure Creating SYModule”.
Cause
There is a problem attempting to create the file of the new database. The most common cause of this is that you are attempting to create a database with a name of a file that already exists in the data directory. The second most common cause is a permission issue with file creation. SQL server does not have rights to create a new file in the sql data directory. This is usually because of changes in security setup on the server.
 
Resolution
Go to the SQL data directory (usually C:\Program Files\Microsoft SQL Server\<servername>\MSSQL\DATA and take a look at the files there. Look for a *.mdf or *.ldf file that has the same name as the database you are trying to create. Try removing that file from the directory or changing the name of the database you are trying to create.
 
NOTE: If the user is hosted on the ABILA cloud there could be other issues.
 
Article Type
Product Info
Product Line
MIP Fund Accounting
Product Module/Feature
Technical Issues
Ranking
No votes yet