Sign In Help
Schneider Electric
HelpSign In
Schneider Electric Exchange
  • Home
  • Collaborate
  • Develop
  • Shop
Home Collaborate Develop Shop Log in or Register Help

Invite a Co-worker

Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel

Invitation Sent

Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
  • Home
  • Collaborate
  • Exchange Community
  • :
  • Knowledge Center
  • :
  • Building Automation Knowledge Base
  • :
  • Security Expert Multiple Machine Installation for Windows Authentication with Active Directory
Community Menu
  • Forums
    • By Topic
        • EcoStruxure IT
          • EcoStruxure IT forum
        • Industrial Automation
          • Industry Automation and Control Forum
          • Alliance System Integrators Forum
          • Machine Solutions in the Digital Transformation
          • EcoStruxure Automation Expert / IEC 61499 Forum
          • Industrial Edge Computing Forum
          • Level and Pressure Instrumentation Forum
          • Modicon User Group
          • PLC Club Indonesia
          • SEE Automation Club Forum
          • Fabrika ve Makina Otomasyonu Çözümleri
          • Форум по промышленной автоматизации СНГ
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Forum
          • SCADA and Telemetry Devices Forum
        • Power Distribution IEC
          • Power Distribution and Digital
          • Power Standards & Regulations
          • Paneelbouw & Energie Distributie
        • Power Distribution Softwares
          • EcoStruxure Power Design Forum
          • SEE Electrical Building+ Forum
          • LayoutFAST User Group Forum
        • Wireless Information Network Solutions
          • Instrument Area Network
          • Remote Monitoring
          • Tank Level Monitoring
          • Remote Data Collection
        • Solutions for your Business
          • Solutions for Food & Beverage Forum
          • Solutions for Healthcare Forum
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Forum
        • Healthcare
          • Solutions for Healthcare Forum
      • EcoStruxure IT
        • EcoStruxure IT forum
      • Industrial Automation
        • Industry Automation and Control Forum
        • Alliance System Integrators Forum
        • Machine Solutions in the Digital Transformation
        • EcoStruxure Automation Expert / IEC 61499 Forum
        • Industrial Edge Computing Forum
        • Level and Pressure Instrumentation Forum
        • Modicon User Group
        • PLC Club Indonesia
        • SEE Automation Club Forum
        • Fabrika ve Makina Otomasyonu Çözümleri
        • Форум по промышленной автоматизации СНГ
      • SCADA & Telemetry Solutions
        • Geo SCADA Expert Forum
        • SCADA and Telemetry Devices Forum
      • Power Distribution IEC
        • Power Distribution and Digital
        • Power Standards & Regulations
        • Paneelbouw & Energie Distributie
      • Power Distribution Softwares
        • EcoStruxure Power Design Forum
        • SEE Electrical Building+ Forum
        • LayoutFAST User Group Forum
      • Wireless Information Network Solutions
        • Instrument Area Network
        • Remote Monitoring
        • Tank Level Monitoring
        • Remote Data Collection
      • Solutions for your Business
        • Solutions for Food & Beverage Forum
        • Solutions for Healthcare Forum
      • Food & Beverage
        • Solutions for Food & Beverage Forum
      • Healthcare
        • Solutions for Healthcare Forum
  • Blogs
    • By Topic
        • Industrial Automation
          • Industrial Edge Computing Blog
          • Industry 4.0 Blog
          • Industrie du Futur France
        • SCADA & Telemetry Solutions
          • SCADA and Telemetry Blog
        • Power Distribution IEC
          • Power Events & Webinars
          • Power Foundations Blog
        • Power Distribution NEMA
          • NEMA Power Foundations Blog
        • Power Distribution Softwares
          • EcoStruxure Power Design Blog
          • SEE Electrical Building+ Blog
        • Solutions for your Business
          • Solutions for Food & Beverage Blog
          • Solutions for Healthcare Blog
          • Solutions for Retail Blog
        • Community experts & publishers
          • Publishers Community
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Blog
        • Healthcare
          • Solutions for Healthcare Blog
        • Retail
          • Solutions for Retail Blog
      • Industrial Automation
        • Industrial Edge Computing Blog
        • Industry 4.0 Blog
        • Industrie du Futur France
      • SCADA & Telemetry Solutions
        • SCADA and Telemetry Blog
      • Power Distribution IEC
        • Power Events & Webinars
        • Power Foundations Blog
      • Power Distribution NEMA
        • NEMA Power Foundations Blog
      • Power Distribution Softwares
        • EcoStruxure Power Design Blog
        • SEE Electrical Building+ Blog
      • Solutions for your Business
        • Solutions for Food & Beverage Blog
        • Solutions for Healthcare Blog
        • Solutions for Retail Blog
      • Community experts & publishers
        • Publishers Community
      • Food & Beverage
        • Solutions for Food & Beverage Blog
      • Healthcare
        • Solutions for Healthcare Blog
      • Retail
        • Solutions for Retail Blog
  • Ideas
        • Industrial Automation
          • Modicon Ideas & new features
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Ideas
          • SCADA and Telemetry Devices Ideas
  • Knowledge Center
    • Building Automation Knowledge Base
    • Industrial Automation Knowledge Base
    • Industrial Automation How-to videos
    • SCADA & Telemetry Solutions Knowledge Base
    • Digital E-books
    • Success Stories Corner
    • Power Talks
  • Events & Webinars
    • Innovation Talks
    • Innovation Summit
    • Let's Exchange Series
    • Technology Partners
  • Support
    • Ask Exchange
    • Leaderboard
    • Our Community Guidelines
    • Community User Guide
    • How-To & Best Practices
    • More
Join Now
How can we help?
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
50909members
Join Now
244884posts
Join Now

Security Expert Multiple Machine Installation for Windows Authentication with Active Directory

Back to Building Automation Knowledge Base
Options
  • Article History
  • Subscribe to RSS Feed
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content
0 Likes
601 Views
Trying to translate this page to your language?
Select your language from the translate dropdown in the upper right. arrow
Translate to: English
  • (Français) French
  • (Deutsche) German
  • (Italiano) Italian
  • (Português) Portuguese
  • (Русский) Russian
  • (Español) Spanish

Security Expert Multiple Machine Installation for Windows Authentication with Active Directory

Commander Alan_Wood Commander
‎2019-10-09 01:00 PM

on ‎2019-10-09 01:00 PM

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

Security Expert Installation steps for separate SQL, SX application Server, and Client for use with Windows Authentication and Active Directory

Product Line

Security Expert

Environment

  • Microsoft SQL Server
  • Microsoft Windows10
  • Security Expert Server and Client 

Cause

Access Denied error appears when attempting to log into Security Expert with Windows Authentication with a multiple PC Security Expert Installation

Resolution

Important considerations when connecting Security Expert to an external SQL Server:

  1. Machines should be on the same network and Domain.
  2. When you install Security Expert, reference the SQL database in this form: 

Machine Name\SQL Instance Name

  1. The Windows user account doing the installation must have admin rights on both machines. The windows login you're using to install on the Security Expert machine has to have admin privileges to alter the SQL Database on the remote machine. The easiest way to do this is to use the same account to set up all machines. Different accounts can be used, but the accounts have to have privileges added to the SQL Database manually. (Not covered in this document)

 

Assumptions:

  • Active Directory server has a domain user that can be used to install the applications on all machines.
  • Licenses cover all machines
  • Security Expert users are set up to use Windows Authentication (snapshots at the end of the document)
  • If the SQL server ever had Security Expert Installed on it, uninstall Security Expert and reboot.
  • If the Security Expert application server had SQL on it, uninstall SQL, reboot and reinstall Security Expert without local SQL.
  • If the Client PC had Server components installed, uninstall Security Expert, reboot and install the client only.

 

  1. Perform the SQL Server Installation onto a separate Server per the Security Expert Installation Instructions
  2. Security Expert Application Server/Client installation (No SQL)

If this box is selected, the install may fail because the service has not been installed yet.

With this option selected, the install will finish and then the service can be configured later.

Start Service.jpg

3. Change the database server to NOT be localhost\SecurityExpert

Use machinenameofSQLServer\SecurityExpert (Ex. SECEXPERTVM\SecurityExpert)

DatabaseServerRemote.jpg

4. Select Windows Authentication

WindwosAuthenticationSelect.jpg

Complete the installation.

 

5. Open Windows Services on the Security Expert Application Server (Run> services.msc)

Right-click on Security Expert Data Service> Properties

Select the Log On tab

Deselect Login As Local System Account

Select This account and then click browse to search for the domain admin user

SXDataServiceDomainUser.jpg

 

Start the service.

Security Expert Data Service, Security Expert Event Service, and Security Expert Update should all start

 

  1. Client only setup - Ensure the Server option is deselected

In the following dialog select Custom

ClientCustom1.jpg

 

7. Select the drop-down next to Server> then select “This feature will not be available”

ClientCustom2.jpg

Complete the installation

 

A successful login with the domain admin account using Windows Authentication from the Security Expert machine and also the client PC should work.

 

From the Client PC – Security Expert application server = 10.169.90.170

ClienLogin.jpg

From the Security Expert Server/Client

ServerLogin.jpg

SecurityExpertSV.exe.config (Server) – This file did not have to be changed

SecurityExpertSV.exe.Config.jpg

 

 SecurityExpert.exe.config (Client) - This file did not have to be changed

SecurityExpert.exe.Config.jpg

 

Note: There may be circumstances where these files do need to be configured. See LL

https://community.exchange.se.com/t5/Knowledge-Base/Security-Expert-Error-Server-Has-Rejected-Client...

 

Domain Tab example set up in Security Expert for Active Directory Windows Authentication

SX AD TAB.jpg

 

Operator Example setup in Security Expert for Windows Authentication

SX Operator WindowsAuth.jpg

 

Global Support Lab Testing

SX Application Server (Windows10 1803)

SQL Server – Server 2012 R2 with SQL 2016 SP1 (VM)

SX Client – Window 8.1 Pro

Labels (1)
Labels:
  • EcoStruxure Security Expert
Tags (1)
  • Find more articles tagged with:
  • AlanWood19
Was this article helpful? Yes No
No ratings
Contributors
  • JonGreen
    JonGreen
  • Alan_Wood
    Alan_Wood
Support

Have a question? Please contact us with details, and we will respond.

Contact Us
FAQ

Look through existing questions to find popular answers.

Learn More
About

Want to know more about Exchange and its possibilities?

Learn More

Full access is just steps away!

Join Exchange for FREE and get unlimited access to our global community of experts.

Connect with Peers & Experts

Discuss challenges in energy and automation with 30,000+ experts and peers.

Get Support in Our Knowledge Base

Find answers in 10,000+ support articles to help solve your product and business challenges.

Ask Questions. Give Solutions

Find peer based solutions to your questions. Provide answers for fellow community members!

Register today for FREE

Register Now

Already have an account?Log in

About Us FAQ Terms & Conditions Privacy Notice Change your cookie settings
©2020, Schneider Electric