Server choice for SQL Express installation for IEC61850 in 800XA6.1
I'm trying to find out if there is a recommended server of choice for the installation/deployment of SQL express while using IEC61850 in 800XA6.1 I understand that previously it was connectivity server as it acted as the OPC with CET installed in it. But with the new version I find that the aspect server also has the IEC61850 Connect services deployed and it is only during the deployment of the IEC61850 connect services in the aspect serer that it asks for the SQL Express path, not while deploying in connectivity server. Does this mean the SQL needs to reside in aspect server now? Also what happens when having redundant servers?
The SQL server is usually installed on all Aspect Servers, and then the Configuration is manually copied from Primary Server to other SQL Servers for redundancy, i think this part is described in the Reference Manuals... You may be able to use SQL Server installed on other Nodes than Aspect Server but i don't think this is a supported installation option