When Try To Install SQLEXP32.EXE Silent And Have The Log Files?

Feb 22, 2008

Try to install SQL server Express
download from Microsoft site SQLEXP32.EXE version 9.0.3042.0
Expand this file using command line install "start /wait setup.exe /qn ADDLOCAL=All LOGNAME="c: empInst_SQLEXP.cab"

at installed computer just have C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGsummary.txt

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Feb 22 10:58:50 2008

and C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DC7660_TEST2_Core.log

Microsoft SQL Server 2005 Setup beginning at Fri Feb 22 10:58:50 2008
Process ID : 3884
C: empSQLEXPsetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2008/1/22 10:58:50
Complete: LoadResourcesAction at: 2008/1/22 10:58:50, returned true
Running: ParseBootstrapOptionsAction at: 2008/1/22 10:58:50
Loaded DLL:C: empSQLEXPxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/1/22 10:58:50, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3884"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/1/22 10:58:50
Complete: ValidateWinNTAction at: 2008/1/22 10:58:50, returned true
Running: ValidateMinOSAction at: 2008/1/22 10:58:50
Complete: ValidateMinOSAction at: 2008/1/22 10:58:50, returned true
Running: PerformSCCAction at: 2008/1/22 10:58:50
Complete: PerformSCCAction at: 2008/1/22 10:58:50, returned true
Running: ActivateLoggingAction at: 2008/1/22 10:58:50
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00DBCFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.


have a Unexpect error?
any advice welcome.

View 1 Replies


ADVERTISEMENT

Silent Install Of Sql Server CE

May 29, 2007

I have a desktop application in which I use Sql Server CE.

It all works well on my development machine.

It also works on other machines if I copy the sql dll files in the same path as the .exe

I'm trying to avoid all kinds of user interaction. They don't need to know that I'm about to install Sql Server CE really

So I'm hoping to avoid writing in the manual that the user should install SQLServerCE31-EN.msi, which I think is the correct install package.



So my question is: How do you silently/unattended install Sql Server CE on the desktop?

View 1 Replies View Related

Silent Install Using VBScript

Mar 19, 2007

Hi,

how do Silent Installation with VBscript ? because I have some step for user interactive.

please anyone put an example about this or put a link to.

thank you very much.

View 6 Replies View Related

[MSDE] Silent Install, Not Associated With Trusted....

May 24, 2002

Hi all,

After doing a silent install of the MSDE, my application cannot access the database that is loaded on the local machine -

I am getting an error stating - 'login failed for user 'sa'. Reason: Not associated witha trusted SQL server connection'

Is there are parameter or something that i need to change in my UDL??

or is there a way to tell the server to work in non-trusted inviroment via the OSQL program???

thanks
tony

View 1 Replies View Related

Silent Install With SQL Server 2005 SP2

Aug 25, 2007

I can't get SQL Server 2005 to update to SP2 in either silent or unattended mode. None of the standard switches work. I've used -s, -m, /q, /qb, and /qn all with no favorable result. I am still prompted for user input at every screen. Suprisingly I've had no such problems with the express edition, just the server itself. Is there a way to make this thing work? Here is the line I've been feeding to the installer.

"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait setup.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart

I have also tried the following since it looks like the file that is unpacked by the SP2 install is actually hotfix.exe

"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait hotfix.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart

I also have tried the following generics:

"<SERVER_PATH>SQL Serversql2005SP2.exe" -s

"<SERVER_PATH>SQL Serversql2005SP2.exe" -m

"<SERVER_PATH>SQL Serversql2005SP2.exe" /q

View 3 Replies View Related

Silent Install With Fixed Tcp Port

Sep 12, 2007

Hi,

I'm doing a silent install of SQLServer Express 2005 as explained in http://msdn2.microsoft.com/en-us/library/ms144259.aspx .

I am setting DISABLENETWORKPROTOCOLS=2 because I want to enable TCP/IP protocol at install time.

However it seems that per default SQLServer is configured to use dynamic TCP/IP ports, forcing me to contact the SQLBrowser.

How can I switch to a fixed port, say 1433, at install time?

Thanks, in advance,
Dirk.

View 11 Replies View Related

SqlExpress &&amp; Silent Install As A Prereq???

May 18, 2007

I'm still doing some research but I thought I'd slap a quick post up here anyway. I'm trying to create a small 'setup and deployment' project in studio 2005 that includes a prerequisite (sqlexpress). The one thing I've noticed is that there is not an option to install this silently by providing the executable with the appropriate switches. I could easily write my own small utility to do the work or I could use a third-party component like NSIS, however, I'm quite simply amazed that this feature was left out of studio 2005. It's quite possible I'm missing something...any feedback is appreciated 100 times over!



Thanks



Corey

View 3 Replies View Related

Silent Install New SQL Express Instance Via MSI

Aug 4, 2006

I'm currently building an MSI to install SQL Express and want to install as a new instance, not the default instance, and not into the SQLEXPRESS instance either.

I saw the package.xml for Express in my VS Studio install. How would I go about using this? Or would I have to modify the MSI via Orca or something? I hope not. Wouldn't have a clue where to start.

In short, regardless if there is already an SQL Express instance on the machine or not, I need to silently install a fresh new instance of the server engine only, no client tools except sqlcmd.exe

I have seen that MS would advise that everyone use the SQLEXPRESS instance but I don't agree with it. I don't want other application installs trampling over my server settings and I don't want to trample over others. For example, expose others to TCPIP and CLR when they don't need it, and conversely others swithing them off in a shared server instance when I do need them.

View 7 Replies View Related

Silent SQL SE 2005 Install Headaches...

Aug 17, 2006

Yet another roadblock: Does the standard SQL SE 2005 not install any of the query commands? (isql, isqlw, or osql.exe's). I could have sworn that they were, but every time I go to test the install on my VM none of them are ever installed. If it doesn't is it included in the advanced version of it (which I'd really rather not do)? If still no what's the easiest option I still have open? Can I have my app connect to the master db and run a restore script from the app? I've been arm wrestling with this install for over a week and it's just about brow-beaten me completely.

TIA,

Jayyde

View 3 Replies View Related

SQL2005 Silent Install Collation Options?

May 26, 2008



I am setting up a template.ini for my SQL2005 installs. The documentation on the INI file is great up until the "SQLCOLLATION" section.

How do I choose the SQL Collation: "Dictionary order, case-insensitive, uppercase preference, for use with 1250 Character Set" ?

SQLCOLLATION=???????

View 1 Replies View Related

SQL 2005 Express SP2 Silent Install Fails

May 16, 2007

Hello,
I'm using the latest version of SQLEXPR32.EXE found here :
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en

Here is the command line that fails :

"sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress
INSTANCENAME=MYINSTANCE SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"

Interrestingly, when the following command line is used to launch the setup,
it completes successfully :

"sqlexpr32.exe /norebootchk reboot=ReallySuppress INSTANCENAME=MYINSTANCE
SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"

The only difference between the two is the quiet switches used in the first
case : "-q" and "/qn"

After spending some time to understand what is going wrong, it seems that in
quied mode, Setup Prerequisite 'SQL Native Client' is not installed. Then
the remaining part of the setup fails because of this.

Any help appreciated.

View 7 Replies View Related

Unattended/Silent Install - Enable TCP/IP Property

Mar 15, 2007

I'm able to install SQL 2005 Express using a template.ini, and use the option DISABLENETWORKPROTOCOLS=2 in order to enable TCP/IP. However, I then manually need to open SQL Server Config Manager > SQL Network Config > Protocols for SQL > TCP/IP > "IP Addresses" tab > change all "enabled" options to "yes".

Is there an automated way to do this?

Thanks,

James

View 1 Replies View Related

Unattended (Silent) Install SQL Server Express How Do I Specify A The Built In System Account???

Aug 15, 2006

When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account.

I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work.

As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent.

I've tried:

SQLACCOUNT=NT AUTHORITYSYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SERVICE
SQLACCOUNT=SYSTEM

SQLACCOUNT=BUILT-INSYSTEM


etc.

and even some different SID as:

S-1-5-18
S-1-5-19

All with no password with the SQLPASSWORD parameter:

SQLPASSWORD=

I still getting the same error while validating the service account.

Is there someone else who knows what I'm doing wrong?

Best regards,

Mattias

View 5 Replies View Related

Replacing A Cluster Node: SQL Silent Install Setup Installshield Error

Sep 10, 2007

Can anyone tell me how to get around this? Installing SQL- no issues, just when applying the sp



I have tried numerous things, including rebuilding the 2nd node again



Trying to install a service pack on SQL 2000 node, and Install shield keeps returning this error, .



[InstallShield Silent]
Version=v5.00.000
File=Log File
[ResponseResult]
ResultCode=-8



I have reset temp directories on both nodes,

I have made user permissions and profiles exist

I have copied install files to both local and remote locations


I know the response €“ Installshield cannot find the silent response file, but SQL setup creates this on its own.
Short of bringing this production system down and re-installing on both nodes ( I did test this on a non-prod box by the way, no issues), I am at a loss

View 1 Replies View Related

Installing SQL Server 2005 Express Via Command Prompt (silent / Basic GUI Install)

Feb 20, 2008

Hi,

I would be very grateful if someone could take a look at my command line install and offer advice on if I am doing it correctly.

The reason I am asking is because I cannot seem to get the server installed without having errors during the installation:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error 17113 (0x42D9)"

Looking at the server error log indicates that master.mdf was not in the data directory (I have however specified a different data directory for ease of backup by our software and this is created during the install but does not have this database in the data directory - it is however in the template data directory!

I also get this error when the SQL Server service is started:
"The SQL Server (SQLEXPRESS) service terminated with service-specific error 3417 (0xD59)."


All advice is welcome. Please see below my batch file. Also, if you think I should do this in a different way then please let me know. I basically want to install SQL server on a customer computer and automate the install so the custoemr does not need to enter any information.

The goal of this install is:
[1] Deply a custom .Net application and SQL server at the same time on the same computer without user input.
[2] Allow remote .Net applications (designed by myself also) to connect over a LAN (and later maybe over a WAN) to the database to the above database.

The command line is this (I have also included the batch file I am usign below). For ease of reading I have put the parameters on a new line below:

setup.exe /qb
username="CustomerUsername"
companyname="OurCompany"
addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
disablenetworkprotocols="0"
instancename="MSSQLSERVER"
INSTALLSQLDATADIR="c:SqlData"
USESYSDB="c:SqlData"
SAVESYSDB="1"
SQLAUTOSTART="1"
SECURITYMODE="SQL"
SAPWD="#StrongPaSSword#"



======= Batch file Start ======

SET MODE=/qb
SET SETUP_EXE=sqlfilessetup.exe %MODE%
SET SQLDATADIR=c:SqlData


SET SET_USERNAME=username="CustomerUsername"
SET SET_COMPANYNAME=companyname="OurCompany"
SET SET_ADDLOCAL=addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_DISABLENETWORKPROTOCOLS=disablenetworkprotocols="0"
SET SET_INSTANCENAME=instancename="MSSQLSERVER"

SET SET_INSTALLSQLDATADIR=INSTALLSQLDATADIR="%SQLDATADIR%"

SET SET_SAVESYSDB=SAVESYSDB="1"
SET SET_USESYSDB=USESYSDB="%SQLDATADIR%"

SET SET_SQLAUTOSTART=SQLAUTOSTART="1"
SET SET_SECURITYMODE=SECURITYMODE="SQL"

@REM === RE-INSTALL PARAMS - NOT CURRENTLY BEING USED?? SHOULD I ADD THESE ALSO? ===
SET SET_REINSTALLMODE=REINSTALLMODE="omus"
SET SET_REINSTALL=REINSTALL="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_REBUILDDATABASE=REBUILDDATABASE="1"

SET SET_SAPWD=SAPWD="#StrongPaSSword#"


@REM === START THE SETUP / RE-INSTALL ===

START %SETUP_EXE% %SET_USERNAME% %SET_COMPANYNAME% %SET_ADDLOCAL% %SET_DISABLENETWORKPROTOCOLS% %SET_INSTANCENAME% %SET_INSTALLSQLDATADIR% %SET_USESYSDB% %SET_SAVESYSDB% %SET_SQLAUTOSTART% %SET_SECURITYMODE% %SET_SAPWD%

======= Batch file End ======


Your advice is kindly welcome.

Thank you

Kind regards

Paul

View 2 Replies View Related

Configuring SQL Express During Installation And Attaching Smart Client DB / Silent Install For One Click?

Oct 9, 2006



Hey all,

Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.

Thanks in advance,

Bill

View 7 Replies View Related

Apparent BUG With SQL Server 2005 Express Silent Install /qb Command Line ( SQLEXPR.EXE/qb ) And Displaying Errors.

Dec 12, 2005

I am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.

View 6 Replies View Related

How To Install Sql Files Manually?

Jan 13, 2004

I am new to the ASP.NET and SQL scene.
How do you run a sql script manually?

I have MSDE SP3 installed and running. I am having a problem with the localhost setup for some of the kits and need to run the scripts manually.

Any help would be great, including helpfull learning resources.

View 2 Replies View Related

Where To Install SQLServer's Program Files?

Sep 22, 2006

Hi, I'm after some advice.

I have a server containing two mirrored HD's connected to a SAN.

I have to install SQL Server 2005 onto this server, I intend to put all data/log files on the disks that are in the SAN but my question is: where is the best place to install SQLServer itself, the local disk (ie. C:) or disks within the SAN?

Thanks

View 4 Replies View Related

New Install, But I Need To Move Data Files

Apr 26, 2007

I could really use some help on this one. I know virtually nothing about SQL Server. We installed this because our database for the application we're running (Lexis Nexis Time Matters) had gotten too large for the Express 2005 version. We've also installed a new version of the software, and on a new server.

The new server has the drive partitioned into two partitions. When installing the application, I selected drive D (545 gb) as the data drive, but when I installed SQL server, it was installed on drive C (12 gb). I did not realize that the the application data was simply configuration information, and the data for the program is actually being installed on the C drive (Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData).

Is there a simple procedure to move this data, including the SQL instance (TIMEMATTERS) to the D drive? Or should I uninstall and start over?

View 1 Replies View Related

Install SQL 2005 Std X64 From Software Distribution Zip Files?

May 1, 2008

I've got three files (sql 2005 std edition x64) that were downloaded from the volume license software distribution download site. One appears to be the SP2 (SW_CD_NTRL_SQL_Svr_2005SP2_64Bit_X64_English_1_X13-36347.EXE). But the other two I can't figure out how to handle. I've unzipped them both (SW_CD_SQL_Svr_Standard_Edtn_2005_64Bit_X64_English_1_x64_MLF_X11-57664.EXE SW_CD_SQL_Svr_Standard_Edtn_2005_64Bit_X64_English_2_x64_MLF_X11-57665.EXE) and they appear to have differences in what they contain, BUT there are no instructions on how to proceed with the install. I'm guessing one of them is the 32 bit versions of the management tools that still run in 32 bit mode and the other is the server. The readme's in both are the same. There are no directions on what to do or how to proceed with the installation. I've started both installs just to get far enough to see that they both want to install prerequisite software but neither tells me that this is 64 bit prerequisite. They look identical to that point.

Please point me in the right direction for some instructions on how to install this. I've installed SQL hundreds of times, but this one has be stumped on the proper process.

View 5 Replies View Related

HOw To Force SQL 2005 To Use My D Drive To Install Files Instead Of C

Nov 11, 2005

Hi,

View 12 Replies View Related

Update SQL Server 2005 Install Files

May 22, 2006

Is it possible to update the SQL 2K5 installation files to SP1? Thanks.

View 1 Replies View Related

HELP - SQL Server 2000 Install Files Needed Urgently

Jul 23, 2005

Hi!I have a large project that is due to complete this week. In order tocomplete it I need SQL Server 2000 installed on a remote server. Mydisk is corrupt and to order another media disk would damage mydeadline. I have the licence and serial key, but now need good installfiles. I am even ready to buy another retail box, if I can find asupplier that would give me a download site for the media, while I waitfor the shipment!Please PLEASE help!Regards,Barry

View 6 Replies View Related

Install Client Connectivity (SQL Server 2000) Only W/ Less Files?

Jul 23, 2005

I have a 500-MB full installation CD for SQL Server 2000. All I needis to install "Client Connectivity" component (about 272K) on a bunchof workstations for users across the nation.How do I reduce the installation file size, by eliminating most of theunwanted files?Thanks.

View 2 Replies View Related

SQL 2005 Failed - Cannnot Install Files To The Compressed Or Encrypted..

Feb 15, 2007

Hi, I am trying to lean ASP.NET. So I was trying to install SQL Server too. But, I could not install. The aleart box popped up:

"SQL Server set up cannot install files to the compressed or encrypted folder: C:Program FilesMicrosoft SQL Server"

Before this, I also got a warning that the hardware of my computer does not meet the hardware requirement.

I would like to know how I can install SQL Server into my computer. Or, shouldn't I do that? To learn ASP.NET I want to have a database ready. If I can not use SQL Server, I may try Access or something smaller...

Thanks in advance.



yyokota2

View 1 Replies View Related

SQL Server Management Studio Express: How Can I Install AdventureWorks Dbo Files? Is AdventureWorksBI.msi Right For Them?

Dec 1, 2006

Hi all,

I downloaded the AdventureWorksDB.msi and install AdventureWorksDB in my C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData with

the following stuff:

AdventureWorks_Data

AdventureWorks_Log

masterlog

mastlog

model

modellog

.........

But, in my computerSQLEXPRESS (SQL Server 9.0...), I did not see the

following:

|-| Databases

|-| AdventureWorks

|+| Database Diagrams

|-| Tables

|+| System Tables

|+| dbo.Production.ProductCategory

|+| dbo.Production.Product

|+| ....................

Should I download the AdventureWorksBI.msi from Microsoft and install it to get the 'dbo' and other files? Please help and advise.

Thanks in advance,

Scott Chang

View 5 Replies View Related

Unable To Install SQL Server 2005 - Removing Backup Files Hangs

Oct 6, 2007



HELP!

For the past several weeks, I have been trying to install SQL Server 2005 on a Win XP SP2 PC. Regardless of the options I choose (SQL Engine + Client Tools, Client Tools only, etc.) when the installation gets to the end of the Client Tools setup and the setup status displays "Removing Backup Files", my PC appears to hang.

For a period of time, there is a fair amount of HD activity which gives me the impression that files are in fact being deleted, but then there is no HD activity and the installation appears to hang. Finally I give up and kill the setup process and reboot.

After reboot, it appears that the client tools have been installed (the icons appear and I can open the Management Studio, but when I try to connect to an existing instance of SQL, that hangs. This occurs for either Windows or SQL authentication.

Has anyone experienced this behavior and determined the root cause? What EXACTLY is happening during the "Removing Backup Files" phase of the installation?

Thanks for any help in advance,
Marc Mueller

View 3 Replies View Related

What Is Silent Installation?

Sep 13, 2007

Could someone tell me what a silent inatallation is please?

Many thanks

View 2 Replies View Related

Silent Unpack Of

May 22, 2006

Hello,

The need is to redistribute and install SQL Express in the silent mode. Looks like the current license does not allow to redistribute SQL Express in a way other than self-unpacking archive (we need sqlexpr_adv.exe). It seems that the way to do it is:


1. Unpack this archive in the silent mode to the default temp directory, without any dialogs popping up.

2. Proceed with the installation of the unpacked files in the silent mode.

No prob with 2), but we don€™t really know how to deal with 1).

Is there any way to get a full list of command-line parameters for sqlexpr_adv.exe, including the parameter for the silent unpacking?

Thanks,

Alexander.

View 6 Replies View Related

64 Bit Silent Installation

Dec 7, 2006

Hi:

Is it possible to install a 64 bit SQL Server 2005 silently?. I am wondering what are the command options that are needed to do a quiet Install of Enterprise Edition of SQL Server 2005 (x64) on a x64 OS.

Any info is appreciated.

Thanks

Ankith

View 1 Replies View Related

SQL Express Silent Installation.

Mar 14, 2006

I am writing an application that requires SQL Express to be installed alongside.

So I try to do the following - Before installing my application, I pop-up a link which leads to "SQLEXPR.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLServer <other parameters> /qb " .
But this displays only a basic GUI, which means that the pre-requisite checks for SQL express are not displayed to the user. So if MDAC version 2.8 is not present on the system the installation of SQLexpress fails without any error messages (except in the log files).
( This is not a problem with all pre-requisites :: If .NET is not present on the system, the failure is much more elegant. There is a nice GUI pop-up which requests the user to install .NET 2.0 before installing SQL express.)

On the other hand, If I remove the "/qb" switch, I can get the pre-requisites GUI to display and the end-user can figure out the cause of failure easily enough. But this means that the optional parameters I use, for example the instancename or the authentication mode will not be used during the install

Is there a good commandline switch I can use so that
1) The pre-requisites check screen is displayed
2) All the commandline options are used for installation.

Thanks

View 5 Replies View Related

Silent Installation Of SQL Server

Apr 16, 2007

Hi There,



My ASP.Net application needs AJAX and SQL Server to be installed on the server.

How can I make AJAX and SQL Server installation as a part of my application installation?



Is it possible to automate the install of SQL Server? So user dont need to write in anything, all the answers will be prewritten.



I heard, using Microsoft Setup manager we can generate Setup.iss files to automate the silent install of SQL Server. But I cant find information about how to implement and where can I find this tool.



My main motive is to save my client from installation questions of SQL Server.



One version of my application uses SQL Server 2005 Express and another one uses Standard version.



Please help and guide me.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved