Friday, April 8, 2016

Forum Post: Cannot connect to Microsoft Dynamics 2013 R2 new sql server instance

Hello , I have installed a new sql server instance of 2012 standard edition ( on a server having an express version of sql server) and restored an existing database to this new instance. After this i added a new server instance in NAV 2013 R2 administration and configured the new instance as the existing one. (so I only changed 'Database Name' dhe 'Database Server' fields, and used the same ports) Then i stopped the existing server instance and started the new one. Also restarted the necessary services in administration tool. When I connected to NAV Development Environment with the new sql server instance it worked. But when I tried to run a table from the development environment to NAV client I received the error: "There are no NAV Server instances available for this database. You must ensure that a NAV Server Instance is running and is configured to use the database before you perform this activity." I tried to access the new server instance from NAV client and also received an error that Server is not ready to server requests. Can anyone please suggest what might have gone wrong with the configurations? Thanks in advance.

No comments:

Post a Comment