So I just have to ask this because I am a bit baffled and flabbergasted by this situation. In 9 years I have not come across an issue where an application built on SQL, could not work if it was set on a named instance.
We have forecasting software that we are implementing, and some functions do not work because the parameters passed to the API will not accept the servername/instance name. It really blows my mind as default/named instances aren't even remotely new, and this company is 20 years old. I can't understand how they would have never encountered this in the past.
The server we have for this is on a shared hosted solution so for obvious reasons we cannot get the default instance.
Has anyone else encountered this? If so, did you find a workaround?
Link to my blog http://notyelf.com/