Search This Blog

Tuesday, 14 March 2017

If you Installed on Contoso.com SQL Server and later changed the name of the domain to access the server are having difficulty due to which gross Today, we will tell you some facts on what causes your overall server will complete!

You got the error as below while open MS SQL Server:













Open SQL in SQL Server authentication Mode.

Enter the login and password is correct and click on connect.























After Login Expand the security and right on logins and click on New login…






















Click on search button and go to advanced click on find Now and choose Administrator (it.com/users).
Click OK again click OK.










Click on server roles and tick mark on all Roles.





















Click on User Mapping and tick mark on as below and click OK.

































You can Disconnect SQL Server and Reconnect Windows authentication.

AX2012R3 Report Server and Analysis Server step by step Installation and configuration.

Please find the below step by step AX2012R3 Report Server Installation and configuration.

Step: 1

Install the SQL Server Reporting service and configure the reporting Service Configuration Manager. Also from the below window make sure the left pane all step was configured correctly.

Make sure the following configuration of SSRS:

Service account must be configured with the domain account.

Web service URL must be configured with default or custom port, and the URL must accessible.

Database must be configured to the database server.

Report manager URL must be configured with default or custom ports, and the URL must be accessible.

Execution account must be configured with the same above mentioned domain user account.

IMPORTANT: - AX application business connector proxy user account, SSRS service user account and SSRS execution user account, all these three user accounts must be configured with the same domain user account.













Step: 2

Configure the Report server from AX application under system administratoràSetupàBusiness intelligenceàReport Server.

Once the configuration is done please click on the validate settings, you will be prompted to create the folder, please click on the create report folder and then validate setting and check you got the success massage as below, if you face any issue try to application with Run as Administrator option and validate it again.

Make sure the following settings in Report server configuration: -

Server Name field enter the SSRS server name.

Server Instance name enter instance name (Default Instance is MSSQLSERVER and if any named instance you can mention same here).

Report manager URL, enter the configured URL in the above steps (Step1).

Web service URL, enter the configured URL in the above steps (Step1).

Application Object server, Select your application object server instance.













Step: 3

Run the AX2012R3 Installation media, click on the Microsoft Dynamics AX components.














Step: 4
Please click on the next button to progress the installation.
















Step: 5
Please click on the Add or modify components, then go with the next button.
















Step: 6
Select the Business Intelligence components, and go with the next button.



















Step: 7
Prerequisite validation will guide you know the tools need to be configured and installed.
















Step: 8
Select the configure check box and then click on the configure button then click on the start button to configure the ADOMD.NET tools.














Step: 9
Click on the Revalidate button to check if any error still exists, the go with the next button.
















Step: 10
Please enter the Business connector user account password, and go with the next button.
















Step: 11
Select the SSAS Service name from the dropdown, and go with the next button.
















Step: 12
Please select SSRS Instance name from the dropdown and if you need to deploy the Report with this installation enable the deploy Reports check box and then go with the next button.
















Step: 13
Enter or select the AX application Database server name and ax database name.
















Step: 14
Please enter the current user ssas service account user and any other user if required, then go with the next button.
















Step: 15
Please check for the prerequisite validation again before installing the components, then go with the next button.
















Step: 16
Please verify the selected Bl components, then go with the install button.
















Step:17
Post installation configuration tasks will be performed.


















Step: 18
Make sure the AX Bl components were installed successfully.
















Step: 19
In the above steps, if Deploy reports is enable then the following steps will be automatically process and the administrator rights will be verified, also logged on must have the administrator rights to deploy the reports.









Step: 20
All the Reports will be deployed automatically one after another.








Happy AX2012R3 and enjoy with the new features.
For more information install the AX2012R3 EP

Friday, 10 March 2017

SQL Server Database stuck in “Restoring” state

If You have a SharePoint server. you have an issue with your backup tool and now some of your databases are stuck in restoring state!












You run the following query against the SQL Server instance and found that the database immediately became usable:


RESTORE DATABASE <database name> WITH RECOVERY

After apply the query facing the result is OK.













You can apply as same in all Databases.

Sunday, 5 March 2017

Wait on the Database Engine Recovery Handle Failed:

SQL Server 2014 Installation Error:


While I’m Installing SQL Server 2014 in Windows Server 2012r2 then I facing the Error of

“Wait on the Database Engine Recovery Handle Failed”.


























































I’ll give you solution of this error please follow the steps:
  • First you need to Uninstall all the previous Installations of SQL Server. also you need to delete all the registry values related to SQL Server. For this I suggest you to Uninstall all the instances of SQL Server using Revo Uninstaller.  Click Here to go to download page.
  • Revo Uninstaller enable you to scan for registry files and remaining files after the default uninstallation. Delete all the registry values and remaining files.
  • Also Navigate to C: Program Files Microsoft SQL Server and delete all the files present in the folder. Restart your PC.
  • Now Double click on the SQL Server setup to begin the installation and proceed with the default settings. When you come to Server Configuration Screen, Change the Account Name of Database Engine Service to NT AUTHORITY\NETWORK SERVICE and continue installation and it will successfully install all components without any error.

  • If, after changing the Account Name to NT AUTHORITY\NETWORK SERVICE, you are getting validation error it means that your previous installation files of SQL Server are not completely removed. Try to change the Instance name of the SQLServer. Also delete all the registry files of previous installations.



























  • This simple solution worked for me straightway. Let me know whether your problem is solved or not by commenting below.