How to create a case-sensitive instance of SQL Server 2000 (Setup)
To create a case-sensitive instance of SQL Server 2000
- Run SQL Server Setup to install SQL Server 2000 Components, select Install Database Server, and then click Next at the Welcome screen of the SQL Server Installation Wizard.
- In Computer Name dialog box, Local Computer is the default option and the local computer name appears in the edit box. Click Next.
- In the Installation Selection dialog box, click click Create a new instance of SQL Server, or install Client Tools, and then click Next.
- Follow the directions on the User Information and related screens.
- In the Installation Definition dialog box, click Server and Client Tools, and then click Next.
- In the Instance Name dialog box:
- To create a case-sensitive default instance, accept the Default check box and click Next.
- To create a case-sensitive named instance, clear the Default check box and type an instance name.
- To create a case-sensitive default instance, accept the Default check box and click Next.
- In the Setup Type dialog box, click Custom, and click Next.
- In the Select Components, Services Accounts, and Authentication Mode dialog boxes, change or accept the default settings, and then click Next.
- In the Collation Settings dialog box, you have two options:
- To make a Windows Locale collation case-sensitive, select Collation designator and then select the correct collation designator from the list. Clear the Binary check box, and then select the Case-sensitive check box.
- To make a SQL collation case-sensitive, select SQL Collations, and then select the correct collation name.
For more information about collation options, click Help. When you finish setting the options, click Next.
- To make a Windows Locale collation case-sensitive, select Collation designator and then select the correct collation designator from the list. Clear the Binary check box, and then select the Case-sensitive check box.
- In subsequent dialog boxes, change or accept the default settings, and then click Next.
- When you are finished specifying options, click Next in the Start Copying Files dialog box.
- In the Choose Licensing Mode dialog box, make selections according to your license agreement, and click Continue to begin the installation.
- Click Help for information about licensing, or see your system administrator.