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