SQL Server 2008 Express instance FTVIEWx64TagDB...cannot be found...
showshocka,
The SQL Server instance
FTVIEWx64TagDB is run as a
Windows Service. This should be running for FactoryTalk View Studio to open and operate correctly.
Search
Services in the Windows 7 Search box under the Start button. You should find
Services which opens
services.msc.
Find
SQL Server (FTVIEWX64TAGDB). The service should be
Started/Automatic. This should be a users first port of call when you get any
FTVIEWx64TagDB error messages. If you find it is
Stopped, try starting it. If it won't start, then it's possible that you have corrupted SQL database files. If that is the case, you'll require further steps. Let us know what you find.
dmroeder said:
...I have a feeling the original author created it on a 64 bit machine being that your error mentions "SQL Server Express Instance FTVIEWx64TagD". Although I think it will restore, you will not be able to open it on your 32 bit machine. I'd would be nice to confirm for sure though.
Dustin,
Let me add a bit of clarity to the matter...
The
Microsoft SQL Server 2008 R2 Express instance "
FTVIEWx64TagDB" is a bit misleading in that it mentions "
x64". While you would imagine so, this does not indicate that it is solely used on 64-bit systems. Any installation of FactoryTalk View Studio v6.1, or later, whether on a 32-bit or 64-bit Operating System, will create the SQL instance of
FTVIEWx64TagDB. It should be present on any system running FactoryTalk View Studio v6.1 or later, regardless of the OS being x86 or x64.
Some more info...
From here on...
FactoryTalk View Studio = FTVS
Microsoft SQL = MSSQL
Operating System = OS
FTVS uses MSSQL Server for its Tag Database and HMI Alarms. Using an SQL database makes the Tag Database operations more efficient. It was introduced with FTVS v6.1. The SQL instance FTVIEWx64TagDB is used just for the Tag Database and basic HMI Alarms. Other HMI features can be database logged using MSSQL, such as Datalogs, FactoryTalk Alarm and Events, and FactoryTalk Diagnostics. Separate SQL instances need to be created for these.
If you are installing FTVS v6.1, or v7 for that matter, then MSSQL Server 2008 R2 Express x86 (32-bit) is installed and the instance FTVIEWx64TagDB is automatically created. It is just a name for the instance. Why they added
x64 into that name, I'm not entirely sure?
Note 1: MSSQL Server 2008 R2 Express, Standard, or Enterprise versions may already be installed on a system before installing FTVS. You have the option to use the existing pre-installed MSSQL Server, if suitable, or install the 32-bit version of MSSQL Server 2008 R2 Express packaged with FTVS.
Note 2: MSSQL Server is available in 32-bit or 64-bit versions, but only the 32-bit version is included with FTVS installation packages. If the system OS is 64-bit, then it's possible that a pre-installed MSSQL Server could also be 64-bit. FTVS v6.1 is only compatible with 32-bit versions of MSSQL Server, but FTVS v7 is compatible with 32-bit or 64-bit MSSQL Server versions.
I hope that clears things up a bit?
Regards,
George