Cannot Create Login

• R kent Johnson

  Newbie

  Points: 3

  More actions

  April 27, 2007 at 8:08 pm

  #178053

  This error message :

  Cannot find the certificate 'AccountingCorp', because it does not exist or you do not have permission.

  This Code

  USE master

  CREATE LOGIN Dave

  FROM certificate AccountingCorp;

  GO

  ******************

  AccountingCorp was created with this code:

  USE Frontier_equipment;

  CREATE CERTIFICATE AccountingCorp

  WITH SUBJECT = 'Frontier Accounting Records',

  EXPIRY_DATE = '10/31/2009';

• jezemine

  SSCrazy Eights

  Points: 8109

  More actions

  April 29, 2007 at 11:04 pm

  #703199

  From BOL, on the topic of creating a login from a certificate http://msdn2.microsoft.com/en-us/library/ms189751.aspx:

          "This certificate must already exist in the master database."

  so, you need to create your cert in master, not in Frontier_equipment.

   

   

  ---------------------------------------
  elsasoft.org