May 16, 2003 at 4:23 pm
I had an earlier install of MSDE 1.0 with my database (test.mdf and test.ldf) in C:\MyDir.
This had a SQL Authentication.
Userid =sa
Pwd = <blank>
After i did an upgrade to MSDE 2000 SP3 using this switch
/a /qn UPGRADE=1 UPGRADEUSER=sa UPGRADEPWD= SECURITYMODE=SQL SAPWD=demo
i find that,
1. it does not create the new password i.e. demo
2. the original files (test.mdf and test.ldf) are not getting attached.
(i need to execute the sp_attach procedure to later attach it).
Am I missing something?
Thanks in advance..
March 18, 2004 at 9:32 am
I have not checked this out but do you need to put the blank password in single or double quotes?
UPGRADEPWD='' or UPGRADEPWD=""
It is possible it is not picking up you blank password correctly.
Also try setting the sa password to something and then putting that value in as a variable.
Good luck
March 18, 2004 at 9:36 am
Just found this on another item on this site:
blanksapwd=1
I think you use this instead of upgradepwd
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply