Sage Error 42000 ODBC when Opening Sage Intelligence Report Manager, as a User who is Assigned a Roaming Windows Profile

The Sage error message code 42000 is the common issue in Sage 100. This error usually happens when users try to create a company file copy or activate the module using a new code. You can fix the issue by changing the size of the initial file of the database. The issue will be resolved by changing the file size however if the error persists then here is the article with a troubleshooting guide to fix the Sage Error 42000.

What is Sage Error 42000?

The error is also known as Sage error code 42000 modify file failed which pops up on the screen when you try creating a company file copy or when accessing the intelligence report manager (having rights to roam Windows profile). This is because the users have a roaming profile and Microsoft SQL server management studio login failed to have sys-admin credentials.

Read More-: Sage 100 Error Messages

What are the Causes of Sage Error Message 42000?

• The MS Server manager studio login failures because of missing admin rights
• When the database is not generated with SQL

How to Resolve the Sage Error 42000?

• Open the Server
• With the system administrator rights login to the Microsoft SQL 2014 Management studio
• Click on Object Explorer
• Hit Security button
• Click Logins tab
• Now give a double-click on the name of the user set during login
• It will launch the login properties page
• You need to give a click on the tab named Server Roles.
• Now locate to the left to choose a page panel
• Hit the Server Roles button
• Click on the list labeled Server roles
• Now place a mark on the field named sysadmin
• Once you are done with this hit the OK button
• Close the window which says Microsoft SQL 2014 Management studio
• Now restart the system (workstation)
• Next launch the Sage intelligence reporting report manager

Also Read-: Sage Unable to Connect to Server

Final Words

That’s all for today! Hopefully, the information is helpful to tackle database file failed error code 42000. This error is associated with the SQL instance so if you face any difficulties then it is a great decision to talk to the professional team. Rounding your mind on the same issue repeatedly will waste time and effort so reach the experts to get exceptional help from the team. Use a Sage 50 live chat, phone number, or drop a query with an error message on email.

Frequently Asked Questions(FAQs)