Skip to content
  • There are no suggestions because the search field is empty.

Login failed for user 'sa'

This article helps Webgility Desktop users resolve an “Invalid SA credentials” message when connecting an add-on computer to the Webgility SQL database. We need to take a backup of the Webgility Database & -install a new instance of SQL.

If you're getting the following error while connecting the database from the add-on user, follow the steps below.

Webgility default SQL credentials. Every Webgility Desktop install ships with the same SQL Authentication defaults: Instance WEBGILITY or UNIFY, Username sa, Password Webgility2011. On the login screen, choose SQL Server Authentication and use those exact values before trying anything else.

Steps to follow:

  • Try restarting the SQL services first — many "Login failed for user 'sa'" cases clear on a service restart. Full walkthrough: Restart SQL Services.

     

    Open Windows Services (services.msc), then right-click SQL Server (WEBGILITY) and SQL Server Browser and choose Restart. Source: Restart SQL Services. 

  • Confirm the SQL instance name Webgility expects. Go to the computer where the SQL database is installed, or to a computer where Webgility is already working, and open C:\Webgility\UnifyEnterprise\XML\ApiConfig.xml in Notepad. Note the source name in the first line. Do not change any values in this file — close it without saving.

  • On the Webgility Desktop login screen of the computer where you are facing the issue, choose SQL Server Authentication from the Authentication dropdown, re-enter Username sa and Password Webgility2011, and click Login.

  • If login still fails, contact Webgility Support. The Support team needs to verify the sa permissions in SQL Server Management Studio (SSMS) and confirm the credentials that were set during the original setup. It is also possible the SQL computer is running under Windows Authentication while the add-on machine needs SQL Authentication with the correct credentials — Support will validate this before making any change.