Error: "The database login failed. The logon failed. Error in the file..."

Enable TCP/IP for the SQL Server instance

1. Open SQL Server Configuration Manager.
2. Expand SQL Server Network Configuration, then select the SQL Server instance.
3. Enable TCP/IP for the instance.

Run Sage 100 with administrator permissions

1. Right-click the Sage 100 shortcut, then select Properties.
2. Go to the Compatibility tab.
3. Check Run this program as an Administrator, then click OK.
4. Launch Sage 100 using the shortcut and try printing the report again.

Sync MAS_Reports password using SQL Settings Utility

1. Go to Sage ERP MAS 200 SQL Settings Utility from the Sage ERP MAS 200 SQL program group.
2. Click Edit, check Update SQL Server.
3. Don’t use [localhost] as the server name.
4. Enter new passwords for MAS_User and MAS_Reports.
5. Click Accept.
   • If you moved the database server, update the Database Server name.
   • When prompted, enter the sa password or use NT Authentication.

 NOTE: If a custom report has the wrong MAS_REPORTS password, which can lock the MAS_Reports account due to Active Directory policies or system settings. The password will also be incorrect after a database restore or a change in Sage 100 SQL Settings Utility. 

Add inbound firewall rule for SQL Server Browser

1. Open Windows Firewall with Advanced Options (Run, type WF.MFC, click OK).
2. Right-click Inbound Rules, select New Rule.
3. Choose Port, click Next.
4. Select UDP, enter port 1434. Click then Next twice.
5. Choose the applicable network profiles, then click Next.
6. Enter a name like SQL Server Browser, click Finish.

Add firewall rule for SQL Server instance

1. Open Windows Firewall with Advanced Options.
2. Right-click Inbound Rules, select New Rule.
3. Choose the Program, click Next.
4. Select This program path, then Browse to the SQL Server instance executable.
   • For example, C:\Program Files\Microsoft SQL Server\MSSQL11\Instance_Name\MSSQL\Binn\Sqlserv.exe
5. Click Next twice.
6. Choose the applicable network profiles, then click Next.
7. Enter a name like Sage 100 SQL, click Finish.

Reinstall Microsoft SQL Server Native Client

• Uninstall Microsoft SQL Server Native Client.
• Reinstall Microsoft SQL Server Native Client.