Perform the following operations to check the OS version and patches:1. On the desktop, right-click My Computer
and choose Properties
from the shortcut menu.
2. On the General
tab page, verify that the OS version and patches are Windows Server 2003 R2 Enterprise with SP2
If the OS version and patches are incorrect, install a Windows OS with the DVD provided with the server.
One NIC must have only one IP address. For details, see 19.21 How to Check Whether an NIC Is Assigned Multiple IP Addresses (Windows)
and 19.22 How to Delete Unnecessary IP Addresses of an NIC (Windows)
Check disk partitions. For disk partition requirements, see Collecting Installation Information.
Check whether the database has been installed. If the SQL Server database has not been installed but the disk or software package of the SQL Server standard edition (installing the database in the Windows Server 2008 OS): VSMversion
_server_dbstd_win32_x86 is available, the VSM server software automatically installs the SQL Server database and VSM. In other scenarios, install the SQL Server database in binary mode
. For details, see 20.4 Installing the SQL Server 2000 and Its Patches
1. Choose start
2. Check whether the Microsoft SQL Server
program exists. If the program exists, the database has been installed.
The password for user sa
cannot be blank and must contain a minimum of six characters, for example, changeme
. The password contains only digits (0 to 9) and letters (a to z and A to Z). If the password for user sa
of the installed SQL Server database does not meet these requirements, change the password. For details, see 20.8 How to Change the sa Password of the SQL Server
If the SQL Server database has been installed, check whether the database is installed in binary mode. For details, see 20.3 How to Check Whether the SQL Server Database Can Be Sorted in Binary Mode
If the database is not installed in binary mode, the VSM fails to install. In this case, manually uninstall the database. For details, see 20.13 How to Manually Uninstall the SQL Server Database
. Then, reinstall the database in binary mode. For details, see 20.4 Installing the SQL Server 2000 and Its Patches
3. Run the following command to check whether the isql
command can be executed:
C:\> isql -Usa -Psa password -Sdatabase name
is displayed, the database can be accessed. Then, run the quit
4. Run the following commands to check whether the bcp
command can be executed:
C:\> bcp master..sysdatabases out -Usa -Psa password -Sdatabase name -oD:\test.txt -c
Verify that the test.txt
file is generated in disk D and check contents in the file. If replication data is displayed, the bcp
command can be executed.
If the preceding requirements are met, ensure that the database is running. During VSM installation, a message is displayed asking you whether to reuse the database. In this case, reuse the database. If the SQL Server database has not been installed, the VSM server software automatically installs the SQL Server database.
Check whether the current server uses terminal server components.
If the current server uses terminal server components, the VSM installation will fail.
1. Open the Control Panel
. In Control Panel
, double-click Add or Remove Programs
2. In the Add or Remove Programs
dialog box, click Add/Remove Windows Components
in the left pane.
3. In the Windows Components Wizard
dialog box, confirm that the Terminal Server
check box is not selected.