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
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.
Could someone tell me what a silent inatallation is please?
Many thanks
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
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
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.
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
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].....
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!!
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
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
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
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.
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?
I have an application written in C#, which allows the user to load their destination schema (in xml format) and writer their transformation expressions either in VBScript or in T-SQL. It uses DTS to do the ETL job.
Everything works great except with one problem. If there is a hypen ("-") in any of the destination attributes, the transformation fails with syntax error. It happens only with VBScript.
Here is my transformation:
"Function Main()
DTSDestination("Field-1") = #01/01/2004#
End Function"
If I replace the hypen with underscore, it works without any problem.
Does anyone have any idea about this problem?
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
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
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.
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
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.
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
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.
TIA,
Jayyde
How do i get my server to run a vbscript (yet to be created but i guess it will be in a DTS package???) when an insert runs on a table?
We need to analyse the browser versions hitting our intranet and catch the ones that are too old (earlier than IE5.5). I have the asp inserting a row with the IP address of the browser but i need to run a command line query to get the machine name from DNS (nslookup 111.222.333.444). This nslookup can be run from a vbscript.
Do i need to used a stored procedure in the process somewhere?
any thoughts welcomed
I am trying to write a DTS package at work that uses a loop to fire a query off against a different server/database at each loop iteration. Prior to the execute SQL task , I use ActiveX (VBScript) to change the Catalog and DataSource of the connection (created by drag and drop if icon). My Execute SQL task selects @@servername and getdate() just as a dummy query to make sure I am actually pointed at a different server.
While testing the properties of the connection using global variables and msgbox shows that the database (catalog) and server (data source) ip address is being changed, the result returned is always from the first server. I feel like I need to disconnect the connection object, change the parameters and then reconnect to the new server but there doesn't appear to be anyway to do this.
Anyone out there able to successfully change a connection object inthis manner??
I am trying to call a VB script file with the following command,
xp_cmdshell 'cscript c:file.vbs'
But its giving the following output -
Microsoft (R) Windows Script Host Version 5.1 for Windows
Copyright (C) Microsoft Corporation 1996-1999. All rights reserved.
NULL
Input Error: Can not find script file "c:file.vbs".
NULL
------------
If i changed the command to
xp_cmdshell 'cscript c:file.vbs'
it gives the folowing error -
Input Error: Can not find script file "C:WINNTsystem32file.vbs".
Actually my main intention is to call a url from the sql server where '
i can pass some value. Plz let me know if its the right step and whts
going wrong.
Thanks & regards,
-dkoushik
im writing a DTS package and i have am using vbscript to check if a file exists on an ftp server.
I can't figure out how to make my process sleep b/t checks on if the file exists.
in vb u can just
Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
but i cant seem to find a counterpart in vbscript.
thanks in advance,
pete
I have an SQL job that runs a .vbs script. It has the following code:
Cmd2.ActiveConnection = Conn2
Cmd2.CommandText = "USE msdb EXEC sp_update_job @job_name = 'Email Download',@enabled = 0"
Cmd2.CommandType = 1
Cmd2.Execute()
It's not disabling the job. If I execute in Query Analyzer, it works. I'm thinking it might be a permissions issue. Any suggestions?
TIA
I'm trying to run a TQSL script against a SQL Server 2000 database using SQL-DMO and Vbscript. The output of this query would be use to populate a table in another SQL Server database on a different server. Has anyone use SQL-DMO to connect SQL Server and run a t-sql script against a database and use the output to populate a table on a different server? Any informatiom would be helpfull.
Regards
Magictech
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.
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
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
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=???????