CRM 2016 Opportunity Product Override Price Keeps Reverting Back

Recently, I was doing Microsoft Dynamics CRM 2016 customization on Opportunity Product and I have found out some very unusual sort of bug in it, which was not present in the Opportunity Product of MS CRM 2015 version and the bug is Opportunity Product Override Price Keeps Reverting Back to its Default value after save. So, we have done many customization and add many web resources in the form but still the bug was not resolved. So, after doing detailed R&D we have found out the solution and the solution is after installing CRM 2016 make sure you install its update 0.1 rollup which can be downloaded from this link : https://support.microsoft.com/en-us/kb/3133963 and it will resolve this bug in CRM 2016.

So, Happy CRMing :-)

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

Sometimes when we are trying to connect to the SQL Server 2008 R2 via ASP, the website throws an error message like Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

So, the solution to this error is very simple:

1-Open the SQL Server 2008 R2.
2-Expand the Security panel and then expand the Logins panel.

3-After that, right click on the NT AUTHORITY\NETWORK SERVICE user and then click on the properties. 

4-Click on the User Mapping option on the left panel and then map the NT AUTHORITY\NETWORK SERVICE user on the database by checking the check box on the map column of the desired database.

5-Write the default schema as dbo and on the database role membership for: database box check the db_owner option and after that click OK. 

6-After that just refresh the server and refresh the website's link on the browser. 

Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d'

Sometimes when we are trying to connect to the SQL Server 2008 R2 via ASP, the website throws an error message like "Microsoft OLE DB Provider for SQL Server error '80040e4d' 

Login failed for user 'username'. 

/test.asp, line 6" 

So, the solution to this error is very simple:

1-Open the SQL Server 2008 R2.

2-In SQL Server Management Studio object explorer, right-click the server, and then click properties.

3-Server properties panel will appear on your screen,on the left panel click on the Security page, under Server authentication, select the SQL Server and Windows authentication mode, and then click OK.

4-In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

5-In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

6-Now to enable the 'username' Login, go to the Object Explorer, expand Security, expand Logins, right-click username, and then click Properties. On the General page, you might have to create and confirm a password for the login.On the Status page, in the Login section, click Enabled, and then click OK.

7-After that just refresh the server.