SmartConnector SQL authentication error using Windows authentication method

[MaximeLaudren]

Warning

Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support for assistance.

Issue

On a new installation of SmartConnector, the service is not able to start.

The log shows a SQL server authenticate error.

Product Line

EcoStruxure Building Operation

Environment

SmartConnector

Cause

For some countries, the administrator account has been localized. (List available here:

If the operating system is using one of these localized languages, the Windows administrator account may not be recognized by the SmartConnector service,

https://social.technet.microsoft.com/wiki/contents/articles/13813.localized-names-for-administrator-... )

Resolution

Workaround 1: 

Reinstall a non-localized version of Windows.

Workaround 2:

Create a new user in the SQL database.

Workaround 3:

1. Open Microsoft SQL Server Management Studio and connect to the SQL instance the SmartConnector will use.
2. Using the Object Explorer menu, navigate to the logins folder: 'Machine-name > Security > Logins'
3. Right-click on the Logins folder, and select 'New login'
4. A window will appear, to configure the new user account.
5. Provide a Login name: this is the log-in the SmartConnector will use.
6. Then select 'SQL Server Authentication', fill in the password field, and type it a second time in the 'Confirm password' field.
7. Select 'Server Roles' from the menu on the left side of the account windows.
8. Check both 'public' and 'sysadmin' if not already checked.
9. Move to the next page: 'User Mapping'
10. Select 'SmartConnector.Service' row, update 'User' and 'Default Schema' with 'dbo' value.
11. Check the 'Map' box, then in the bottom list check the 'db_owner' box.
12. Repeat steps 10 & 11 for 'SmartConnector.User' entry.
13. Click 'OK' 
14. Now that the user is created
    
    1. Uninstall the SmartConnector and restart the machine
    2. Reinstall the SmartConnector, and select 'SQL authentication' when requested
    3. Provide the newly created login with the associated password.
    4. Complete the SmartConnector installation.
    5. Validate the service is running without error.