cancel
Showing results for 
Search instead for 
Did you mean: 

The wizard failed to discover the user database for instance SQL2

KANSTANTSIN
Level 4
Partner

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.

 

1 REPLY 1

KANSTANTSIN
Level 4
Partner

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]