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!
The SQL ERRORLOG shows: Error is 3414, Severity 21, State 2 and says: "An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting." Just prior to this, I get a warning: "did not see LP_CKPT_END".
Any thoughts why this might be and how I can fix this?
I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.
If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.
But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.
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.
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.
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.
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.
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
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.
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".
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?
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
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:
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"
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.
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.
I am a novice at working w/SQL and am trying to learn on my own... I download SQLExpress and installed it. However, I received a warning message that Internet Information Systems was not installed or enabled. I checked cpanel and it was not there. Figured out that I needed to check the windows components and attempted to enable it. I was asked for my XP Pro discs (which I can't find of course) in order to load admxprox.dll. How can I get a copy of that file so I can move forward???
I have the latest SQLEXPR and the Management Studio.
Management installed no problem.
I cannot install SQLEXPR due to beta versions of Visual Studio, etc. However this machine has been rebuilt with disk format and clean install of Windows XP Pro. No beta's of any kind on the machine.
Have latest version of Net 2, installed without error.
I installed SQLExpress with out error on other machines.
This morning I booted to a message "Unable to load SQLBOOT.DLL (hresult 0x8007007e). Uninstall and re-run setup." When I did the uninstall, I got a couple of error warnings re sqlboot.dll.
When trying to re-install, the install hangs up at MSXML6 with the message "Unable to find MSXM16.msi install package." I've looked at the files in the install directory and the .msi package is there. I've tried it twice with the same results.
I have XP with SP2. Install SQLExpress because I need test my system work in this plataform. The system used database in SQL Server. And try test uses SQLExpress.
The system work in my computer, I have not problem... but when the other client try to access to my computer...not the system. They cannot see me. I made ping to my computer this responsed, but in the other computer is not responed. The first instance had access, but when try access with the System the comunication lost. And now nobody can see my computer but i can see every one.
Check the access in secpol.msc in Local Policies | Access this computer form the network. And I have the group everyone, administrators.
Can the template.ini be setup to upgrade a previous version of MSDE if it exists or just install it if it does not?
I currently have ADDLOCAL=SQL_Engine and UPGRADE=SQL_Engine INSTANCENAME=MSSQLSERVER in the file but that does not seem to do it if the server does not exist.
Am I going to have to create two seperate ini files and tweak my install program to select the specific one or am I missing a simple step?
Because of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it.
I do have sql server 2005 developer's edition installed; is that the reason? and does that mean I cannot have both installed on the same machine?
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?
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.
