Shulou(Shulou.com)06/01 Report--

This article is to share with you about the experience of SQL Server database installation, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

System platform windows server 2012 R2 data EN; SQL server 2008 R2; goal is to migrate the membership credit system to this server.

Purchased an IBM X3650 M5 server from the designated supplier of the group, after multi-party consultation, the English operating system needs to install the English database, so the English version of the database is installed. SQL server2008 needs .net framework 4.0. the operating system does not have a version of .net, so. Net framework 4.0 is added from the server role. After the addition, SQL server still could not be installed successfully, and the error was reported in the last step and could not continue. After many torments, it was found that the SQL database version was divided into RTM and SP1, and it was not clear that the database was divided into such details.

So I got the SP1 database CD from the supplier, and after another week, I restarted the installation. Before the installation, I downloaded many versions of the database from the Internet, some in English and Chinese, and then uninstalled the database. When uninstalling, you must uninstall it completely, otherwise the installation will not be successful. I uninstall according to the web search method, the control panel uninstalls all SQL-related programs, then deletes the registry and folders, and still prompts the. net framework error when reinstalling. Later asked the master, the original C disk of the current user under the microsoft file cache reasons, delete it.

Before, I planned to uninstall .net and reinstall because I couldn't install the database. As a result, both .net 4.0and 3.5were uninstalled. Net 3.5is included in 2012 system, and Hyper-V needs the support of .net platform. As a result, I was fooled again, and finally asked the supplier master to solve the problem that Hyper-V could not run.

After receiving the supplier SQL database CD program, I began to install the server. At present, it is still an English 2012 operating system. I thought it would be no problem to install the English SP1 level database this time. As a result, the server was installed in the virtual machine server2008 Chinese system before the membership points system, although the login points system was a bit slow, but it was able to log in successfully. The points system was intended to be installed on the physical machine, but the points system does not support English, indicating that the registration is not successful. This is a disadvantage in developing a points system. It was installed in the virtual machine system as a last resort. After a few days, it was found that the integral user feedback was garbled when printing the integral. As soon as I thought about it, I suspected that the Chinese points server and the English database might not be compatible. After confirming with the points system and server suppliers many times, I entered the work phase of reinstallation.

First of all, change the operating system into a Chinese version, download the corresponding Chinese language pack from the itellyou official website through the guidance of the supplier, load the language pack program with the lpksetup command under the command line, and then adjust the language and locale, select Chinese in the language, select China in the regional location, and so on, and then restart the server, and the system successfully becomes Chinese. Let the user try again the integral system still shows garbled code, as a result, I uninstall the database and reinstall the Chinese version of the database. I'm sure there won't be garbled code this time. I tested it again and didn't show it. Finally succeeded! (during this period, I contacted the points system provider to install the service program on the physical machine, saying that it was better to contact than to ask.)

Up to now, the migration of the member points system has been completely completed, and it has successfully broken through the technical problems! General summary: the self-purchased membership points system is in Chinese, and only supports Chinese, and is not compatible with the English version of the database, otherwise there will be garbled codes, and the English version of the database can only be installed on the English system platform, otherwise the language is not compatible. The last link was replaced by the Chinese version. In short, it is a series of problems caused by the English language!

The above is what the experience of SQL Server database installation is, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.