Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • You may be familiar with Communities' brand new layout from SE.com.
  • Don't forget to update your bookmarks and saved links with our new address (https://community.se.com/).
  • If you encounter any issues, please contact SchneiderCommunity.Support@se.com.
Close
Sign In Help
Important Announcement: WELCOME to the Schneider Electric Community! We have moved to a new address: community.se.com — bookmark it today and contact SchneiderCommunity.Support@se.com if you have any questions!
Schneider Electric
Help
Ask the Community Community Guidelines Community User Guide How-To & Best Practices Contact Support
Login / Register
Community Menu
  • Community Home
  • Forums
    • By Topic
        • Support
          • Ask the Community
        • EcoStruxure Building
          • SmartConnector Forum
          • Field Devices Forum
        • EcoStruxure Power & Grid
          • EcoStruxure Energy Hub User Group
          • Gateways and Energy Servers
          • Metering & Power Quality
        • APC UPS, Critical Power, Cooling and Racks
          • APC UPS Data Center & Enterprise Solutions Forum
          • APC UPS for Home and Office Forum
        • EcoStruxure IT
          • EcoStruxure IT forum
        • Remote Operations
          • EcoStruxure Geo SCADA Expert Forum
          • Remote Operations Forum
        • Industrial Automation
          • Industry Automation and Control Forum
          • Industrial Edge Computing Forum
          • Alliance System Integrators Forum
          • Machine Automation Forum
          • EcoStruxure Automation Expert / IEC 61499 Forum
          • AVEVA Plant SCADA Forum
          • Modicon PAC Forum
          • Harmony Control Customization Forum
          • Level and Pressure Instrumentation Forum
          • PLC Club Indonesia
          • Fabrika ve Makina Otomasyonu Çözümleri
          • Motorabgangstechnik & Antriebstechnik Forum
          • Korea Industrial Automation Forum
        • Schneider Electric Wiser
          • Schneider Electric Wiser Forum
        • Power Distribution IEC
          • Power Distribution and Digital
          • Solutions for Motor Management
          • Paneelbouw & Energie Distributie
          • Eldistribution & Fastighetsautomation
          • Elektrik Tasarım Dağıtım ve Uygulama Çözümleri
          • Електропроектанти България
          • Specifiers Club ZA Forum
        • Power Distribution NEMA
          • Power Monitoring and Energy Automation NAM
        • Power Distribution Software
          • EcoStruxure Power Design Forum
          • LayoutFAST User Group Forum
        • Solutions for your Business
          • Solutions for your Business Forum
      • Support
        • Ask the Community
      • EcoStruxure Building
        • SmartConnector Forum
        • Field Devices Forum
      • EcoStruxure Power & Grid
        • EcoStruxure Energy Hub User Group
        • Gateways and Energy Servers
        • Metering & Power Quality
      • APC UPS, Critical Power, Cooling and Racks
        • APC UPS Data Center & Enterprise Solutions Forum
        • APC UPS for Home and Office Forum
      • EcoStruxure IT
        • EcoStruxure IT forum
      • Remote Operations
        • EcoStruxure Geo SCADA Expert Forum
        • Remote Operations Forum
      • Industrial Automation
        • Industry Automation and Control Forum
        • Industrial Edge Computing Forum
        • Alliance System Integrators Forum
        • Machine Automation Forum
        • EcoStruxure Automation Expert / IEC 61499 Forum
        • AVEVA Plant SCADA Forum
        • Modicon PAC Forum
        • Harmony Control Customization Forum
        • Level and Pressure Instrumentation Forum
        • PLC Club Indonesia
        • Fabrika ve Makina Otomasyonu Çözümleri
        • Motorabgangstechnik & Antriebstechnik Forum
        • Korea Industrial Automation Forum
      • Schneider Electric Wiser
        • Schneider Electric Wiser Forum
      • Power Distribution IEC
        • Power Distribution and Digital
        • Solutions for Motor Management
        • Paneelbouw & Energie Distributie
        • Eldistribution & Fastighetsautomation
        • Elektrik Tasarım Dağıtım ve Uygulama Çözümleri
        • Електропроектанти България
        • Specifiers Club ZA Forum
      • Power Distribution NEMA
        • Power Monitoring and Energy Automation NAM
      • Power Distribution Software
        • EcoStruxure Power Design Forum
        • LayoutFAST User Group Forum
      • Solutions for your Business
        • Solutions for your Business Forum
      • Food & Beverage
      • Healthcare
  • Knowledge Center
    • Building Automation Knowledge Base
    • Geo SCADA Knowledge Base
    • Industrial Automation How-to videos
    • Digital E-books
    • Success Stories Corner
  • Success Stories
  • Events & Webinars
    • All Events
    • Innovation Talks
    • Innovation Summit
    • Let's Exchange Series
    • Technology Partners
    • Power Events & Webinars 
    • Partner Success
    • Process Automation Talks 
  • Ideas
        • Remote Operations
          • EcoStruxure Geo SCADA Expert Ideas
          • Remote Operations Devices Ideas
        • Industrial Automation
          • Modicon Ideas & new features
  • Blogs
    • By Topic
        • EcoStruxure Power & Grid
          • Backstage Access Resources
        • Remote Operations
          • Remote Operations Blog
        • Industrial Automation
          • Industry 4.0 Blog
          • Industrie du Futur France
        • Power Distribution NEMA
          • NEMA Power Foundations Blog
        • Knowledge Center
          • Geo SCADA Knowledge Base
          • Industrial Automation How-to videos
          • Digital E-books
          • Success Stories Corner
      • EcoStruxure Power & Grid
        • Backstage Access Resources
      • Remote Operations
        • Remote Operations Blog
      • Industrial Automation
        • Industry 4.0 Blog
        • Industrie du Futur France
      • Power Distribution NEMA
        • NEMA Power Foundations Blog
      • Knowledge Center
        • Geo SCADA Knowledge Base
        • Industrial Automation How-to videos
        • Digital E-books
        • Success Stories Corner
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
  • Communities
  • :
  • Knowledge Center
  • :
  • Building Automation Knowledge Base
  • :
  • Security Expert Multiple Machine Installation for Windows Authentication with Active Directory
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: 
82702members
350440posts

Security Expert Multiple Machine Installation for Windows Authentication with Active Directory

Back to Building Automation Knowledge Base
Options
  • Article History
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content
0 Likes
987 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
Share

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
Share

Related Forums

  • Field Devices Forum
Previous Next
Contributors
  • JonGreen
    JonGreen
  • Alan_Wood
    Alan_Wood
Invite a Colleague
Found this content useful? Share it with a Colleague!
Invite a Colleague

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practices
  • Experts Leaderboard
  • Contact Support
 
  • twitter
  • facebook
  • linkedin
  • youtube
  • blog
  • instagram
Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account..

Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account?Login

Privacy Notice Terms of Use Customize Preferences
© 2022, Schneider Electric