“<filename>.pptx couldn’t be converted to presentation because Visual Basic for Application (VBA) is not installed on this computer. Please install VBA and try again” 1. Open Add or Remove Programs in Control Panel, select Microsoft Office (Professional Plus) 2013 client and click Change 2. Select Add or Remove Features and click on Continue 3. Expand […]
Run the following command to set a new owner, in this example DBO. The database name in this example is newtraders. use NEWTRADERS go sp_changedbowner @loginame = ‘dbo’ go
SQL Server Scheduled Job ‘MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb’ (0x9550CE8A82FC08489D1CCDE01A38C057) – Status: Failed – Invoked on: 2016-01-25 15:16:00 – Message: The job failed. Unable to determine if the owner (DOMAIN\ACCOUNT) of job MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb has server access (reason: Could not obtain information about Windows NT group/user DOMAIN\SAACCOUNT, error code 0x5. [SQLSTATE 42000] (Error 15404)). This is due to the fact […]
When using the Software Center to install new software, the error 0x87D01201(-2016407039) pops up. Open Control Panel, Configuration Manager. Click on the Cache tab and click on Configure Settings. Afterwards, click on Delete Files. Now try again to install the software from the Software Center.
Although PowerShell offers cmdlets to get access control lists (ACL) and modify then, I found it not that convenient. The ICACLS command can also be used within PowerShell to set permissions. Here are some basic examples how to use ICACLS with PowerShell to set the permissions. Please note that for PowerShell, the ` token […]
My best combination for years from a productivity perspective: Windows 7 & Office 2010. This allowed me to do everything without any limitations such as not working applications and plugins. Off course, I had experience with Windows 10 and Office 2013 but I was not convinced that I would benefit from it and become more […]
In this blog post I am going to set-up secure access to a web application running on Tomcat (on Windows 2012 R2) by using a certificate from an internal PKI. I am going to use KeyStore Explorer 1.1 (mirror) for the creation and modification of the KeyStore. This GUI tool makes it easier than the […]
HTTP Error 404.17 – Not found The requested content appears to be script and will not be served by the static file handler. 1.Install ASP.NET 2.Enable ASP.NET in IIS under ISAPI and CGI restrictions
Within SQL it is possible to create a Linked Server to connect to an Oracle database server. In previous versions of SQL, this was done by using the OLE DB Provider for Oracle. But this is this component is currently in maintenance mode. No new updates are planned for future releases of these components including […]
Unable to connectSQLstate=IM004[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed Solution(s): Check the system variable ORACLE_HOME, it should point to the installation folder of the Oracle client Check the system variable PATH, it should contain ;%ORACLE_HOME%\bin;. There is a . (dot) behind the ; sign in the PATH system environment variable.