Connecting to another database instance in NAV2013 in SQL 2008R2

Business Central/NAV Developers Forum
1

Hi All;

I have created a new database on SQL 2008R2 and instance that i would like to connect to with new ports. I can access the database on the development environment but when i try connecting from the windows client, it shows the database connection is established but fails to connect and gives the following error:

“A fatal error occurred. The connection to SQL server cannot be established or is no longer usable”, the list the possible causes.

Has any meet this and how is it resolved?

Thanks in advance.

2

Did you check this

http://msdn.microsoft.com/en-us/library/jj551773(v=nav.70).aspx