# Casing in SqlServerStorage parsing connectionstring

**URL:** <https://discuss.hangfire.io/t/casing-in-sqlserverstorage-parsing-connectionstring/167>\
**Category:** question\
**Created:** [August 30, 2014, 9:24am UTC](https://discuss.hangfire.io/t/casing-in-sqlserverstorage-parsing-connectionstring/167 "2014-08-30T09:24:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dredy](https://avatars.discourse-cdn.com/v4/letter/d/c5a1d2/32.png) [@dredy](https://discuss.hangfire.io/u/dredy)\
**Post date:** [August 30, 2014, 9:24am UTC](https://discuss.hangfire.io/t/casing-in-sqlserverstorage-parsing-connectionstring/167/1 "2014-08-30T09:24:04Z")

</div>

Hi,

I was struggling for half an hour before discovering that my Connectionstring contains a connectionstring all in lowercase, and the ToString Method searches for “Database”, “Server” …

The Dashboard writes always a “Connection String cannot be parsed” message.

It would be more error-prone to make the method case insensitive

Regards,

Dredy

foreach (var alias in new[] { “Data Source”, “Server”, “Address”, “Addr”, “Network Address” })  
{  
if (parts.ContainsKey(alias))  
{  
builder.AppendFormat("{1}", alias, parts[alias]);  
break;  
}  
}