Kentico Remote SQL Server

Tony Brown asked on September 10, 2014 20:23

Hello,

I'm working on installing Kentico on a Virtual Machine that is within Windows Azure. During install, I am trying to connect to a remote SQL server (also on Azure).

Azure uses ports for access to the machines and I am getting a SQL Networking 25 error (bad connection string).

I went through the documentation for installing Kentico on Azure and it seems a bit complicated.

Am I not allowed to install Kentico on a VM within Azure the same way as I would on a physical or virtual server? Does Kentico allow for ports to be part of the connection string during the installation process?

Any help would be appreciated.

Correct Answer

Tony Brown answered on September 11, 2014 20:45

I have resolved the port issue by entering the SQL Server name as follows:

< Servername >,< portNumber >

I am not getting a connection timeout expired error while attempting to consume the pre-login handshake acknowledgement.

In investigating, and making modifications to the SQL server for possible solutions, many have suggested increasing the timeout for the application. Unfortunately, there is no way to do this in the Kentico Installer (that I know of unless you can upload it through the XML configuration option).

Any suggestions how to resolve this for the Kentico install?

Thanks!

Tony

2 votesVote for this answer Unmark Correct answer