Is there any way to install SQL Express 2005 silently while configuring to allow remote access, or must the configuration be done with the SQL Server Management Studio UI?
A:
One of the issues is setting BROWSERSVCSTARTUP to automatic. Check BOL, in case I have the flag typed in incorrectly. I will have to mull over this a bit and determine if this is the only issue in the mix.
Gregory A Beamer
2009-02-26 20:02:48
+1
A:
After the SQL Service is installed log into the database and run the following and then restart the SQL Service.
exec sp_configure 'remote access', 1
reconfigure
This will allow remote access to the service. If you are installing a named instance you'll need to ensure that the SQL Browser service is running and set to automatic.
mrdenny
2009-03-09 08:25:03