Microsoft SQL Server 2005

Version: 9
Views: 3.2k  |  Created: 12/15/2005

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

Deployment Tips (12)

Most Common Setup Type
Not Determined
Average Package Difficulty Rating
Rated 1 / 5 (Very Easy) based on 2 ratings
Most Commonly Reported Deployment Method
Vendor Provided Command Line (switch driven)
or cancel
124
Note
To remove the CustomerFeedback:

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90]
"CustomerFeedback"=dword:00000000

To remove Customer Experience Improvement Program Dialog Box:

[HKEY_CURRENT_USER\Software\Microsoft\VSCommon\8.0\SQM]
@="0"
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
123
Command Line
SQL 2005 Client Tools and SSMS

The following commands can be executed to install the SQL 2005 Client Tools and SQL Server Management Studio.

Install
setup.exe /qb ADDLOCAL=Client_Components,Connectivity,SQLXML,SQL_Tools90

Repair
setup.exe /qb REPAIR=Client_Components,Connectivity,SQLXML,SQL_Tools90

Uninstall
setup.exe /qn REMOVE=Client_Components,Connectivity,SQLXML,SQL_Tools90
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
122
Note

The install files need to be kept in the directory structure that they are on the CD, so you need a folder named "Servers" and a folder named "Tools" on the top level, with the appropriate files under them.

This is per

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
121
Command Line
SQL Server 2005 SP1 Installation for Client Tools

The following options can be used when updating the SQL 2005 SP1 Client Toos and SSMS installation.

Install (x86-English)
SQLServer2005SP1-KB913090-x86-ENU.exe /quiet

Report Only Option (To see what installed components will be upgraded)
SQLServer2005SP1-KB913090-x86-ENU.exe /reportonly

Installation Log is located in %SystemRoot%\hotfix and are labled hotfix.log and hotfixX.log where X is the next incremented number.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
120
Note
; This is an example template.ini file that will install all the components except Report Services and the DB Examples.
; To use this .ini file, use the /settings switch on the SQL Server 2005 Setup.exe command line.
; For example: start /wait setup.exe /qb /settings c:\template.ini
[Options]
INSTANCENAME=MSSQLSERVER
;INSTALLSQLDIR= "%ProgramFiles%\Microsoft SQL Server\"
INSTALLSQLDATADIR=D:\SQLINSTALLASDATADIR=D:\SQL;INSTALLSQLSHAREDDIR="%ProgramFiles%\Microsoft SQL Server\"
SQLACCOUNT=domain\sqlservice
SQLPASSWORD=<your password here>
AGTACCOUNT=domain\sqlservice
AGTPASSWORD=<your password here>
ASACCOUNT=domain\sqlservice
ASPASSWORD=<your password here>
SQLBROWSERACCOUNT=domain\sqlservice
SQLBROWSERPASSWORD=<your password here>
SECURITYMODE=SQL
SAPWD=<your password here>
SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
SQLAUTOSTART=1
AGTAUTOSTART=1
ASAUTOSTART=1
SQLBROWSERAUTOSTART=0
ADDLOCAL=ALL
REMOVE=RS_Server,RS_Web_Interface,SQL_DatabaseSamples,SQL_AdventureWorksSamples,SQL_AdventureWorksDWSamples,SQL_Samples
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
119
Note

Re: removing the 'Customer Feedback' and 'Customer Experience Improvement Program' nags, if you were hoping to hook the key path to an advertised shortcut so that a self-heal creates the HKCU keys, there aren't any such shortcuts. You'll need to either add one or edit one of the existing ones. I chose to use the 'SQL Server Management Studio' one (which launches SQLWB.EXE).

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
118
Note
This application uses chained .MSI files for it's deployment. A template.ini file is provided that details all configurable settings. You can make the changes in the template.ini and include it with:

Setup.exe /qb /settings <path>\template.ini

Or you can specify your choices directly on the command line.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
7
Command Line
The template.ini states that you should use:

start /wait setup.exe /qn .......

as the command line.

This fails with an invalid switch /qn, but i fyou drop the start /wait from the command line it works fine.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
2
Command Line
ForSQL Server 2005 SP2 Service Pack 2 I used the following...

Run Parameters:
/quiet /norestart

Full Command Line:
sqlserver2005sp2-kb921896-x86-enu.exe /quiet /norestart
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
0
Note
To suppress the compatibility prompt running SQL and Visual Studio add the following registry entries.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags]
"{3d06c673-5e8a-41c0-b47f-3c3ca0a22e67}"=dword:00000077
“{5f66dbae-cad3-468a-83d0-77ace8abc1f6}”=dword:00000077
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
0
Command Line

If you want to also install Visual Studio 2005 (the free version that comes with Business Intelligence Development Studio) add this entry to your ADDLOCAL list: SQL_WarehouseDevWorkbench

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
0
Note
To suppress the compatibility prompt running SQL and Visual Studio add the following registry entries.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags]
"{3d06c673-5e8a-41c0-b47f-3c3ca0a22e67}"=dword:00000077
“{5f66dbae-cad3-468a-83d0-77ace8abc1f6}”=dword:00000077
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 Server 2005

Version

9

Questions & Answers (0)

Questions & Answers related to Microsoft SQL Server 2005

Blogs (0)

Blog posts related to Microsoft SQL Server 2005

Reviews (0)

Reviews related to Microsoft SQL Server 2005