3 Replies Latest reply: Dec 10, 2012 11:29 PM by Adeesh Fulay RSS

    EM12c: Add Target SQL Server 2012 Fails

    Marcelo Marques - ESRI
      EM12c: Add Target SQL Server 2012 Fails
      --------------------------------------------
      Configuration:
      EM12c platform:
      Oracle Enterprise Linux 6.2(x86_64)
      Oracle Enterprise Database 11.2.0.3 (x86_64)
      Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) (x86_64)
      Microsoft SQL Server Plug-In 12.1.0.2.0 deployed in the Management Server

      Target:
      Windows Server 2008 R2 Enterprise Edition SP1 (64-bit)
      SQL Server 2012 (Enterprise Edition) (64-bit)
      Microsoft SQL Server Plug-In 12.1.0.2.0 deployed in the Management Agent
      --------------------------------------------------------
      Problem: EM12c fails to add a SQL Server 2012 instance.

      Target Name: mssql_mcsdbsqlsrv2.esri.com     
      Target Type: Microsoft SQL Server
      Agent: https://mcsdbsqlsrv2.esri.com:3872/emd/main/
      * JDBC URL (Example : jdbc:sqlserver://<host>:<port>): jdbc:sqlserver://mcsdbsqlsrv2.esri.com:1433
      JDBC Driver (Optional): com.microsoft.sqlserver.jdbc.SQLServerDriver
      Database Username (Required for SQL Authentication): sa
      Password of Database User (Required for SQL Authentication): ****     
      System Username (Needed when SQLServer is at remote location):
      System Password (Needed when SQLServer is at remote location):     
      Connect Using Windows Integrated Authentication (Yes/No): No
      Role (Optional):

      Error:
      MSSQLDetermineName_DynamicProperty;em_error=Could not connect. Error code = 0x8004100e
      em_error=Failed while connecting to WMI.
      Response;Can't resolve a non-optional query descriptor property [provided_sql_server_name] (ms_sqlserver_servername)

      ---------------------------------------------

      The sa login is enabled and I can connect from a remote machine to the MSSQL 2012 server using SQL Server Management Studio.

      I have also added several default MSSQL 2008 instances to EM12c successfull.

      I've installed the latest "Microsoft SQL Server Plug-In 12.1.0.2.0" in EM12c and deployed it to the target agent in the MSSQL 2012 machine

      Does EM12c (12.1.0.1) support MSSQL 2012?

      Thanks,

      Marcelo Marques
      Technical Manager, Esri

      Edited by: Marcelo Marques - ESRI on Sep 26, 2012 9:12 AM

      Edited by: Marcelo Marques - ESRI on Sep 26, 2012 9:13 AM