Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

customize template.ini to upgrade from msde to express edition?

Status
Not open for further replies.

hvisionexpo

Programmer
Apr 19, 2005
43
US

I need to create the script to upgrade the current named instance of sql server 2000 desktop engine to sql server 2005 express edition. I am having difficulty preparing the template.ini and would appreciate help.

When i use this template.ini it logs an error that this instance already exists and fails the instance upgrade.

1. named instance (MY_INSTANCE) of msde 2000 is already installed
2. uses sql authentication, sa user/password = sa/mve
3. tcp/ip is enabled



content of template.ini


ADDLOCAL=All
UPGRADE=All
INSTANCENAME=MY_INSTANCE
SQLACCOUNT=sa
SQLPASSWORD=mve
UPGRADEUSER=sa
UPGRADEPWD=mve
SQLBROWSERACCOUNT=
SQLBROWSERPASSWORD=
AGTACCOUNT=
AGTPASSWORD=
ASACCOUNT=
ASPASSWORD=
RSACCOUNT=
RSPASSWORD=
SQLBROWSERAUTOSTART=0
SQLAUTOSTART=1
AGTAUTOSTART=0
ASAUTOSTART=0
RSAUTOSTART=0
SECURITYMODE=SQL
SAPWD=mve
DISABLENETWORKPROTOCOLS=0
ENABLERANU=1



THANKS





 
updated template.ini contents:

[Options]
INSTANCENAME=MY_INSTANCE
SQLBROWSERACCOUNT=NT AUTHORITY\NETWORK SERVICE
SECURITYMODE=SQL
SAPWD=music
UPGRADE=SQL_Engine
SQLBROWSERAUTOSTART=1
RSCANINSTALLDEFAULT=0
RSCONFIGURATION=FilesOnly
RSSQLLOCAL=0

I get an error that this file is invalid..Any clues? I am trying to upgrade existing instance of msde 2k to sql express 2005 and uses sql authentication
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top