Data BI Visuals

This is the error message, it will pop up when you opening a office 365 web app documents in sharepoint. Solution for this issue is very simple, Check and fix your system Date, Time & Time Zone settings. Ref:  http://support.microsoft.com/kb/2890756 Thanks Keep visit & share it.

Very often we will get the error message “Login failed for user ‘’”. Sometime we may forget what settings we have given while installing SQL Server. In case, if you choose only “Windows Authentication” while installing then you can’t able to connect a user which related with SQL Server authentication. How to solve this problem? It is very easy to solve this issue. Right click on the server and go to properties. Then in properties, go to security tab and change the server authentication to “SQL Server and Windows Authentication mode” and click ok. Now try with SQL Server authentication login, you will get success.

When you  get below error message, “Alter failed for server ‘’ The execute permission was denied on the object ‘xp_instance_regwrite’, database ‘mssqlsystemresource’, schema ‘sys’. (Microsoft SQL Server, Error:229)” If you are login as SQL Server authentication mode and trying to change the server authentication mode in the server properties. Solution: How to avoid this error, if you want to change the server authentication mode to Windows authentication, first you have to login as windows authentication and then go to server properties and change the mode. Make sure always login as windows authentication mode to change the server authentication mode properties.

My friend had an issue in deploying the report to report server. It is a dashboard so it has colourful charts and many thing. The size of the report is around 4 MB. When he deploy the report he got an error message “There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded." When we work around, we found that the default size of the file to upload is less, we need to increase the size manually in web xml config file. To find the web xml config file, go to C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer Open the Web file and add maxRequestLength="2097151" as below, then close the solution and open. Now deployed the report.