0

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?

Mihai Limbășan
  • 64,368
  • 4
  • 48
  • 59
Rob Hunter
  • 2,787
  • 4
  • 35
  • 52

2 Answers2

3

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
  • 4,990
  • 2
  • 21
  • 28
0

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
  • 16,870
  • 3
  • 25
  • 32