Configure Named Pipes for Sql 2005
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
Thanks
Kerrin
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
Lindeberg IT
15 years ago
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]
[left]See: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2181271&SiteID=1[/left][left] [/left]
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.