Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

Visual Studio SQL Server Project Create Certificate

CREATE CERTIFICATE [MyCert]

FROM BINARY = 0x1234....

WITH PRIVATE KEY (BINARY = 0x1234..., DECRYPTION BY PASSWORD='Pass1',ENCRYPTION BY PASSWORD='Pass2');

I get the following Visual Studio compiler error : SQL46005: Expected EXECUTABLE but encountered BINARY instead.

This syntax works on SQL 2012 and I have the database project targeting the correct version.

7 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
under review  ·  AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded  · 

Upvotes: 3

<=-=Dec 28 2016 7:28PM=-=>

Thank you for submitting this feedback. We have reproduced the behavior for certificate objects that you’ve described and are now investigating the appropriate resolution. We will update this Connect item as additional information is available.

Thanks again!
Steven Green
SQL Server tools team

<=-=Feb 21 2017 12:04PM=-=>

I have this issue as well. It makes creating a homogenous test environment amongst our development team more difficult.

<=-=Feb 21 2017 12:09PM=-=>

Ref: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/04dd415c-047e-421d-97fe-038328b54a9a/create-certificate-from-binary?forum=ssdt

5 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment

SQL Server: Bugs

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice