Microsoft SQL Server 2005 Express Edition (MSDE)

Version: 9
Views: 4k  |  Created: 11/26/2007

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

Deployment Tips (8)

Most Common Setup Type
Not Determined
Average Package Difficulty Rating
Rated 4 / 5 (Somewhat Difficult) based on 1 ratings
Most Commonly Reported Deployment Method
Windows Installer Command Line (No MST)
or cancel
135
Note
You can use the .MSI's just fine. Install in this order for a basic setup:

SqlSupport.msi (can be installed silently)
sqlncli.msi (SQL Client - can be installed silently)
SqlWriter.msi (can be installed silently)
SqlRun.msi

Works peachy!
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
6
Note
2005 is problematic in that you can't just use the MSIs, as the main one, SQLRUN, relies on some registry settings which Setup.EXE puts down. We captured those and created a pre-requisite MSI for that purpose. Additionally, you need to run SQLWriter.MSI before SQLRUN. Our deployment goes like this:

- Pre-requisite MSI we created
- SQLWriter
- SQLNCLi (optional)
- SQLRun
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
6
Note
For Unattended install from the EXE:

sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1

NOTES:

You cannot force log files like a normal MSI (it's an "InstallShield MSI"). This particular install will create log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

The /QN will not make the install Silent. /QB will also work. Either way it's an automated install with a lot of Flash for the user to watch. (it's an "InstallShield MSI")

Known issue: installing SQL Server 2005 fails on MSXML6

MSI log file shows:
MainEngineThread is returning 1605 (This action is only valid for products that are currently installed.)

Used the Windows Installer Cleanup Utility (available here: http://support.microsoft.com/kb/290301) to remove the MSI Database entry for MSXML6.0.

Probable Cause: There seems to be at least 2 "Flavors" of MSXML6.0. The SQL Express flavor cannot install over top of the other and does not see it as equivalent and fails with MSI error 1605.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
2
Note

If you use the individual MSI method to install you will need to specify the features you want installed. The default install level is set to 90 and the features are set to 100.

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
1
Command Line
For a complete default unattended installation ...

Run SQLEXPR.EXE /x to extract the source files. Find the file template.ini (usually in the folder where the setup.exe file is). Open it and fill/add what needed and save the file under the name of your choice.

Here's the default parameters I used:
USERNAME=User
COMPANYNAME=Company
INSTALLSQLDIR=
INSTALLSQLSHAREDDIR=
INSTALLSQLDATADIR=
ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity
INSTANCENAME=MSSQLSERVER
SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE"
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=0
DISABLENETWORKPROTOCOLS=0
ENABLERANU=0
ADDUSERASADMIN=0

Here's the command to execute the setup with the .ini file:

start /wait setup.exe /qn /setting [path of the .ini]
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
1
Virtualization
Thinapp suggestion:
http://blogs.vmware.com/thinapp/2009/03/how-to-thinapp-msdesql-2005-express.html
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
1
Command Line
Having followed Shuffles post from the "Notes" section, SQL installed perfect using only the MSI's.

To create a new Instance using only MSI's, find the "sqlrun.msi" and use the standard setup.exe string.
ie:

msiexec /i "..\sqlrun_sql.msi" instancename=SQLEXPRESS SQLAUTOSTART=1
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
0
Note
SQLNCLi is NOT optional if you use msi only.

Had to add: HKEY_USERS\S-1-5-20\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\AppData = "%USERPROFILE%\Application Data" as (a REG_EXPAND_SZ string)

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/c8a66cde-5cf0-46e2-9742-fefe534d24ba/

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 Express Edition (MSDE)

Version

9

Blogs (0)

Blog posts related to Microsoft SQL Server 2005 Express Edition (MSDE)

Reviews (0)

Reviews related to Microsoft SQL Server 2005 Express Edition (MSDE)