What do you mean by "shard"? MSSQL doesn't support sharding, it's a whole different type of database architecture, like on Redis or Grails databases.
And even if it would support it, like pieter said, we can't help you if you don't actually say what error you're getting...