Common upgrade procedures, Recreate sql server 2008 r2 express instance, A • common upgrade procedures – Rockwell Automation FactoryTalk View Site Edition Installation Guide User Manual
Page 145
131
A
PPENDIX
A
Common upgrade procedures
This section contains notes, common procedures and information from the Rockwell
Automation Knowledgebase that you may find helpful during installation of FactoryTalk
View products.
Procedures in this section are:
“Recreate SQL Server 2008 R2 Express instance” on page 131.
“Installing product updates” on page 132.
Recreate SQL Server 2008 R2 Express instance
SQL Server 2008 R2 Express instance FTVIEWx64TagDB is created to store all the
FactoryTalk View SE Tags and HMI Alarms data, which HMI Server and View Studio
will access. You need to recreate SQL Server 2008 R2 Express instance
FTVIEWx64TagDB manually under the following cases:
For some reason you need to uninstall SQL Server 2008 R2 Express instance
FTVIEWx64TagDB and reinstall it.
On a computer that has had only the FactoryTalk View SE Client installed
previously.
A message shows up asking the user to recreate the SQL server instance if user has not
done so.
To Recreate SQL Server 2008 R2 Express instance
1. If necessary, close all open Windows programs, and then place the FactoryTalk View
Site Edition DVD in the computer’s DVD drive.
2. Locate and run D:\Redist\SQLServerEXPR_2008R2SP2\SQLServerInstall.exe
where D:\ is the drive containing the DVD.
If you are installing FactoryTalk View with an existing SQL server, see Rockwell Automation
Knowledgebase Answer ID 463910:
Windows Installer 4.5 and .NET Framework 3.5 SP1 are required for this procedure.
FTViewSEInstallENU.book Page 131 Wednesday, July 16, 2014 10:53 AM