Asked by:
Config Manager failed to run the SQL Server Function 'fnSCCMMultiByteToWideChar' when trying to gather data

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 databaseI think that cover all the needs for it to connect.
Any idea on the error message? is some rights missing?
thanks
- Edited by Jonathan Lefebvre-Globensky Wednesday, June 13, 2012 3:05 PM
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
- Marked as answer by Jonathan Lefebvre-Globensky Wednesday, June 13, 2012 3:22 PM
- Unmarked as answer by Jonathan Lefebvre-Globensky Wednesday, June 13, 2012 3:22 PM
- Proposed as answer by TorstenMMVP Monday, June 18, 2012 7:00 AM
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 accountSo 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