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?

Thanks
Kerrin

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

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

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