Hello I am trying to configure SQL Server 2005 Express after Installshield Install. I am trying to set named pipes to enabled and TCPIP to enabled plus the port number for a SQL Server 2005 Express inmstallation. I do not want my non techi users to have to do anything manually except for insert a CD. I am told that Installshield does not allow thhese properties to be set. Has asnyone done this after installation using an API , program or an alternatibe solutions for me please?

0 Comments   [ + ] Show Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


SQL 2005 Express can be installed via a silent setup (see appdeploydatabase) in which you can specify the "DISABLENETWORKPROTOCOLS=0" parameter, which would enable both named pipes and tcp/ip. The port cannot be set via the silent install parameter unfortunately. You can add a script (or edit the vendor msi in SQL) to use a registrykey to change the port:
[left]See: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2181271&SiteID=1[/left][left] [/left]
Answered 09/30/2008 by: Lindeberg IT
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity