March 14, 2015 at 11:02 pm
Hi,
While upgrading from MSSQL 2008R2 to MSSQL 2012 we are facing the following issue. Is there anybody who encountered the same issue?
TITLE: Microsoft SQL Server 2012 Setup
------------------------------
The following error has occurred:
SQL Server Setup has encountered an error when running a Windows Installer file.
Windows Installer error message: Error opening installation log file. Verify that the specified log file location exists and that you can write to it.
Windows Installer file: E:\SQL2012\redist\watson\dw20shared.msi
Windows Installer log file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20150315_085912\WatsonX86_Cpu32_1.log
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=0xDC80C325
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
March 15, 2015 at 3:05 am
From the top of my head, something along these lines: disable SSIS, detach the SSIS database and then run the upgrade. After the upgrade you can migrate your SSIS to the 2K12 platform.
😎
Suggest you research into this before going ahead as it's been a while...
March 15, 2015 at 4:13 am
No use. Still the same
March 15, 2015 at 5:26 am
Quick question, are you running the upgrade as Administrator? Is the Administrator a member of SQL sa?
😎
March 15, 2015 at 5:57 am
Yes the user is local admin as well as sysadmin in sql.
March 15, 2015 at 6:07 am
Apologies for not being of a much help so far.
😎
Quick thought, is side by side installation an option, that is installing the 2K12 on the same server, migrate every thing from the 2K8 to the 2K12 and then uninstall the 2K8? Obviously this is not an option if you have to preserve the instance name.
Another question, what is the build of these two SQL Servers (@@VERSION)?
March 15, 2015 at 6:16 am
Have you searched for the Detail.txt log file, my guess is that might lead to the reason for the setup failure?
😎
March 15, 2015 at 7:11 am
Actually I want it to be in place upgrade.
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Jun 28 2012 08:36:30
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Thanks for your involvement.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply