Error and solutions- Dynamics crm installation -onpremisis

i had overcome lots of  Errors while configuring the setup for dynamics crm 2016 server.

Error : "The instance name must be the same as computer name"

This can happen if you rename the database server computer name after you have installed SQL Server. 

copied blog link here.

1> select @@servername in sql server

2> Find out the database computer name, Start -> Computer -> Properties

computer name will not be same (this causes the error ).

Solution :

Drop invalid computer name saved in SQL Server


SP_DROPSERVER "INVALID SERVER NAME"



Add correct computer name to SQL Server


SP_ADDSERVER "CORRECT SERVER NAME", local

Finally Restart the MSSQLSERVER service


This will resolve the error .

Error in Reporting Services Configuration Manager

Reporting Services requires two databases to run:

• ReportServer
• ReportServerTempDB

In Dynamics crm installation you will get an error  

"Unable to connect to the remote server Error"

To configuring the report server  :

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

solution : i could  open the "Reporting Services Configuration Manager"

2> click on the database.

3> click on the change database

4> i could see that a wrong database name was configured. i provided the correct database and server name and the error got resolved. 

sometimes the given url throws an error in dynamics crm installation

"Setup failed to validate specified Reporting Services Report Server"

solution :

in "Reporting Services Configuration Manager" you will get the following error : 

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled)

opening the encryption key tab in Reporting Services manager and there is an option for delete. 

then you will be able to open the report service web service page and the manager page.

now the installation will  continue smoothly.