Verify the installation of Microsoft SQL Server 

---

Instructions to verify installation

To verify the correct installation of Microsoft SQL Server, do the following:

1. Ensure that all SQL Server services are running. (If they are not, follow step ***ERROR WHILE PROCESSING LINK TO "XREFstepstartsqlservices"*** in Install Microsoft SQL Server).

2. Connect to the SQL Server by doing the following:

   1. From the Start button, select Programs->Microsoft SQL Server 7.0 (or Microsoft SQL Server)->Enterprise Manager.

   2. Expand the Microsoft SQLServer->SQL Server Group, and then locate and expand your SQL Server machine name.

   3. Expand the Databases folder and verify that the following databases are present:

      • master

      • model

      • msdb

      • tempdb

   
   

3. Query the SQL Server by doing the following:

   1. From the Start button, select Programs->Microsoft SQL Server 7.0 (or Microsoft SQL Server)->Query Analyzer

      The Connect to SQL Server dialog box appears.

   2. From the Connect to SQL Server dialog box, do the following:

      • Select the server (for a local server, select either . or select local ) from the SQL Server drop-down list box. If there are no selections in the SQL Server drop-down list box, select the button to the right of the list box.

      • After you have selected the server, select the Use SQL Server authentication option.

      • Enter the Login Name and Password. If this is the first time you have installed SQL Server, then enter sa as the Login Name and leave the Password field blank.

      • Click the OK button.

        The Query window appears.

   3. Enter each of the following queries in the Query window, and then select the Execute Query button.

      • select @@servername 'Server Name'

      • select @@version 'version'

      • exec sp_helpsort

      The Query window splits. The upper portion of the window provides the commands originally executed and the bottom portion of the window provides the results of the queries.

   Verify that the query produced the following results:

   • The correct Server Name (for example, msgcare)

   • The correct SQL Server version

   • The correct version of the operating system

   • The correct unicode data sorting (case-insensitive, kana-type insensitive, and width-insensitive).

   • Verify the correct character set (ISO 8859-1, Case-insensitive dictionary sort order). Code page 1252 (ISO character set) is the default character set for non-Japanese servers and Code page 932 is the default character set for Japanese servers. It is also known as the ISO 8859-1, Latin1, or ANSI character set. It is compatible with the ANSI characters used by the Microsoft NT and Microsoft Windows operating systems. Code page 1252 might be appropriate if you intend to use clients running Windows.

4. Look for error conditions in the following log files if any of the verification steps fail. The log files are text files that you can open in a text editor such as NotePad.

   • sqlstp.log (located in the Windows directory)

   • cnfgsvr.out (located in the SQL \install directory)

   • Errorlog (located in the SQL \Log directory or where your database is installed)

   

---

Copyright © 2001 Avaya Inc. All rights reserved. Modified: March 19, 2001