November 6, 2008 at 3:52 am
[font="Times New Roman"]Is there any one who can help me in installition of sql server 2005 with unattended installition. We have built in files in sql 2000 but this sql 2005 have only exe file. So pls help me.[/font] :angry:
November 6, 2008 at 5:08 am
i found this link with a simple search:http://www.alpesh.nakars.com/blog/unattended-sql-server-2005-installation/
i also second guessed that by unattended installation, you might have meant "install sql2005 with my application"
which you can get more info here: http://www.codeproject.com/KB/applications/NET_Installer_With_SQLEXP.aspx
Lowell
November 6, 2008 at 11:16 pm
I have tried your link and i was very happy that its working but at the end its throughing error. While installing database server. Its installing native client and other service. When it comes for xml... something will come and then error will come. So is there any one to resolve the issue?
November 6, 2008 at 11:19 pm
Shripad (11/6/2008)
[font="Times New Roman"]Is there any one who can help me in installition of sql server 2005 with unattended installition. We have built in files in sql 2000 but this sql 2005 have only exe file. So pls help me.[/font] :angry:
supply the necessary information.
the critical area is when you are asked for the mixed mode or sql mode authentication. make your choice here and carry on
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 8, 2008 at 4:24 am
Here is my Template.ini file, i have modified template.ini file.
So you can check the same by executing If there is any error then pls
tell me how to resolve as early as possible.
[Options]
USERNAME="My Username"
COMPANYNAME="My Company Ltd"
;--------------------------------------------------------------------
; INSTALLSQLDIR specifies the location for the instance specific binary files.
; Default location is: %ProgramFiles%\Microsoft SQL Server; To use the default path, do not specify the following parameter.
INSTALLSQLDIR=
;--------------------------------------------------------------------
; INSTALLSQLSHAREDDIR specifies a custom location for Integration Services
; Notification Services, Client Components, SQL Server Books Online and Samples.
; To use the default path, do not specify the following parameter. Default path is %ProgramFiles%\Microsoft SQL Server
INSTALLSQLSHAREDDIR=
;--------------------------------------------------------------------
; INSTALLSQLDATADIR specifies the location for the SQL Server data files.
; Default: INSTALLSQLDIR\Data; To use the default path, do not specify the following parameter.
INSTALLSQLDATADIR=
;--------------------------------------------------------------------
; ADDLOCAL specifies which components to install. If ADDLOCAL is not
; specified, setup will fail.
; To install all components specify 'ADDLOCAL=ALL' on the command line.
ADDLOCAL=All
;--------------------------------------------------------------------
; INSTANCENAME is REQUIRED; for a default instance use MSSQLSERVER
; For shared components (IS, NS and client components) INSTANCENAME is not required.
INSTANCENAME=MSSQLSERVER
;--------------------------------------------------------------------
; The services for SQL Server and Analysis Server are set auto start. To use the *ACCOUNT settings
; make sure to specify the DOMAIN, e.g. SQLACCOUNT=DOMAINNAME\ACCOUNT
; NOTE: When installing SQL_Engine 3 accounts are REQUIRED: SQLACCOUNT, AGTACCOUNT and SQLBROWSERACCOUNT.
SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE"
;--------------------------------------------------------------------
; To use the *AUTOSTART features, specify 1 to start automatically or 0 to start manually.
; NOTE: If you decide to start SQL Agent automatically, then SQL is also started automatically.
; If *AUTOSTART is not specified on the command line, startup is set to manual.
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=0
;--------------------------------------------------------------------
; To use Mixed mode authentication, use SECURITYMODE=SQL.
; If SECURITYMODE=SQL is not specified, then Windows Authentication only will be used by default.
; If you use SQL Authentication, you are REQUIRED to provide a strong system administrator (SA) password.
; If you use Windows Authentication, the SA account will be disabled.
; To set SA password specify SAPWD.
SECURITYMODE=SQL
SAPWD=password123#
;--------------------------------------------------------------------
; The DISABLENETWORKPROTOCOLS switch is used to disable network protocol for SQL Server instance.
; Set DISABLENETWORKPROTOCOLS = 0; for Shared Memory= On, Named Pipe= On, TCP= On
; Set DISABLENETWORKPROTOCOLS = 1; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= Off
; Set DISABLENETWORKPROTOCOLS = 2; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= On
; Note: DISABLENETWORKPROTOCOLS if not specified has the following defaults.
; Default value for SQL Server Express/Evaluation/Developer: DISABLENETWORKPROTOCOLS =1
; Default value for Enterprise/Standard /Workgroup: DISABLENETWORKPROTOCOLS =2
DISABLENETWORKPROTOCOLS=0
;--------------------------------------------------------------------
; The ENABLERANU switch is used to configure Run as Normal User (User Instances).
; Set ENABLERANU = 0 to turn User Instances off.
; Set ENABLERANU = 1 (default) to turn User Instances on.
; Note: User Instances only apply to SQL Server Express SKUs.
ENABLERANU=0
;--------------------------------------------------------------------
; The ADDUSERASADMIN switch is used to add the setup user to the
; SQL Server 2005 System Administrator role. Members of the
; System Administrator role can perform any activity in the server.
; Set ADDUSERASADMIN=1 to add the setup user to the SQL Server System Administrator role
ADDUSERASADMIN=0[/color]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply