Forum Discussion

KANSTANTSIN's avatar
KANSTANTSIN
Level 4
10 years ago

The wizard failed to discover the user database for instance SQL2

Operation system: Windows server 2012 R2

SFHA 6.1

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

I have two SQL instances in two nodes: SQL1 and SQL2.

Instaled features:

  • Database Engine Services;
  • SQL server replication;
  • Full-Text Search;
  • Data Quality Services;
  • Analysis Services;
  • Reporting Services;
  • Client Tools Connectivity;
  • Integration Services;
  • Management Tools – Basic;
  • Management Tools – Complete
  • SQL Client Connectivity SDK;
  • Master Data ServicesMaster Data Services.

I have configured first instance.First instance was configured without problem.

Second inctance:

In sql configuration wizard on sql server instance selection I selected SQL2 with SQLagent and Analisys.

Then I got VCS warning

"The wizard failed to discover the user database for instance SQL2"

V-16-13-3535

I connected to SQL and saw all databases.

 

business continuity
Configuring
Error messages
Storage Foundation for Windows
Windows Server (2003-2008)
  • KANSTANTSIN's avatar
    KANSTANTSIN
    Level 4
    10 years ago

    SQL Wizard logs:

    ///////////////////////////////////////////////////////
    SQLWizard log file last updated at :
    2015/06/01 13:52:24
    ///////////////////////////////////////////////////////

    2015/06/01 13:52:24 VCS INFO V-16-13-6300 Service, 'MSSQL$SQL2' is in stopped state on local node, SFHA2
        InstancePage.cpp:InstancePage::IsThisServiceRunning[1079]
    2015/06/01 14:07:31 VCS INFO V-16-13-6300 Service, 'MSSQL$SQL2' is in running state on local node, SFHA2
        InstancePage.cpp:InstancePage::PrerequisiteSvcStart[1139]
    2015/06/01 14:07:31 VCS INFO V-16-13-6300 Service, 'CmdServer' is in running state on local node, SFHA2
        InstancePage.cpp:InstancePage::IsThisServiceRunning[1074]
    2015/06/01 14:07:31 VCS ERROR V-16-13-0  Database discovery started for instance SQL2...
        SQLUserDbPage.cpp:SQLUserDbPage::DiscoverDatabases[0367]
    2015/06/01 14:07:47 VCS INFO V-16-13-0 WIZ_CMDSUCCESS : SFHA2 Instance_DBDetails:SQL2 SQLServer
        DiscoveryManager.cpp:VDiscoveryManager::DiscoverValue_WizCmdClient[0992]
    2015/06/01 14:07:54 VCS ERROR V-16-13-0 *** Start of debug information dump for troubleshooting ***
        LibLogger.cpp:VLibThreadLogQueue::Dump[0206]
    2015/06/01 14:07:54 VCS ERROR V-16-13-0 ReadRegistryValue:RegOpenKeyEx() failed with error: 0x2.
        LibRegistry.cpp:VLibRegistry::Connect[0070]
    2015/06/01 14:07:54 VCS ERROR V-16-13-0 ReadRegistryDWORD:RegQueryValueEx() failed with error: 0x6.
        LibRegistry.cpp:VLibRegistry::ReadDWORDValue[0187]
    2015/06/01 14:07:54 VCS ERROR V-16-13-0 *** End of debug information dump for troubleshooting ***
        LibLogger.cpp:VLibThreadLogQueue::Dump[0217]
    2015/06/01 14:08:39 VCS ERROR V-16-13-0 The wizard failed to discover databases for one or more SQL Instances
        SQLUserDbPage.cpp:SQLUserDbPage::OnSetActive[0199]