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 |
|
drh3010
Starting Member
18 Posts |
 Posted - 2007-08-30 : 11:48:07
|
| I'm new to database configuration so bear with me...How do you silently install SQL Server Express?Also, I need the server name to be MY_COMPANY_NAME instead of SQLEXPRESS. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-30 : 13:16:51
|
I think the setup application accepts some optionssetup /q or similar. Also read about the setup.ini file and the settings made there.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2007-09-02 : 06:23:46
|
There is a ton of command line options, and it is all to be found online (but at the moment I don't remember where), but here is what I use, just to get you started :)SQLEXPR(SP1)_ADV /qb ADDLOCAL=All INSTANCENAME=MSSQLSERVER SAPWD=p@ssword DISABLENETWORKPROTOCOLS=2 SECURITYMODE=SQL /qb makes it silent, wont ask user any questions.'ADDLOCAL=All' installs all services contained in the setup package (in this case the Express SP1 with advanced services).'INSTANCENAME=MSSQLSERVER' It will be a default instance (change MSSQLSERVER to your company name as you see fit)'SAPWD=p@ssword' 'sa' password will be 'p@ssword''DISABLENETWORKPROTOCOLS=2' TCP/IP will be enabled (omit if you dont want any netword protocols enabled as that is the default)'SECURITYMODE=SQL' Secutity mode is mixed mode (Windows and SQL)-- If you give someone a program, you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime. |
|
|
|
|
|
|
Help: How to silently install SQL Server Express?