tag:blogger.com,1999:blog-69112523602693153362024-02-08T05:43:34.928-08:00SQL Server DiscoveriesThis blog is all about SQL Server and different problems and solutions I have discovered while working with the software.Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6911252360269315336.post-62401998280203291432013-01-31T11:04:00.000-08:002013-01-31T11:04:00.863-08:00Performance Point Strange Error<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
I'm more of a hard core SharePoint guy now a day than a SQL Server diehard,
but having been in charge of a large SharePoint Enterprise allows me to keep
the SQL skills sharp. I came across this strange error today
while trying to create a Report in Performance Point against an OLAP
cube. I couldn't find anything on the web for this particular issue
so I thought I would post it here.<br />
<br />
<br />
I created my datasource without issue pointed it to the SSAS server and
picked the database and cube to use. Saved the datasource and went
upon my business of creating the report. Upon trying to
create the report against my newly created data source I came across the error
below.<br />
<br />
An exception occurred while rendering a Web control. The following
diagnostic information might help to determine the cause of this problem:<br />
<br />
Microsoft.PerformancePoint.Scorecards.BpmException: There was a problem setting
the item location URL.<br />
<br />
PerformancePoint Services error code 20700.<br />
<br />
<br />
After searching the web and finding nothing I decided to circle back and
double check things. Sure enough after looking at the data source I
noticed that the cube I had chosen earlier was now empty. After I
selected the cube again from the dropdown everything was fine and I was able to
create the report. Anyone familiar with Performance Point
will know this is just yet another bug.<br />
<div class="MsoNormal">
<br /></div>
<br />
<br />
Hope this helps someone.<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" UnhideWhenUsed="false"
Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
</style>
<![endif]-->Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com0tag:blogger.com,1999:blog-6911252360269315336.post-24369492874229816212011-07-19T20:27:00.000-07:002011-07-19T20:27:59.829-07:00Can't Install SQL ServerThis is the first time I have come across this, and I have been doing SQL work for some time. I was consulting on a SQL Server install on a Windows Server 2003 R2 box. Anytime you tried to install SQL it would fail. It turned out someone had enabled the DisableMSI registry key. This key will prevent any .MSI installation from running.<br />
<br />
The fix.<br />
<br />
Go into the registry and set DisableMIS key located in <span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;"><strong>HKEY_LOCAL_MACHINE</strong></span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;">\</span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;"><strong>Software</strong></span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;">\</span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;"><strong>Policies</strong></span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;">\</span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;"><strong>Microsoft</strong></span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;">\</span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;"><strong>Windows</strong></span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;">\</span><span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;"><strong>Installer to 0</strong></span><br />
<span class="Apple-style-span" style="font-family: 'Segoe UI', Verdana, Arial; font-size: 13px;"><strong><br />
</strong></span>Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com0tag:blogger.com,1999:blog-6911252360269315336.post-46117671321895647662009-07-20T10:20:00.000-07:002009-07-20T10:27:32.668-07:00Database Mirroring Error on A clusterRan into a strange issue today on my cluster. We currently have a 3 node cluster in production which has been pieced together overtime with nodes going off of lease overtime and being replaced by new nodes. We have been moving more towards Database Mirroring over the past year and today when I came in the principal database in the cluster was in recovery and I couldn't do anything with it. After researching I could find anything that resembled my issue. I tried the standard fix which is breaking the mirror by running ALTER DATABASE <database>SET PARTNER OFF, no dice. After looking around I noticed something strange. I knew they had done maintenance on Sunday which involved rebooting the boxes and when they did they left the SQL Cluster groups running on different nodes. This led me to the root of the issue. When SQL was installed on the newest node for whatever reason this instance was not patched to Service Pack 2 as it should have been. Therefore, my database when running on the proper node has the patched binaries of Service Pack 2 and database mirroring works fine. However, on the node without a service pack applied to the binaries Mirroring doesn't run unless you set the trace flag to allow it to. Once I failed the instance back to the proper node where the Service Pack has been applied no issue, business as usual. I just wanted to post this in case someone runs across a similar issue in a clustered environment. I am going to be applying Service Pack 3 to the entire cluster next week so that should prevent this from happening in the future.Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com2tag:blogger.com,1999:blog-6911252360269315336.post-27806506651690230472009-06-11T10:05:00.000-07:002009-06-11T10:11:11.698-07:00Best Thing I Learned at PASSThe best thing I learned at PASS 2008 was in regards to the SQL Server Upgrade Assistant. I wasn't alone in the people that didn't know this tool existed. When the presenter asked for the hands of those who had used or knew of the tool, not many were raised. I knew of and had used the SQL Server Upgrade Advisor before, but this tool was the real deal and helped us get approval sign offs in record times. This tool saved my organization SAIC a great deal of time an effort in staging and testing for our upgrades from SQL Server 2000 to SQL Server 2005. We plan to make use of the tool again when we go from SQL Server 2005 to SQL Server 2008 sometime in the future.<br /><br />Thanks PASSRobhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com0tag:blogger.com,1999:blog-6911252360269315336.post-12287081120768016622009-06-04T18:06:00.000-07:002009-06-04T18:13:13.161-07:00WAHOO passed Exam 70–431 todayMan I hadn’t taken a Prometric exam in a long time and today was quite different from what I remember. I used to hit Prometric a lot when I was getting my Oracle Certified Professional (OCP) exams under my belt. Not sure why I went ahead and took this one. I was bored and before I decided to start the UCSD SE program I kind of decided I would at least take this one exam. I was very happy to see that Microsoft has made use of simulations and actually allow you to show that you can do something instead of just choosing a multiple choice answer. I’m happy to have it under my belt not sure if I will continue on with any other test, especially with SQL Server 2005 on its way out shortly. What does everyone think about certifications? I have been surprised as a professional how little of value they are. Even upper management that I have been around doesn’t care much for them.Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com0tag:blogger.com,1999:blog-6911252360269315336.post-81796606603913415272009-06-01T13:00:00.000-07:002009-06-02T09:53:06.457-07:00Systems Engineering Assignment 2<div>This is the second major assignment completed as part of my enrollment at UCSD completing the Systems Engineering Certificate program. This assignment goes together with assignment one. This is my Systems Engineering Management Plan (SEMP) which goes together with the SRD from my first assignment. Out of the two I enjoyed the SRD more than the SEMP.<br /><br /><br /><a href="http://3168195702026223679-a-1802744773732722657-s-sites.googlegroups.com/site/sqlserverdbastuff/Home/SEMP.pdf?attredirects=0&auth=ANoY7cqSFzL4h_YU0V0nnUJosYon08HB3EyoeOMVCjV8tHfuzNHvD5_duKRl6aiJdXke-W8UP0XTpBkGGQh8LDaxZ4YvhT3TltlxvSrqmQVJUTZUlebUrxbdLYgzGvjcWRylmpt_NGRDSNn-rqBQZXDAzJPHvjvFqcuFSfamAfnzbBpJdGHR0wlZ8u4yZDQAB_c345KPfO3mH-zHStBPDj48VOic9ddrKQ%3D%3D">DOWNLOAD FILE</a> </div>Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com0tag:blogger.com,1999:blog-6911252360269315336.post-4379286037709192702009-05-25T12:09:00.000-07:002009-05-25T12:34:27.265-07:00Systems Engineering Assignment 1Recently I started the Systems Engineering Certificate Program at the University of California San Diego. I am going to use my blog as a trapper keeper for the assignments I complete along the way. Here is the first major assignment I had to complete. I had a lot of fun wirting this System Requirements Document (SRD).<br /><br /><a href="http://3168195702026223679-a-1802744773732722657-s-sites.googlegroups.com/site/sqlserverdbastuff/Home/SRD.pdf?attredirects=0&auth=ANoY7cqqNwYZy4cnko_byn-jCCjDuxiKZBO8aMewL-AMQBWtNsQgdT6IFf2GIs6JAshzayE-I3J3BeFClt7r14AfKdiF1WbkQJ8kDy_rp5-qqvIWU0GI6Dp1cv8XV531jgxDWXOG04fhP0M1INEn0KJk26k79eYIpuein2FnvmkX_jcdOmYdQpvxGGeioX0TzAQDWA6heOGato6CdeHpIMZffGUKvGt1fQ%3D%3D">DOWNLOAD FILE</a>Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com0tag:blogger.com,1999:blog-6911252360269315336.post-30919543809192783012008-05-12T20:49:00.001-07:002008-05-12T20:52:40.298-07:00Adding nodes to a SQL Server 2005 ClusterThis past weekend I had the task of adding two additional nodes to our current 2 Node SQL Server 2005 x64 cluster. When I logged into an existing node of the cluster the new nodes had already been added to the cluster and were ready to have the SQL Server binaries installed. I started off by following the steps recommended by Microsoft (<a href="http://msdn.microsoft.com/en-us/library/ms191545.aspx">http://msdn.microsoft.com/en-us/library/ms191545.aspx</a>). I was able to go into add/remove programs and click on Change for SQL Server 2005 and the installation process was started. I was able to easily make my way through the setup screens and soon had an installation running for one of our three Virtual SQL Servers. The installation seemed to be running smoothly but after a few minutes the installation reported a failure and roll backed. The error reported was "Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine." After doing some research I was able to learn this was due to the fact that some of the machines had RDP connections. I opened up terminal services manager and ensured all remote connections had been logged off for each node in the cluster. After doing this I retired setup and it failed once again with the same error. After doing a little more research I found that some people had to not only kill all RDP connection but also reboot the machines. So I rebooted each node and this solved the first error of the night. The next error I encountered was reported as Task did not appear to start on machine: CP-ITS-SQL64P-4: 267013. This machine was one of the new nodes being introduced. I decided to reboot that machine and restart the installation. Once I did that the next error was Task did not appear to start on machine: CP-ITS-SQL64P-5: 267013. I was thinking I was making progress but after rebooting that machine (the other new node). I restarted the installation and received the following error Task did not appear to start on machine: CP-ITS-SQL64P-4: 267013. So basically I was in an installation failure loop. While trying to research this error I was unable to find anyone out there that had experienced a similar issue. After having no luck on Google I decided to shutdown one of the new nodes CP-ITS-SQL64P-5 and work strictly with CP-ITS-SQL64P-4. Finally success. I was able to run through the setup of a virtual server and successfully install SQL on a new node. I decided to apply SP2 right away on the new node to make sure I had successfully finished the install of one of my 3 virtual servers on the new node. The SP2 was applied with no problems. Afterwards I returned to performing the install for the remaining two virtual servers. I had a new error this time Error String : The setup has encountered an unexpected error while Completing Commit. The error is: The object already exists. After doing some research I couldn't find much information on this one and decided to reboot the node I was doing the install from. This fixed the issue as I was able to install the instance after the reboot. I can only assume it was holding a variable from the install of the first Virtual Server. After that I was able to smoothly reboot and install for the remaining virtual server. By this time I was already an hour over my estimated 3 hour time window. I decided to quickly failover the 2 un-patched instances to CP-ITS-SQL64P-4 and apply SP2. The Service Pack was applying smoothly until I got the dreaded no passive nodes patched, setup failed. By this time it was late and I had to let the customer applications back in so I decided to leave the first Virtual Server that was installed and patched running on CP-ITS-SQL64P-4 and failed the other groups back to the original nodes. I am assuming a full round of reboots will allow SP2 to apply. During my next maintenance windows I plan to finish up the setup. My major question regarding the installation is “Does a major issue exist when trying to add more than 1 node at a time to a cluster in SQL 2005?”Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com4tag:blogger.com,1999:blog-6911252360269315336.post-47315319370055483342008-05-08T16:55:00.000-07:002008-05-08T16:59:06.733-07:00WelcomeThank you for visiting my Blog. It is my intention to keep this blog up to date with my daily discoveries in the world of SQL Server. I currently work as a Sr. Database Administrator for SAIC and encounter things other DBA's might find interesting in my daily work. I hope you enjoy reading about some of my discoveries and hopefully some of you will even be able to find them useful.Robhttp://www.blogger.com/profile/10739044070786664885noreply@blogger.com0