Microsoft SQL 2000

Version: 7
Views: 1.4k  |  Created: 10/25/2002

Average Rating: 0
SQL 2000 has 1 inventory records, 1 Questions, 2 Blogs and 2 links. Please help add to this by sharing more!

Deployment Tips (7)

Most Common Setup Type
Not Determined
Average Package Difficulty Rating
Rated 0 / 5 (Not Rated) based on 0 ratings
Most Commonly Reported Deployment Method
Not Determined
or cancel
119
Command Line
And of course you can always use x86\setup\setupsql.exe -r to record your own setup.iss file (found in %WinDir%)

For silent installs with CCM/iCommand you will have to ignore the error stream, even successfull installations have an errorlevel <>0.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
118
Command Line
x86\setup\setupsql.exe k=SMS -s -m -SMS -f1 "answerfile.iss"

There are a handful of existing ISS files provided on the CD along with batch files containing the above command syntax to trigger their installations. These answer files need to be edited to include the product CD key in the section titled, "DlgCDKey-0" value, "CDKey".
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
118
Note

Sometimes the silent setup will not run, becaus of pending file operations. in this case you can temporarily rename the pendingfileoperations key in the registry under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations before installing. After installation COPY the key back to the original name.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
118
Note
I've seen people on other sites unable to figure out how to install the so-called pre-requisites for SQL SERVER 2005. so here they are:

::**Install Pre-Requisites**
:: Microsoft SQL Server Native Client
<path>\SETUP\sqlncli.msi /qb /L*v %TEMP%\client_err.log

::Microsoft SQL Server Setup Support Files
<path>\SETUP\SqlSupport.msi /qb /L*v %TEMP%\Support_err.log

CAVEAT: If you install using the template.ini file, the prerequisites get re-installed, again.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
117
Note

There is also a SMS package Defintion File in the Disk1 Directory off the CD. Although it was orignially intended for SMS 2.0 it can still be used with SMS 2003

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
117
Note

The PDF file used included on CD1 does not work with SMS 2003. In addition Microsoft has confirmed that you cannot use Enterprise Media for a silent unattended install. You must use Developer Edition Media. This install fails due to the fact MDAC creates pending file operations.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
117
Note
Changing the Default Login Authentication Mode

While installing SQL Server 2000 Desktop Engine using the Windows Installer Merge Modules you can change the default login authentication mode from Windows NT to SQL. There is an undocumented property SECURITYMODE that you can set to "SQL".

Another way to change the security mode after installation is to stop SQL Server and set the following registry key
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
to 0 for Mixed Mode or 1 for integrated. (Integrated is the default setup for the SQL Server 2000 Data Engine.)

For additional information see Microsoft Knowledge Base article Q285097.

Written by Stefan Krueger
Found on http://www.installsite.org/pages/en/msi/tips.htm

Feb 2006
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment

Inventory Records (1)

View inventory records anonymously contributed by opt-in users of the K1000 Systems Management Appliance.

Versions

SQL 2000

Version

7

Questions & Answers (1)

Questions & Answers related to Microsoft SQL 2000

3
ANSWERS

Blogs (2)

Blog posts related to Microsoft SQL 2000

blog
blog

Reviews (0)

Reviews related to Microsoft SQL 2000