changing the default port on a clustered 2005 server.

I am unclear as to which Ip address to change the standard port on. When setting up a cluster you have multiple IP address's including the nic that is used for the heartbeat. I have not found any documention on how to change both nodes to listen on a port other than 1433..

Any help would be greatly appreciated.

Set the one titled "IPAll" (you may need to scroll to the bottom of the list). The clustered SQL Server instance will apply it to the actual IP addresses of the cluster.

changing the default port on a clustered 2005 server.

I am unclear as to which Ip address to change the standard port on. When setting up a cluster you have multiple IP address's including the nic that is used for the heartbeat. I have not found any documention on how to change both nodes to listen on a port other than 1433..

Any help would be greatly appreciated.

Set the one titled "IPAll" (you may need to scroll to the bottom of the list). The clustered SQL Server instance will apply it to the actual IP addresses of the cluster.

Changing data directory

How to change data directory for all databeses including system ones
(master, temdb etc.)
Can't do it by update sysfiles because (I can't figure why) this object
cannot be modified -
Regards
Piotr
Inidivisual database names can be changed via detaching and attaching,
chaging the path of the system databases needs a registry hack for that,
because the service will start them.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"piotr" <ksswd@.poczta.fm> schrieb im Newsbeitrag
news:eqXDppacFHA.2736@.TK2MSFTNGP12.phx.gbl...
> How to change data directory for all databeses including system ones
> (master, temdb etc.)
> Can't do it by update sysfiles because (I can't figure why) this object
> cannot be modified -
> Regards
> Piotr
>
|||In the registry I can only change master database path and I can't detach
model, tempdb nor msdb databases
Piotr
Uytkownik "Jens Smeyer"
<Jens@.Remove_this_For_Contacting.sqlserver2005.de> napisa w wiadomoci
news:%23YK9K2acFHA.2756@.tk2msftngp13.phx.gbl...
> Inidivisual database names can be changed via detaching and attaching,
> chaging the path of the system databases needs a registry hack for that,
> because the service will start them.
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "piotr" <ksswd@.poczta.fm> schrieb im Newsbeitrag
> news:eqXDppacFHA.2736@.TK2MSFTNGP12.phx.gbl...
>
|||hi Piotr,
piotr wrote:
> In the registry I can only change master database path and I can't
> detach model, tempdb nor msdb databases
>
please have a look at http://support.microsoft.com/kb/224071/EN-US/
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Finally made it, thanks a lot.
Uytkownik "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> napisa w
wiadomoci news:3has31Ffpu70U1@.individual.net...
> hi Piotr,
> piotr wrote:
> please have a look at http://support.microsoft.com/kb/224071/EN-US/
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>