My Dynamic World

SQL Upgrade Error - Access to License Denied Ahh a wonderful time to experience an error, when you are upgrading SQL, during a limited window for downtime.  Sop much for the weekend plans eh? No worries, this one is easy.  In my case I received the following when downgrading an edition for a reporting Server that houses several instances.  After the first one processed, I received this error: If I browse to that path, we notice the file is set to read only. Easy enough, lets un-check read only and try again.  Success!  I had to do this for each instance install.  So if you have multiple instances be prepared to set the file to read/write each time.

While trying to determine and configure some settings in SQL 2012 I ran across this error:   Seems this can occur, from Microsoft:  http://support.microsoft.com/kb/956013 Open a Administrative command prompt, and run this to fix for SQL 2012:  mofcomp "%programfiles(x86)%\Microsoft SQL Server\ 110 \Shared\sqlmgmproviderxpsp2up.mof" Then restart the WMI service.

Recently ran into an issue installing CRM 2011 on Sever 2012 without any imported customization. When opening a form you will receive a JavaScript error:   Error:Object doesn't support property or method 'Form_onload' It appears that this can occur from time to time , but typically in older version of the software.  Perhaps since this is IIS8, it occurred.   However, to fix perform the following: Reinstall the URI ReWrite Module.  This will create the necessary values in the web.config file. File is located on the Installation ISO, in this sub-folder: UrlRewriteModule

I used to capture results in an conditional statement to clean up reports.  It is still useful, when you want hide conditional statements. =IIf(<expr> = 0, "",  <expr>   ) However, I was considering the option numeric values have, to hide 0 values.  Which is:  0;(0);'' Now to hide the percentage format, use this:  0.0%;(0.0%);''

The 1.5 version of the adapter is not 64 bit compatible and uses the more stable NAS to read and write to NAV. I ran across this yesterday, with scribe support we upgraded one of the NAS's to 1.5 (upgraded to 1.4 first) and it works fine.  However, the help file for 1.5 only states to move these files: Scribe.NavAdapter.NasHook.dll Scribe.NavAdapter.NasHook.tlb Scribe.NavAdapter.NasHook.XmlSerializers.dll ScribeNasSettings.xml Scribe.MSXML4.dll \ScribeModifications \ReleaseNotes However, the additional NAS's will fail when attempting to connect to them in the workbench.  You also need to copy these files, which were installed in the 1.4 upgrade.  I suspect since the 1.5  adapter  no longer uses C/Side that these libraries need to be in the  install  directory for each NAS. AuthHelper.dll Interop.AuthHelperLib.dll These files are not listed in the help file for 1.5.  This should not be an issue if you upgraded all of...

Scribe has the ability to insert SQL queries against a source or target (which does not have to be a database for Scribe).  This works great when searching against distinct values. However, what if you need to format a source field to strip out and prefix text, then match it up to a larger field?  In SQL you can declare a variable and perform a LIKE statement. Plugging that statement into Scribe will cause it to fail.  Here is the workaround. Format the source variable, and save it as a calculated variable to call later. RIGHT( S1, LEN(S1)-SEARCH(" ",S1  ) )  = cvTrim Then call your query. SQLQUERY( cv_Trim, "T", "SELECT [TableField] FROM [Database].[dbo].[Table] WHERE [TableField] LIKE '%' + '%s' + '%' " ) %s references the source field.

GUID - Stripping the brackets off of a target variable. REPLACE(REPLACE( TargetVariable ,1 ,1 ,"" ), 37 ,1, "")