Create DB certificates with special characters in the name and subject

• feanor387

  Grasshopper

  Points: 10

  More actions

  September 7, 2018 at 12:27 pm

  #378773

  Hi All,
  I am trying to create a certificate on an sqlserver DB whenever I run the command I get an error "syntax error starting at 'aaa-bbb-ccc3'. I have tried framing the name and subjects these different ways.  Sorry if this is the obvious I am new to sqlserver.  

  sqlserver 2012
  server 2016

  Thank you in Advance
  T.

  CREATE CERTIFICATE [aaa-bbb-ccc3]   
  WITH SUBJECT = 'aaa-bbb-ccc3';
  go

  CREATE CERTIFICATE [aaa-bbb-ccc3]   
  WITH SUBJECT = [aaa-bbb-ccc3];
  go

  CREATE CERTIFICATE ["aaa-bbb-ccc3"]   
  WITH SUBJECT = ["aaa-bbb-ccc3"];
  go

  CREATE CERTIFICATE ""aaa-bbb-ccc3""   
  WITH SUBJECT = ""aaa-bbb-ccc3"";
  go