I am trying to create an unattended install of MSDE 2000 sp3a that will set the default tcp port to something other than 1433. I am using a setup.ini file and have tried the following with out any success - any ideas would be great! Thanks
[Options]
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
[SdServerNetwork-0]
TCPPort=1433
hi Kelly
"Kelly" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:D1F4F952-218E-46F9-BF44-ED0F083F0AAD@.microsoft.com...
> I am trying to create an unattended install of MSDE 2000 sp3a that will
set the default tcp port to something other than 1433. I am using a
setup.ini file and have tried the following with out any success - any ideas
would be great! Thanks
> [Options]
> SECURITYMODE=SQL
> DISABLENETWORKPROTOCOLS=0
> [SdServerNetwork-0]
> TCPPort=1433
the MSDE 2000 setup boostrapper does not support TCP/IP port redirecting
the
[SdServerNetwork-0]
TCPPort=1433
parameter you provided is only valid for a full blown SQL Server unattended
installations and not for MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea!
What is the best method to change the tcp port after MSDE has been installed on the client machine?
Is it acceptable to modify the TcpPort via the registry:
HKLM\Software\Microsoft\MSSQLServer\SuperSocketNet Lib\Tcp
|||hi Kelly,
"Kelly" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:36ACB0E9-2A4E-45A1-A0A3-C430B364D324@.microsoft.com...
> Thanks Andrea!
> What is the best method to change the tcp port after MSDE has been
installed on the client machine?
> Is it acceptable to modify the TcpPort via the registry:
> HKLM\Software\Microsoft\MSSQLServer\SuperSocketNet Lib\Tcp
this can be a viable solution as, in order to install MSDE, admin privileges
are required, so you have access to the full registry, but remember you have
to modify that value using the Client Network Utility on all clients...
as regard the server, please have a look at
http://support.microsoft.com/?kbid=823938
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for all of your help
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment