The order of installation is dependent upon the SQL versions installed with Vista and I/NET.
I/NET DBCreate does not open after installation is complete. DBCreate application is not shown even though under Task Manager processes the application is active.
SQL MSDE Express
Vista and I/NET Installed on the same PC
Vista and I/NET both use SQL databases for purposes of event and trend logging. They must be installed in the correct order to coexist within the shared SQL installation.
It can be confusing to know which software should be installed first on a certain installation because it is completely dependent upon both the I/NET versions and Vista versions. Later versions are compliant with SQL 2005 Express while earlier versions must use SQL MSDE.
- If a previous installation has failed, it is best to start "fresh" before attempting a re-install.
Use the following guidelines to determine in which order to install I/NET and Vista:
If the I/NET version is prior to 2.2.1, then I/NET must be installed before Vista, regardless of the Vista version.
When prompted during the Vista installation, allow a new SQL instance on the existing SQL MSDE that was installed with I/NET.
If the Vista version is 4.3.0 through 5.0.0, and the I/NET version is 2.2.1 or higher, then Vista must be installed before I/NET.
These versions of Vista use TAC Config and SQL MSDE. When prompted during the Vista installation, allow a new SQL instance on the existing SQL MSDE that was installed with I/NET.
If the Vista version is 5.0.1 through to 5.1.6, and the I/NET version is 2.2.1 or higher, it is recommended to install Vista before I/NET.
These versions of Vista use SQL 2005 Express. I/NET versions 2.2.1 and higher have an option to install SQL 2005 Express. When prompted during the I/NET installation, allow a new SQL instance on the existing SQL 2005 Express that was installed with Vista.
If the Vista version is 5.1.7 and above, and the I/NET version is 2.2.1 or higher, it is recommended to install Vista before I/NET
The default installation of this version of Vista uses SQL 2008 R2 Express. When prompted during the I/NET installation, select Default Instance of either MSDE or SQL 2005. (Note that if installing on Windows7 operating system, MSDE option is grayed out and cannot be selected, as it is not supported on Windows7)..
If the Vista version is 5.1.7, and the I/NET version is 2.4.0 or higher, you can choose either one to be installed first.
If Vista is installed first, by default Vista will install SQL 2008 R2 Express SP1. But I/NET 2.4x fails to recognize the instance installed by Vista, while also fails to create a default instance. So after installed Vista, manually create a default instance for I/NET, and then install I/NET. Refer to Item 1 in Lessons Learned Article #15834 on how to create it; If I/NET is installed first, you can choose Custom Installation for SQL during the installation of Vista. You need to manually enter the SQL instance name, SQL username and password when installing I/NET SQL. If you don't know the instance name, there is a quicker way to identify it: Open DBCreate of I/NET, and you can see the SQL server name for I/NET. Just copy and paste it here. Then you can finish the installation.
- If the I/NET version is prior to 2.2.1, then I/NET must be installed before Vista, regardless of the Vista version.
For Vista IV installation, the correct procedure can be found here: Lessons Learned Article #2165