FactoryTalk Transaction Manager SQL Server Named Instance

Can FactoryTalk Transaction Manager connect to a Microsoft SQL server named instance?

The short answer is no. A SQL Server default instance uses the computer name where a SQL Server named instance uses the computer name and instance name.

That being said there is a way around it. Simply create an alias to the named instance (in SQL) using the SQL configuration manager.

• Go to SQL Configuration Manager
• SQL Native Client Configuration
• Aliases

Related posts:

1. FactoryTalk Transaction Manager Data Management Software
2. HMI Project Replication in FactoryTalk View SE
3. General Manager of an Engineering company – Chattanooga, TN (Job ID#442)