Hi,

I had a problem when I was trying to upgrade from CMS6 to 6R2. I had a connectonstring with the Data Source on the format IP,PORT\NAMEDINSTANCE which as far as I have found is correct and worked well except when trying to upgrade. This does however generate a parserror since the code handling this look like this:

string[] array = sqlConnectionStringBuilder.DataSource.Split(new char[]
 {
  ','
});
  this.ServerName = array[0];
  this.ServerPort = int.Parse(array[1]);

The easy way to resolve it is of course to change the Data Source to IP\NAMEDINSTANCE,PORT (which took me a while to find out).

I'm not 100% sure if this is a bug but when upgrading from CMS5 R2 SP1 to CMS 6 it worked with the IP,PORT\NAMEDINSTANCE format.