Post reply

Upgrading SQL Server2012 SP1 to SP2 failing- The User Log directory in the registry is not valid. Verify DefaultLog key under the instance hive points to a valid directory.

  • January 14, 2015 at 2:18 pm

    #313636

    Hi,

    Upgrading SQL Server 2012 SP1 to SP2 failing-

    Error installing SQL Server Database Engine Services Instance Features

    The User Log directory in the registry is not valid. Verify DefaultLog key under the instance hive points to a valid directory.

    Error code: 0x851A0044

    Please can you help me on this?

    Thanks

  • January 14, 2015 at 3:08 pm

    #1770270

    Sounds like the default log location is no longer there. Under server properties and then database settings, ensure the database default location for the log file is valid. It might be pointing to a location that no longer exists.

  • July 24, 2015 at 1:41 am

    #1814651

    List the default path for the data/log using TSQL

    select SERVERPROPERTY('instancedefaultdatapath') AS [DefaultFile], SERVERPROPERTY('instancedefaultlogpath') AS [DefaultLog]

    Verify either of the location does not exist; create the folder and or change the change Data/log file vice versa.

  • July 24, 2015 at 1:52 am

    #1814653

    Similar post

    https://connect.microsoft.com/SQLServer/feedback/details/778275/sql-server-2012-sp1-installation-issue

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply