SQL Server Database Installation Experience Summary

System platform Windows Server R2 data EN; SQL Server R2; The goal is to migrate the loyalty points system to this server.

An IBM X3650 M5 server was procured from the designated supplier of the group, and the English database was installed in the English-speaking operating system, so the English version of the database, SQL server2008 needed. NET Framework 4.0, The operating system does not have a version of. NET, and the. NET Framework 4.0 is added from the server role. Add, SQL Server still cannot install successfully, to the last step error, unable to continue, after a variety of torture found that the SQL database version is divided into RTM and SP1 two kinds, before it is not clear that the database is also divided so detailed.

So from the supplier to obtain the SP1 database CD, and after 1 weeks, restart the installation, before installation I downloaded from the Internet a lot of versions of the database, the Chinese in English, and then unload the database, uninstall must be completely uninstalled, otherwise it will be installed unsuccessful. I follow the online search method to uninstall, Control Panel uninstall all SQL-related programs, and then delete the registry and folders, reinstall or prompt. NET Framework errors. Later consulted the master, the original C disk in the current user under the Microsoft File cache reason, delete is good.

Before, because I was unable to install the database, I had intended to uninstall. NET reinstallation, as a result. NET 4.0 and 3.5 are uninstalled,. NET 3.5 is the 2012 system comes with, and Hyper-V running requires the support of the. NET Platform. As a result I was blindfolded, finally consulted the supplier master, resolved the Hyper-V can not run the problem.

After receiving the vendor SQL database CD-ROM program, I started to install the server, currently still in English 2012 operating system, I would like to install the English SP1 level of the database must be OK, the result member points system before the server is installed in the virtual machine server2008 Chinese system, Although the landing points system is a bit slow, but can successfully landed. The integration system is intended to be installed on a physical machine, but the integration system does not support English and indicates that registration is unsuccessful. This is a drawback of developing the integration System. Forced to install in the virtual machine system. After several days of discovery, points user feedback printing points when garbled. I wonder if the Chinese point server and English database may not be compatible with the problem, after the integration system and the server vendor repeatedly confirmed, and then entered the re-installation of the work phase.

First, the operating system into the Chinese version, through the supplier guidance, download the corresponding Chinese language package from the Itellyou official website, the command line with the Lpksetup command to load the language pack program, after loading the server did not require restart, and adjust the language and regional settings, Language choice Chinese, Regional location Select China and so on, and then restart the server, the system successfully became Chinese. Let the user try to test the integration system or display garbled, and then I uninstalled the database reinstall the Chinese version of the database. This time certainly will not garbled, and test again did not show garbled. Finally succeeded!!! (during the period and contact points system supplier to install the service program on the physical machine, said the contact is more than beg)

So far, member integration System migration work is complete, and successfully breakthrough technical problems! General Summary: Self-procurement member points system is Chinese, and only support Chinese, can not be compatible with the English version of the database, otherwise it will be garbled, the English version of the database can only be installed in the English system platform, otherwise the language is not compatible. Finally tied up, all replaced by the Chinese version. In short, are the English language caused a series of problems!

SQL Server Database Installation Experience Summary