Add-in for SQL Server Mnagement Studio 2005

Hi,
I notice that a few third party SQL Server tool developers (RedGate
for example) have started to sell utilities that appear as add-ins
to
SQL Server Management Studio 2005 (with additional menu's and
dialogs).
I cant find any documentation on how you do this. Is it an
unsupported hack ? If so, can anyone point me in the right direction
on how I would work out how to do this.
(Sorry for the cross post, I posted the same message in
microsoft.public.sqlserver.server by mistake).
Thanks in advance,
Matt
Asked and answered in .server. Please refrain from multiposting.

Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
<matt_randle@.yahoo.com> wrote in message
news:1183902073.740953.145580@.22g2000hsm.googlegro ups.com...
> Hi,
> I notice that a few third party SQL Server tool developers (RedGate
> for example) have started to sell utilities that appear as add-ins
> to
> SQL Server Management Studio 2005 (with additional menu's and
> dialogs).
>
> I cant find any documentation on how you do this. Is it an
> unsupported hack ? If so, can anyone point me in the right direction
> on how I would work out how to do this.
> (Sorry for the cross post, I posted the same message in
> microsoft.public.sqlserver.server by mistake).
> Thanks in advance,
>
> Matt
>
|||Adam Machanic (amachanic@.IHATESPAMgmail.com) writes:
> Asked and answered in .server. Please refrain from multiposting.
Hey, he did after all say:
[vbcol=seagreen]
And this groups is certainly the appropriate one for the topic.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Ok. Thanks for your reply (in the other group). If I can work out
how to do it, ill put up a blog post explaining it. I notice that it
will be a supported feature in the next release of SSMS though so may
just wait for that.
Thanks.
On 8 Jul, 16:09, "Adam Machanic" <amacha...@.IHATESPAMgmail.com> wrote:
> Asked and answered in .server. Please refrain from multiposting.
> --
> Adam Machanic
> SQL Server MVP -http://sqlblog.com
> Author, "Expert SQL Server 2005 Development"http://www.apress.com/book/bookDisplay.html?bID=10220
> <matt_ran...@.yahoo.com> wrote in message
> news:1183902073.740953.145580@.22g2000hsm.googlegro ups.com...
>

Add a third node to a cluster

I have two node SQL Enterprise installed on a Windows 2003 cluster running
active -active. I would like to add a third node so that it would become 2
active and 1 passive . Is this feasible ?
Also , can someone tell me how can I make the third node standby for the
other two ? Do I have to install any binary and executable on the third node
/ modify the possible owner ?
Raymond
Look at "How to add nodes to an existing virtual server (Setup)" in BOL. It
gives a step by step on how to do it.
After you ran that, follow the steps in the Service Pack readme that you
have installed on the other nodes.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Norman" <raymond.chan@.hotmail.com> wrote in message
news:u7qvDXwYFHA.2288@.TK2MSFTNGP14.phx.gbl...
>I have two node SQL Enterprise installed on a Windows 2003 cluster running
>active -active. I would like to add a third node so that it would become 2
>active and 1 passive . Is this feasible ?
> Also , can someone tell me how can I make the third node standby for the
> other two ? Do I have to install any binary and executable on the third
> node / modify the possible owner ?
> Raymond
>
|||Norman
To control failover you can use the Preferred Owners List on the Group
Property sheets. However if you have a Windows 2003 Cluster you can implement
AntiAffintityClassNames to make absolutely certain that a node that is in a
passive role take ownership of a group in the event of a failure. See the
following KB for details on how to setup.
http://support.microsoft.com/default...;en-us;Q296799
Regards
CT
"Norman" wrote:

> I have two node SQL Enterprise installed on a Windows 2003 cluster running
> active -active. I would like to add a third node so that it would become 2
> active and 1 passive . Is this feasible ?
> Also , can someone tell me how can I make the third node standby for the
> other two ? Do I have to install any binary and executable on the third node
> / modify the possible owner ?
> Raymond
>
>

Add a third node to a cluster

Hy,
I have this problem, when I try from the setup wizard of sql 2000 to add the
new node-c the node is listed unavailable. I add the node-c to the cluster
group and function without problem with node-a and node-b, the sql 2000 in
node-a and node-b is function without problem, I not understand why the setup
sql 2000 give the node-c unavaiable to add!
Can anybody help me? sorry for the english!
Windows 2003 Server EE sp 1
SQL Server 2000 EE sp 3a
Server HP DL380
Bernardo
Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
NODE C with any information that might lead you in the direction as to why it
is listed as unavailable. Post what you find.
Regards
cT
"bernardo" wrote:

> Hy,
> I have this problem, when I try from the setup wizard of sql 2000 to add the
> new node-c the node is listed unavailable. I add the node-c to the cluster
> group and function without problem with node-a and node-b, the sql 2000 in
> node-a and node-b is function without problem, I not understand why the setup
> sql 2000 give the node-c unavaiable to add!
> Can anybody help me? sorry for the english!
> Windows 2003 Server EE sp 1
> SQL Server 2000 EE sp 3a
> Server HP DL380
|||15:59:39 Begin Setup
15:59:39 8.00.194
15:59:39 Mode = Normal
15:59:39 ModeType = NORMAL
15:59:39 GetDefinitionEx returned: 0, Extended: 0x0
15:59:39 ValueFTS returned: 1
15:59:39 ValuePID returned: 1
15:59:39 ValueLic returned: 1
15:59:39 System: Windows NT Enterprise Server
15:59:39 SQL Server ProductType: Enterprise Edition [0x3]
15:59:39 IsNTCluster returned: 1
15:59:39 Begin Action: SetupInitialize
15:59:39 End Action SetupInitialize
15:59:39 Begin Action: SetupInstall
15:59:39 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
15:59:39 CommonFilesDir=C:\Program Files\Common Files
15:59:39 Windows Directory=C:\WINDOWS\
15:59:39 Program Files=C:\Program Files\
15:59:39 TEMPDIR=C:\DOCUME~1\HYPHEN~1\LOCALS~1\Temp\1\
15:59:39 Begin Action: SetupInstall
15:59:39 digpid size : 256
15:59:40 digpid size : 164
15:59:40 Begin Action: CheckFixedRequirements
15:59:40 Platform ID: 0xf00000
15:59:40 Version: 5.2.3790
15:59:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2440
15:59:40 End Action: CheckFixedRequirements
15:59:40 Begin Action: ShowDialogs
15:59:40 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
15:59:40 Begin Action ShowDialogsHlpr: 0x1
15:59:40 Begin Action: DialogShowSdWelcome
15:59:46 End Action DialogShowSdWelcome
15:59:46 Dialog 0x1 returned: 1
15:59:46 End Action ShowDialogsHlpr
15:59:46 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:59:46 Begin Action ShowDialogsHlpr: 0x2
15:59:46 Begin Action: DialogShowSdMachineName
15:59:55 ShowDlgMachine returned: 1
15:59:55 Name = CLX-CLUSTER-SQL, Type = 0x20000008
15:59:55 GetCDKeyForThisVS returned: 0
15:59:55 Begin Action: CheckRequirements
15:59:55 Processor Architecture: x86 (Pentium)
15:59:55 Service Pack: 256
15:59:55 ComputerName: CLX-CLUSTER-C
15:59:55 User Name: hyphenadmin
15:59:55 IsAllAccessAllowed returned: 1
15:59:55 OS Language: 0x409
15:59:55 End Action CheckRequirements
15:59:55 This combination of Package and Operating System allows a full
product install.
15:59:55 End Action DialogShowSdMachineName
15:59:55 begin ShowDialogsUpdateMask
15:59:55 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
15:59:55 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
15:59:55 Dialog 0x2 returned: 0
15:59:55 End Action ShowDialogsHlpr
15:59:55 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:59:55 Begin Action ShowDialogsHlpr: 0x4
15:59:55 Begin Action: DialogShowSdInstallMode
15:59:57 ShowDlgInstallMode returned: 1
15:59:57 InstallMode : 0x20
15:59:57 End Action DialogShowSdInstallMode
15:59:57 begin ShowDialogsUpdateMask
15:59:57 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
15:59:57 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
15:59:57 Dialog 0x4 returned: 1
15:59:57 End Action ShowDialogsHlpr
15:59:57 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
15:59:57 Begin Action ShowDialogsHlpr: 0x8
15:59:57 Begin Action : DialogShowSdAdvanced
15:59:59 ShowDlgAdvanced returned: 1
15:59:59 Adv Install Mode = -2147483648
15:59:59 End Action : DialogShowSdAdvanced
15:59:59 begin ShowDialogsUpdateMask
15:59:59 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
15:59:59 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
15:59:59 Dialog 0x8 returned: 1
15:59:59 End Action ShowDialogsHlpr
15:59:59 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
15:59:59 Begin Action ShowDialogsHlpr: 0x4000
15:59:59 Begin Action: DialogShowSdVirtualServer
16:00:01 ShowDlgVirtualServer returned: 0
16:00:01 Ipaddress = 192.9.220.221,255.255.255.0,Lan Team
16:00:01 szNewList =
16:00:01 szModifiedList =
16:00:01 szRemovedList =
16:00:01 End Action DialogShowSdVirtualServer
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x4000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:00:01 Begin Action ShowDialogsHlpr: 0x8000
16:00:01 Begin Action : DialogShowSdDiskGroups
16:00:01 ShowDlgDiskGroups returned: 1
16:00:01 Disk Group = B - SQL CLUSTER Group
16:00:01 End Action : DialogShowSdDiskGroups
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x8000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:00:01 Begin Action ShowDialogsHlpr: 0x10000
16:00:01 Begin Action: DialogShowSdClusterDef
16:00:05 ShowDlgClusterDef returned: -1
16:00:05 ShowDlgClusterDef: GetLastError returned: 0
16:00:05 The operation completed successfully.
16:00:05 End Action DialogShowSdClusterDef
16:00:05 End Action ShowDialogs
16:00:05 Action CleanUpInstall:
16:00:05 StatsGenerate returned: 2
16:00:05 StatsGenerate (0x0,0x20,0xf00000,0x100,1033,0,0x0,0x20000008,0,0 ,0
16:00:05 StatsGenerate -1,hyphenadmin)
16:00:05 Installation Failed.
"Charles Tolento" ha scritto:
[vbcol=seagreen]
> Bernardo
> Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
> NODE C with any information that might lead you in the direction as to why it
> is listed as unavailable. Post what you find.
>
> Regards
> cT
> "bernardo" wrote:
|||This is the sqlstp.log
15:59:39 Begin Setup
15:59:39 8.00.194
15:59:39 Mode = Normal
15:59:39 ModeType = NORMAL
15:59:39 GetDefinitionEx returned: 0, Extended: 0x0
15:59:39 ValueFTS returned: 1
15:59:39 ValuePID returned: 1
15:59:39 ValueLic returned: 1
15:59:39 System: Windows NT Enterprise Server
15:59:39 SQL Server ProductType: Enterprise Edition [0x3]
15:59:39 IsNTCluster returned: 1
15:59:39 Begin Action: SetupInitialize
15:59:39 End Action SetupInitialize
15:59:39 Begin Action: SetupInstall
15:59:39 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
15:59:39 CommonFilesDir=C:\Program Files\Common Files
15:59:39 Windows Directory=C:\WINDOWS\
15:59:39 Program Files=C:\Program Files\
15:59:39 TEMPDIR=C:\DOCUME~1\HYPHEN~1\LOCALS~1\Temp\1\
15:59:39 Begin Action: SetupInstall
15:59:39 digpid size : 256
15:59:40 digpid size : 164
15:59:40 Begin Action: CheckFixedRequirements
15:59:40 Platform ID: 0xf00000
15:59:40 Version: 5.2.3790
15:59:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2440
15:59:40 End Action: CheckFixedRequirements
15:59:40 Begin Action: ShowDialogs
15:59:40 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
15:59:40 Begin Action ShowDialogsHlpr: 0x1
15:59:40 Begin Action: DialogShowSdWelcome
15:59:46 End Action DialogShowSdWelcome
15:59:46 Dialog 0x1 returned: 1
15:59:46 End Action ShowDialogsHlpr
15:59:46 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:59:46 Begin Action ShowDialogsHlpr: 0x2
15:59:46 Begin Action: DialogShowSdMachineName
15:59:55 ShowDlgMachine returned: 1
15:59:55 Name = CLX-CLUSTER-SQL, Type = 0x20000008
15:59:55 GetCDKeyForThisVS returned: 0
15:59:55 Begin Action: CheckRequirements
15:59:55 Processor Architecture: x86 (Pentium)
15:59:55 Service Pack: 256
15:59:55 ComputerName: CLX-CLUSTER-C
15:59:55 User Name: hyphenadmin
15:59:55 IsAllAccessAllowed returned: 1
15:59:55 OS Language: 0x409
15:59:55 End Action CheckRequirements
15:59:55 This combination of Package and Operating System allows a full
product install.
15:59:55 End Action DialogShowSdMachineName
15:59:55 begin ShowDialogsUpdateMask
15:59:55 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
15:59:55 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
15:59:55 Dialog 0x2 returned: 0
15:59:55 End Action ShowDialogsHlpr
15:59:55 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:59:55 Begin Action ShowDialogsHlpr: 0x4
15:59:55 Begin Action: DialogShowSdInstallMode
15:59:57 ShowDlgInstallMode returned: 1
15:59:57 InstallMode : 0x20
15:59:57 End Action DialogShowSdInstallMode
15:59:57 begin ShowDialogsUpdateMask
15:59:57 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
15:59:57 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
15:59:57 Dialog 0x4 returned: 1
15:59:57 End Action ShowDialogsHlpr
15:59:57 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
15:59:57 Begin Action ShowDialogsHlpr: 0x8
15:59:57 Begin Action : DialogShowSdAdvanced
15:59:59 ShowDlgAdvanced returned: 1
15:59:59 Adv Install Mode = -2147483648
15:59:59 End Action : DialogShowSdAdvanced
15:59:59 begin ShowDialogsUpdateMask
15:59:59 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
15:59:59 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
15:59:59 Dialog 0x8 returned: 1
15:59:59 End Action ShowDialogsHlpr
15:59:59 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
15:59:59 Begin Action ShowDialogsHlpr: 0x4000
15:59:59 Begin Action: DialogShowSdVirtualServer
16:00:01 ShowDlgVirtualServer returned: 0
16:00:01 Ipaddress = 192.9.220.221,255.255.255.0,Lan Team
16:00:01 szNewList =
16:00:01 szModifiedList =
16:00:01 szRemovedList =
16:00:01 End Action DialogShowSdVirtualServer
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x4000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:00:01 Begin Action ShowDialogsHlpr: 0x8000
16:00:01 Begin Action : DialogShowSdDiskGroups
16:00:01 ShowDlgDiskGroups returned: 1
16:00:01 Disk Group = B - SQL CLUSTER Group
16:00:01 End Action : DialogShowSdDiskGroups
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x8000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:00:01 Begin Action ShowDialogsHlpr: 0x10000
16:00:01 Begin Action: DialogShowSdClusterDef
16:00:05 ShowDlgClusterDef returned: -1
16:00:05 ShowDlgClusterDef: GetLastError returned: 0
16:00:05 The operation completed successfully.
16:00:05 End Action DialogShowSdClusterDef
16:00:05 End Action ShowDialogs
16:00:05 Action CleanUpInstall:
16:00:05 StatsGenerate returned: 2
16:00:05 StatsGenerate (0x0,0x20,0xf00000,0x100,1033,0,0x0,0x20000008,0,0 ,0
16:00:05 StatsGenerate -1,hyphenadmin)
16:00:05 Installation Failed.
"Charles Tolento" ha scritto:
[vbcol=seagreen]
> Bernardo
> Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
> NODE C with any information that might lead you in the direction as to why it
> is listed as unavailable. Post what you find.
>
> Regards
> cT
> "bernardo" wrote:
|||Im having the same problem. Does anyone have an idea whats the cause?

Add a new SQL2000 node

Based on the other threads I've read in the group, I'd like to confirm
the steps needed to perform to add a third node to a cluster that has
been running for a while on 2 nodes...
After adding the new node to the cluster, for each instance in the
cluster (assume: each instance is its own cluster group):
1) Run SQL2000 setup from CD on one of the older nodes; instruct setup
to add the new node as a target for failover.
2) Move the cluster group, making it active on the new node.
3) Install SQL2000 SP4 to the instance from the new node.
Am I missing any steps? Are there additional hotfixes (post-SP4) that
should be installed?
The current (active/active) cluster is running on Win2003 ENT SP1, while
the new node already has Win2003 ENT R2 SP2. The plan is to upgrade the
older hosts to the same rev after the new node is up. Is this workable?
To minimize downtime, you don't have to move any groups to apply SP4.
Rather, from the new node, apply SP4. After that, move the SQL group and
apply the post-SP4 hotfix.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"horseradish" <millardjk@.gmail.com> wrote in message
news:O5L1VrQjHHA.4132@.TK2MSFTNGP05.phx.gbl...
Based on the other threads I've read in the group, I'd like to confirm
the steps needed to perform to add a third node to a cluster that has
been running for a while on 2 nodes...
After adding the new node to the cluster, for each instance in the
cluster (assume: each instance is its own cluster group):
1) Run SQL2000 setup from CD on one of the older nodes; instruct setup
to add the new node as a target for failover.
2) Move the cluster group, making it active on the new node.
3) Install SQL2000 SP4 to the instance from the new node.
Am I missing any steps? Are there additional hotfixes (post-SP4) that
should be installed?
The current (active/active) cluster is running on Win2003 ENT SP1, while
the new node already has Win2003 ENT R2 SP2. The plan is to upgrade the
older hosts to the same rev after the new node is up. Is this workable?
|||There's no need to move the cluster group unless you want to test it will
correctly will startup.
For the SP4. If i Remember well Setup will detect that there's only one node
missing for the SP4 binnaries and will update only that node without
affecting the others.
Hope this helps.
Regards.
FR.
"horseradish" wrote:

> Based on the other threads I've read in the group, I'd like to confirm
> the steps needed to perform to add a third node to a cluster that has
> been running for a while on 2 nodes...
> After adding the new node to the cluster, for each instance in the
> cluster (assume: each instance is its own cluster group):
> 1) Run SQL2000 setup from CD on one of the older nodes; instruct setup
> to add the new node as a target for failover.
> 2) Move the cluster group, making it active on the new node.
> 3) Install SQL2000 SP4 to the instance from the new node.
> Am I missing any steps? Are there additional hotfixes (post-SP4) that
> should be installed?
> The current (active/active) cluster is running on Win2003 ENT SP1, while
> the new node already has Win2003 ENT R2 SP2. The plan is to upgrade the
> older hosts to the same rev after the new node is up. Is this workable?
>
|||Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Based on other things I've seen, it appears that I should be able to add
two nodes (my ultimate plan is to get to 3 nodes using two new and one
current host) to the SQL cluster simultaneously, either when installing
SQL2K RTM _or_ SP4.
Then, once I have my 4-node cluster running, I can uninstall from SQL
and MSCS the one node I wish to remove.
Or will I have to fully install & patch the first new node before I can
repeat with the second?
|||You're probably safer to patch as you go. What if there was a failover in
the middle of what you're doing? It's best to have new nodes like the old
one as soon as you can.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"horseradish" <millardjk@.gmail.com> wrote in message
news:Otdi2JojHHA.4896@.TK2MSFTNGP02.phx.gbl...
Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Based on other things I've seen, it appears that I should be able to add
two nodes (my ultimate plan is to get to 3 nodes using two new and one
current host) to the SQL cluster simultaneously, either when installing
SQL2K RTM _or_ SP4.
Then, once I have my 4-node cluster running, I can uninstall from SQL
and MSCS the one node I wish to remove.
Or will I have to fully install & patch the first new node before I can
repeat with the second?
|||Tom Moreau wrote:
> You're probably safer to patch as you go. What if there was a failover in
> the middle of what you're doing? It's best to have new nodes like the old
> one as soon as you can.
>
Thanks! The safer way is the right way for this implementation...
|||Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Which HF is 'the post-SP4 hotfix'?
|||Check out:
http://aspfaq.com/SQL2000Builds.asp
The hotfix to correct the AWE issue is build 8.00.2040. There have been
subsequent fixes, which are cumulative, so you could apply a later one
instead.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"horseradish" <millardjk@.gmail.com> wrote in message
news:%23rObwnioHHA.4412@.TK2MSFTNGP02.phx.gbl...
Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Which HF is 'the post-SP4 hotfix'?

ADD A COLUMN AND POPULATE IT WITH A SINGLE VALUE FROM A USER VARIABLE

Hi !

I have one Excel source with ... say 2 columns, I have an SQL Server destination with 3 columns.

I want the third column to be populated with a single value stored in a User::Variable.

Can someone help !

Jacques...

Just add a Derived Column transformation and assign your User::Variable to the derived column.

That's it.

|||

Thanks Sbastien !

Jacques

AD Domain Local Groups bug in RS ?

Hi,
I'm posting this problem for the third time. Still no answer from the MS
Team. I've found other users on the web having the same issue.
I have the following problem with AD an RS: when creating a group of users
as a "domain local group" in AD, i'm able to give a specific item-level role
in RS to members of this group. But it looks like rights are not effective
for those users. For example if the group is defined as "reader" on a folder,
group members can't see it in RS!
Everything works fine when the created group is a "global group" in AD.
Best Regards.
Greg.Hi all,
Is it a known bug ?
Thanx.
Greg.
"Greg - NEOS" wrote:
> Hi,
> I'm posting this problem for the third time. Still no answer from the MS
> Team. I've found other users on the web having the same issue.
> I have the following problem with AD an RS: when creating a group of users
> as a "domain local group" in AD, i'm able to give a specific item-level role
> in RS to members of this group. But it looks like rights are not effective
> for those users. For example if the group is defined as "reader" on a folder,
> group members can't see it in RS!
> Everything works fine when the created group is a "global group" in AD.
> Best Regards.
> Greg.
>|||Has someone already tested AD local groups in RS ?
Greg.
"Greg - NEOS" wrote:
> Hi all,
> Is it a known bug ?
> Thanx.
> Greg.
> "Greg - NEOS" wrote:
> > Hi,
> >
> > I'm posting this problem for the third time. Still no answer from the MS
> > Team. I've found other users on the web having the same issue.
> >
> > I have the following problem with AD an RS: when creating a group of users
> > as a "domain local group" in AD, i'm able to give a specific item-level role
> > in RS to members of this group. But it looks like rights are not effective
> > for those users. For example if the group is defined as "reader" on a folder,
> > group members can't see it in RS!
> >
> > Everything works fine when the created group is a "global group" in AD.
> >
> > Best Regards.
> > Greg.
> >