Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Marketware
Starting Member
9 Posts |
 Posted - 2010-04-23 : 12:36:07
|
| I am trying to install 2005 Express to a local PC as part of our installation program. In a batch file I have the following command:SQLEXPR.EXE /qb INSTANCENAME=SQLEXPRESS ADDLOCAL=SQL_Engine SECURITYMODE=SQL SAPWD=Pa$$word1 SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE"When I run it from a batch file it works fine. I'm trying to run this in an Installshield install as a prerequiste and I get a message that the Service won't start. When I leave outSQLACCOUNT="NT AUTHORITY\LOCAL SERVICE", it installs fine, but when I try to restore some databases I get errors (I really need it to run as a local service to get these demo databases restored.)Is there a script, batch file, etc. that I can run that will switch it from the default "NT AUTHORITY\SYSTEM" to LOCAL SERVICE. I'll probably need to stop the service change the authority and then restart the service in the script/batch.Thanks.bob bartel |
|
|
|
|
|
Setting up service, etc.