dbTalk Databases Forums  

Remote installation option missing in SQL?

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Remote installation option missing in SQL? in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Prakash Heda
 
Posts: n/a

Default Remote installation option missing in SQL? - 08-04-2009 , 11:33 AM






I am using unuttended install for a while for single machines, My current
requirement is to install SQL 2008 on 75 enviornment from SQL 2005 side by
side upgrade...

I am thinking of using remote installation since all these boxes are on same
doamin, in SQL 2005 I have read about remote installation supported (see
below link), but in 2008 I am not able to find any method supported for the
same...

--------------------------------------------------------------------------------------------------------------------------------
http://www.sqlservercentral.com/arti...rver2005/1943/
Extract:
One of the other cool things I want to mention is support for Remote
Installation. Via the command line you can enter parameters for the
destination computer, with admin account and password. If you’ve ever had to
deal with image-based deployment of SQL Server on multiple machines, based on
your predefined installation, you most likely ran into the headache of having
to manually change the server name. Well, now upon immediate completion of
installation, SQL Server will check if the computer name has changed, and
update this automatically. Moreover, the need to run setup to reset the
computer name is eliminated – simply change the name, restart the service,
and update the sysservers table using sp_dropserver/sp_addserver.
--------------------------------------------------------------------------------------------------------------------------------

Anybody know what happened? is remote installation feature depriciated in
SQL 2008? orit was not there at all?


Prakash Heda
Sr Database Infrastructure Consultant

Reply With Quote
  #2  
Old   
Richard Mueller [MVP]
 
Posts: n/a

Default Re: Remote installation option missing in SQL? - 08-04-2009 , 11:58 AM






"Prakash Heda" <Prakash Heda (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am using unuttended install for a while for single machines, My current
requirement is to install SQL 2008 on 75 enviornment from SQL 2005 side by
side upgrade...

I am thinking of using remote installation since all these boxes are on
same
doamin, in SQL 2005 I have read about remote installation supported (see
below link), but in 2008 I am not able to find any method supported for
the
same...

--------------------------------------------------------------------------------------------------------------------------------
http://www.sqlservercentral.com/arti...rver2005/1943/
Extract:
One of the other cool things I want to mention is support for Remote
Installation. Via the command line you can enter parameters for the
destination computer, with admin account and password. If you’ve ever had
to
deal with image-based deployment of SQL Server on multiple machines, based
on
your predefined installation, you most likely ran into the headache of
having
to manually change the server name. Well, now upon immediate completion of
installation, SQL Server will check if the computer name has changed, and
update this automatically. Moreover, the need to run setup to reset the
computer name is eliminated – simply change the name, restart the service,
and update the sysservers table using sp_dropserver/sp_addserver.
--------------------------------------------------------------------------------------------------------------------------------

Anybody know what happened? is remote installation feature depriciated in
SQL 2008? orit was not there at all?


Prakash Heda
Sr Database Infrastructure Consultant

This link documents all parameters to install SQL Server 2008:

http://msdn.microsoft.com/en-us/library/ms144259.aspx

I think you want to use:

/TCPENABLED=1
/NPENABLED=0

This enables TCP and disabled Named Pipes. Note that
/DISABLENETWORKPROTOCOLS is not supported.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

Reply With Quote
  #3  
Old   
Prakash Heda
 
Posts: n/a

Default Re: Remote installation option missing in SQL? - 08-04-2009 , 12:32 PM



this link suggests for local or cluster installation and about unuttended
install...its not talking about using remote installation where I can specify
destination computer to install?

"Richard Mueller [MVP]" wrote:

Quote:
"Prakash Heda" <Prakash Heda (AT) discussions (DOT) microsoft.com> wrote in message
news:B81562F3-7985-48A3-9A2A-048FAB58E347 (AT) microsoft (DOT) com...
I am using unuttended install for a while for single machines, My current
requirement is to install SQL 2008 on 75 enviornment from SQL 2005 side by
side upgrade...

I am thinking of using remote installation since all these boxes are on
same
doamin, in SQL 2005 I have read about remote installation supported (see
below link), but in 2008 I am not able to find any method supported for
the
same...

--------------------------------------------------------------------------------------------------------------------------------
http://www.sqlservercentral.com/arti...rver2005/1943/
Extract:
One of the other cool things I want to mention is support for Remote
Installation. Via the command line you can enter parameters for the
destination computer, with admin account and password. If you’ve ever had
to
deal with image-based deployment of SQL Server on multiple machines, based
on
your predefined installation, you most likely ran into the headache of
having
to manually change the server name. Well, now upon immediate completion of
installation, SQL Server will check if the computer name has changed, and
update this automatically. Moreover, the need to run setup to reset the
computer name is eliminated – simply change the name, restart the service,
and update the sysservers table using sp_dropserver/sp_addserver.
--------------------------------------------------------------------------------------------------------------------------------

Anybody know what happened? is remote installation feature depriciated in
SQL 2008? orit was not there at all?


Prakash Heda
Sr Database Infrastructure Consultant


This link documents all parameters to install SQL Server 2008:

http://msdn.microsoft.com/en-us/library/ms144259.aspx

I think you want to use:

/TCPENABLED=1
/NPENABLED=0

This enables TCP and disabled Named Pipes. Note that
/DISABLENETWORKPROTOCOLS is not supported.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.