October 16, 2006 at 7:58 am
How can we set the parameter DISABLENETWORKPROTOCOLS to 1 or 0 "after" SQL Server Express has already been installed? The reason its needed is partially for security purposes. I only want it enabled (0) just before the database update routine. Afterwards we want to set it back to 1. I've seen the different parameters from using /? but I don't see in there a way to set/change parameters.
Please help.
October 17, 2006 at 7:30 pm
You can use the Surface Area Configuration tools to set the remote network protocols
October 19, 2006 at 8:33 am
Max,
Do you know how to change the setting from the "command line" or by using a stored procedure?
I'd like for my application to manipulate this setting (DISABLENETWORKPROTOCOLS) so that it can turn it on, update the local from SQL Server recs, and then turn it back off. Thanks. LG.
May 29, 2007 at 9:15 am
Max or lg,
If either of you have figured out the answer to this, I would love to hear about it.
It's astonishing to me that Microsoft doesn't seem to have figured out that people still write scripts, and thus need to be able to do things from the command prompt. Finding documentation on how to modify network access form the surface configuration manager is easy. Finding documentation about how to do it from the command prompt is impossible.
Thanks,
--dave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply