We're trying to get our clients to upgrade from MSDE 2000 to SQL 2005 Express silently without them having to do anything. We're getting stuck because the instilation keeps failing saying it can't login as administrator. We have disabled the administrator account in MSDE as we don't want our clients to have acsess to the database and the built in administrator account was posing a security threat. As a result we're specifying the SQL authentication information through the use of the template file. If we go through the install manually it runs fine. We've provided all the correct login information in the template file (shown below) but it still fails trying to login as administrator. I know we're missing something in the template file here but i can't find anything online about it and we've all gone through it about 5 times.... I know it's gonna end up being something stupid though... [:@]

Any help would be greatly greatly appriciated.

Here's the current one we're trying, we've added a lot too it, maybe too much.. not sure anymore [:-]

[Options]
ADDLOCAL=SQL_Engine
INSTANCENAME=MYPLACE
UPGRADE=SQL_Engine INSTANCENAME=MYPLACE
RSUPGRADEDATABASEACCOUNT=SA
RSUPGRADEPASSWORD=*****
SQLACCOUNT=sa
SQLPASSWORD=*****
SQLAUTOSTART=1
SECURITYMODE=SQL
SAPWD=*****
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

Answer this question or Comment on this question for clarity