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


ADVERTISEMENT

How To Build A Own Silent Setup Of MS-SQL-Server 2005 Express For Installation On Customers PC ...

Feb 21, 2008

Hi,

I want to build a silent setup/installation of MS-SQL-Server-Express 2005 for installation on customers computers.
I want to integrate it in my own setup/installation routine of my application.
How can I do that?
Where can I get Infos or tutorials? Perhaps here ?

Sorry for my bad english

Regards Tron

View 7 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

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 Via Vbscript

Aug 21, 2007


Hi..
i am new to vbscripting.i need to create the vbscript for
( .netframework2.0,MDAC2.7,XML4.0,VC++2005,windowsinstaller3.0,OWC10)
with silent installation via VBscript.before that i need to check the
machine have my pre-requisites or not,which machine does not have my
pre-requisites through script i have to install.
Kindly provide any solution for this.you can reach me at
senthil...@tcs.com.
thanks,
N.senthil

View 1 Replies View Related

Silent Installation Setup Problem

Feb 19, 2007

Hi,

I'm trying to create a silent installation which will create a new instance of the express version
on my clients machine, the problem is that i can't set the service account to local service

i.e AGTACCOUNT="NT AUTHORITYLOCAL SERVICE"

if im running the normal setup (GUI) i can set this property easly,
but from the command line all i get is
"NT AUTHORITYLOCAL SYSTEM" which is the default i think

how can i do it from the command line???

Thanks

View 8 Replies View Related

2014 Silent Installation Not Working (windows 7)

Dec 23, 2014

I tried SQL server 2014 express edition for Silent installation using the below procedure. The process got exited without completion in few minutes.

Command used for silent installation is

SQLEXPRADV_x86_ENU /q ConfigurationFile="ConfigurationFile.ini"

Created Configuration File Manually: Below is the File Data

;SQLSERVER2008 Configuration File
[SQLSERVER2008]
IACCEPTSQLSERVERLICENSETERMS="True"

; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will reflect the instance ID of the SQL Server instance.

INSTANCEID="SHAREPOINT"

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.

ACTION="Install"

; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, and Tools. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, Business Intelligence Development Studio, and other shared components.

FEATURES=SQLENGINE,REPLICATION

; Displays the command line parameters usage

HELP="False"

; Specifies that the detailed Setup log should be piped to the console.

INDICATEPROGRESS="False"

; Setup will not display any user interface.

QUIET="True"

; Setup will display progress only without any user interaction.

QUIETSIMPLE="False"

; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system.

X86="False"

; The directory for the extracted service pack files used to update the setup media.

PCUSOURCE="d:d8ad8f24d77c0777a5PCUSOURCE"

; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature.

ERRORREPORTING="False"

; Specify the root installation directory for native shared components.

INSTALLSHAREDDIR="C:Program FilesMicrosoft SQL Server"

; Specify the root installation directory for the WOW64 shared components.

INSTALLSHAREDWOWDIR="C:Program Files (x86)Microsoft SQL Server"

[code].....

View 1 Replies View Related

Silent Installation - SQL 2000 Reporting Services

Feb 14, 2008



Hi,
I'm trying to install SQL 2000 Server Reporting Services silently.

I've read that I need to customize template.ini file. This is my file:

[Options]
USERNAME=user
COMPANYNAME="Company Name"
PIDKEY=*******************************
INSTALLDIR="C:Program FilesMicrosoft SQL Server"
;Components to install
ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS_BooksOnline_EN
RSACCOUNT=
RSPASSWORD=
RSAUTOSTART=1
RSVIRTUALDIRECTORYSERVER=ReportServer
RSVIRTUALDIRECTORYMANAGER=
RSREDIRECTTOMANAGER=0
RSUSESSL=1
RSDATABASESERVER=
RSDATABASENAME="ReportServer"
RSDATABASEFILELOCATION=
RSDATABASELOGFILELOCATION=
RSSQLACCOUNT=
RSSQLPASSWORD=
RSSETUPACCOUNT=
RSSETUPPASSWORD=
PERSEAT=1



I don't know if I missing something essencial or if I did it in a wrong way, but when I ran the installation from the command line, I get, after a while, a minimized window with "ERROR REPORTING" as title that I can't restore.

I could install it manually without problems (as a test). I've made ISS files for the SQL 2000 Server Developer Edition, but I couldn't for reporting services. Is this possible? Is there an error in my template.ini?

Thank you in advance!!

View 4 Replies View Related

Silent - Unattended Setup - Getting Informed About Running Installation Progress Status.

Apr 10, 2007

I 'm trying to install Sql Server 2005 Express Edition using c# 2.0 by starting a process and launching setup. I also want to informed about installation progress. For instance i want to inform end user if any installation error return or if setup has successfully completed etc. I think i need a callback... I have no problem about silent - unattended install but how can i informed about running installation progress ? and send these info to end user 's form ?

Regards.

Yusuf Incekara

View 5 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

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 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

Sql Server Express Setup Installs The Silent Instattion, Can This Be Customized

May 25, 2007

Hi!



I have created a setup in visual studio and set the sql server as a pre-requsites.



now when the setup is run from

setup.exe

it checks whether sql server is installed... if installed then continues otherwise install sql server express edition, now this installation is silent,



I need to set the sa password during installation of sql server . i have no option to set the password during installation, can any one help



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

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

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

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

SQl Server 2005 Installation Is Depend On Installation Of Visual Studio 2005?

Oct 2, 2006

Hi every one,

I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.

I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .

View 11 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

How To Start The MMSE In Silent Mode?

Mar 17, 2007

Hi all!

I'm making a custom unattended installation of SQL Server 2005 Express. I'm using WPI (Windows Post-Install) installing first Framework 2.0, then SQL 2005 Express and then I want tu ejecute some SQL sentences using SQLCMD. The problem is, that if I don´t start at least one time the Managament Studion Express, those sentences are not ejecuted.But, Why?
The first time you run the MMSE, you get a horizontal progress bar, telling you that MMSE is preparing for firt run.
Is there any way to automate this?

P.S. I'm starting the MSSQL service automatically using a template.ini.


Thank in advance,
RSP

View 1 Replies View Related

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 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

Silent Deployment: A Few Questions About Settings.ini File

Dec 13, 2007

I've read quite a few KB articles on deploying SQL Express silently using the command line and a .ini file. Unfortunately I still have some questions before I can make my own .ini file. This is for a local sql server.



What is the INSTANCENAME attribute meant to be? If it is different from the server installed on my local machine which I have coded the application on, would it be an issue?
What should USERNAME/SQLACCOUNT and SQLPASSWORD be? I can't remember having to setup these for the local database so I can't imagine what it's meant to be set as.
What is the PIDKEY?Thank you in advance.

View 1 Replies View Related

Run Querys After Silent Installtion SQL 2005 Express

Mar 1, 2006

Hi,

I'm looking for a solution to run querys (create databases ed) after a silent installation of SQL 2005 Express edition (example with a .sql file). So users can run a installation unattended with all databases installed and so on.

What I got is a document about how to run a silent installation (document " Using Command Prompt Options to install SQL Server Express") but this docs there's no solution how to run querys after the installation.

Thanks

Robert-Paul

View 4 Replies View Related

Extract SQLEXPRESS.exe Silent To An Custom Path?

Feb 7, 2008



SQLEXPRESS.exe /x --> opens an GUI where the target path should be selected

But is there any way to extract the files to an custom folder without GUI?

Best Regards

Sven

View 4 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







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