Enable TCP/IP Protocol from command line RRS feed

  • Question

  • Hi all,

    My very first post because I can't seem to find what I'm looking for on here or on the Internet at large.  

    However, if one is hosting an Express dB on W2K3 server, does anyone know a command line equivalent of:
    Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server > SQL Server Configuration Manager > SQL Server 2005 Network Configuration > Protocols for <instance> > TCP/IP Enable?

    Thanks in advance!
    Monday, September 21, 2009 5:31 PM


All replies

  • Have you had a look at the KB article 839980
    Thanks, Leks
    Monday, September 21, 2009 9:30 PM
  • Thanks Leks, I'll check it out later tonight.  However, at first glimpse, it does not appear to be what I'm after.  Your reference guides to the Windows Firewall service.  Is this what the configuration item in my above post does -- just letting SQL Express through the firewall?

    Wednesday, September 30, 2009 4:43 PM
  • Hi all,

    Another first post... I wonder if you managed to configure TCP for SQL Server by command line. I'm working on a distributable product having SQL Server Express, and i need to create an instance by command line having TCP enabled. Any suggestions?

    Tuesday, February 2, 2010 5:45 PM
  • hi,
    in addition to Leks, you can perhaps have a look at http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx, for command line parameter list to enable/disable install settings as long for installable features..
    for SQLExpress 2005 you can specify the DISABLENETWORKPROTOCOLS=0 setting to enable instance listening on installed network protocols ..
    for SQLExpress 2008 you can fine grane the setting,  http://msdn.microsoft.com/en-us/library/ms144259.aspx, specifying /TCPENABLE=1 to enable TCP protocol only..
    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools
    Tuesday, February 2, 2010 11:37 PM