locked
Config Manager failed to run the SQL Server Function 'fnSCCMMultiByteToWideChar' when trying to gather data RRS feed

  • Question

  • Hi,

    I'm having a problem setting up the Source hierarchy.
    I get the error :

    "Config Manager failed to run the SQL Server Function 'fnSCCMMultiByteToWideChar'.
    Ensure the specified credentials have permission to run this function on the source site database server."

    CM07 setup is :
    - 1 primary server
    - 1 server hosting database (SQL Cluster)

    CM12 setup is :
    - 1 primary server
    - 1 server hosting database (SQL standard)

    I try to setup the Source Hierarchy using the computer account of the 2012 primary site.

    The account of the CM 12 primary server as the following rights :
    - Local admin on CM 07 primary server
    - Member of the Distributed COM Users on CM07 primary server

    - SMS Admin on CM 07 primary server
    - Full admin in CM 07 console (I know it's too much, but it was easier)
    - Read and execute on the database

    I think that cover all the needs for it to connect.

    Any idea on the error message? is some rights missing?

    thanks


    Wednesday, June 13, 2012 3:04 PM

All replies

  • See. http://technet.microsoft.com/en-us/library/gg712313.aspx:

    To gather data you must configure the following two accounts for each source site:

    • Source Site SMS Provider Account: This account is used to access the SMS Provider of the source site and requires Read permission to all source site objects.
    • Source Site SQL Server Account: This account is used to access the SQL Server database of the source site and requires Read and Execute permissions to the source site database.

    Torsten Meringer | http://www.mssccmfaq.de

    Wednesday, June 13, 2012 3:13 PM
  • Hi,

    I followed this exact page from technet.

    The account of the CM 12 primary server as the following rights :

    - Local admin on CM 07 primary server
    - Member of the Distributed COM Users on CM07 primary server

    - SMS Admin on CM 07 primary server
    - Full admin in CM 07 console (I know it's too much, but it was easier) This covert the part for SMS Provider
    - Read and execute on the database This should do it for the SQL server account

    So something must be missing.

    thanks

    Wednesday, June 13, 2012 3:25 PM
  • oh well... it's always better to double check security by myself....

    It was missing Execute on the 3 function for SCCM on the source database.

    sorry about that.

    Wednesday, June 13, 2012 4:15 PM
  • Which 3 function , did you manually add the permissions.
    Sunday, April 23, 2017 2:56 PM