SQLExpress - command line

[K1pp3r]

Hi
Due to the need for Vista compatibility !! I'm having to redo my data to SQLExpress. This is for a standalone demo version of our product, everything else still retrieves it's data from the internet. Previously I've used MSDE2000A, with the normal command line options. The problem seems to arise because I have to attach a pre-populated database, database is installed in the instance data directory, and I run a script at the end of the install to attach the db, add a login and add a user. All is fine until add a user, doesn't report an error but doesn't succeed because the database is seen as read only, can't apply read_write because then we get into all sorts of file not found etc errors. Same applies when trying the equivalent in SSMSE. I think I've tracked this down to the command line install always setting the service logon to "NETWORK SERVICE", when this is changed (through configuration manager) to "LOCAL SYSTEM" everything proceeds correctly.

So at last my question is, having attempted to modify the command line parameters in the plug in options (setting SQLACCOUNT etc) and getting no success I was wondering if anybody has come across this and is there a known solution, because currently I am becoming even more follicly challenged due to excess banging of heads on wall !!!

Thanks in advance

[arupkrdas]

Look at this link, this might help u.


http://msdn2.microsoft.com/en-us/library/ms144259.aspx

You have to define these options

SQLACCOUNT="NT AUTHORITY\\SYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITY\\SYSTEM"
SQLBROWSERAUTOSTART=1

Hope this helps....