Delivery Controller fails to connect to local SQL Express database

Delivery Controller fails to connect to local SQL Express database

book

Article ID: CTX482391

calendar_today

Updated On:

Description

Migrating databases for existing site from a full SQL server to a SQL Express instance running in the same VM as one of the Delivery Controllers causes the controller hosting the SQL Express not to be able to connect to the database, even after the correct machine account permissions and login access have been added to the databases.

Symptoms include:

  • DBNOTFOUND errors when attempting to change the database strings via Powershell
  • Re-Enter the Controller address message in Citrix Studio
  • Only the delivery controller hosting the SQL Express instance is affected
Other delivery controllers in the site will be unaffected, and will change their strings and display information correctly via Studio.

Resolution

  1. Add NT AUTHORITY\NETWORK SERVICE account to SECURITY > LOGIN in SQL Express
    • use the same level of access, mapping and security used by a working (external) Delivery Controller.

Problem Cause

SQL Express only allowing local access to NT AUTHORITY\NETWORK SERVICE.
Computer accounts granted external access only.

Issue/Introduction

For a DDC to access a local SQL Express database instance, it needs to use the NT AUTHORITY\NETWORK SERVICE account.
Powered by Wolken Software