Re: The signature of the public key is invalid
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 13 Jan 2008 15:21:14 -0800
test windows (testwindows@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
i have received this error 'Msg 15299, Level 16, State 1, Line 1,The
signature of the public key is invalid.' i have one instance sql 2005 with
two databases,
i want to add a signature on module(stored procedure) from certificate.
i had already created certificate on database x, saved it , copy the
signature generated ,recreate the cerificate on database Y from the backup
and when i try
add signature to proc_x by certificate cert_x with signature......i have
the error message ..thanks
Sounds good, but maybe you missed some detail. On
http://www.sommarskog.se/grantperm.html#certcrossdb I have a script
the demonstrates how to do this.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: ASP.NET application having sysadmin privileges
- Next by Date: RE: sql server 2005 account lockout
- Previous by thread: ASP.NET application having sysadmin privileges
- Next by thread: Re: The signature of the public key is invalid
- Index(es):
Relevant Pages
|
|
