Cannot Create login - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Cannot Create login

Author

Topic

reykentj
Starting Member

3 Posts

Posted - 2007-04-27 : 21:52:29

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 wiht this code:
USE Frontier_equipment;
CREATE CERTIFICATE AccountingCorp
WITH SUBJECT = 'Frontier Accounting Records',
EXPIRY_DATE = '10/31/2009';
GO

rkj

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-27 : 22:35:45

Is the certificate in master db?

reykentj
Starting Member

3 Posts

Posted - 2007-04-27 : 22:51:22

I was wondering where the code that I ran put that certificate. I could not see it in Frontier_equipment with management studio. It is someplace
because trying to create the certificate again I got a message that it already existed.

rkj

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-28 : 20:40:08

You may need check sys.certificates in every db on the server.

reykentj
Starting Member

3 Posts

Posted - 2007-04-29 : 01:21:04

I solved the problem by more carefully reading the documentation.
I had created the certificate in an sql statement specifying use Frontier Equipment which confused the whole world. The Certificate needs to be in the master. When I created a new certificate with a new name
using master then everything worked.!!

rkj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources