Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I am trying to install CRM 3.0 with following specification :
Windows Server 2003,
SQL Server 2005 Standard,
After installing SQL, when I am trying to install CRM, in the middle of installation i am getting error as
When I opened the tracer it shows,
Action Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction failed.Cannot find the object 'fn_LocalTimeToUTC', because it does not exist or you do not have permission.Cannot find the object 'fn_UTCToLocalTime', because it does not exist or you do not have permission.Cannot find the object 'fn_RptBracket', because it does not exist or you do not have permission.Cannot find the object 'fn_GetFormatStrings', because it does not exist or you do not have permission.Cannot find the object 'fn_FindUserGuid', because it does not exist or you do not have permission.Cannot find the object 'fn_FindBusinessGuid', because it does not exist or you do not have permission.
I've checked in CRM 4.0 org databases, these are the tables , in 'Table-valued Function'/'Scalar-valued Functions' under 'Programmability' folder under "Org-name_MSCRM" database. These tabled need to be created by CRM, but it says object not find, so at this point I think that this might be an issue with CRM Server setup file.
I am not sure if this is a SQL Server problem, then I able to log on to SQL Server
or this problem might be improper "CRM Server" file, Any suggestions?
CRM 3.0 Server file is not available in Microsoft website, so I've downloaded through partner source, If anybody can give me a link of CRM 3.0 Server setup would be helpful
Refer the following links:
Hope this helps.
"Please mark my answer as verified if you found it helpful"
Make sure the sure you are using to install it has all permission .
This object will get created in SQL if you have all permission
Thankyou Rajkumar. It seems the issue is in CRM Server Setup file. When I was getting this error, if I manually add these functions then the installation process is continuing
Yes Arpita, I've gone through your link, but still the error is coming, It seems the issue is in CRM Server Setup File cause When I tried Manually injecting these functions, the installation is moving further, more ever I've tried the above mentioned functions, now further it asks for few more functions, so I think the Setup file might not referencing the exact location of functions.
Business Applications communities