microsoft / microsoft/DacFx

CREATE CERTIFICATE FROM BINARY

Open
#301 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version: 16.1.8089.0
- .NET Framework (Windows-only) or .NET Core: .NET Framework Version: 4.8.1 or later
- Environment (local platform and source/target platforms): Windows 11 | Visual Studio 2022 | SQL Server 2019

**Steps to Reproduce:**

1. Add a sqlfile with Build Action 'Build' in SSDT with

CREATE CERTIFICATE ClrStrictSecurity FROM BINARY =
0x308203913082027DA003020102021013E6F73872521EAF490BB7D86C75CC2F300906052B0E03021D\
05003048310B3009060355040613024445311D301B060355040A1314696E736964652D73716C7365\
727665722E636F6D311A301806035504031311436C7253747269637453656375726974793020170D\
3233303732333131303332395A180F32303939313233303232303030305A3048310B300906035504\
0613024445311D301B060355040A1314696E736964652D73716C7365727665722E636F6D311A3018\
06035504031311436C72537472696374536563757269747930820122300D06092A864886F70D0101\
0105000382010F003082010A0282010100B319F909AC619D48CE00B0E3B9319163127A2456FCF21E\
EBD1620316CC387DA8AE8ACAE5084B5C94B8D2827E7CAEE94ABC8E324C99C74238E3B9002193D787\
C54D6B3D357D9B399F5AF696FC097CB60537842F16E007DFCD1613A240467E74EC5CED16C0DD8EE3\
B71A9975BC4C5F548A19AEB479A61754E51DE343943274753FF3C182457C5D8F1A96A751B15236C5\
F5B7BEB4811DA554642AA166B015DF7EF6FC44347738E8FFB00D3CA8103164416FED2E76D828FC53\
BD54697496FDE6F18DF892EA309A1906B1939CE6D29F704867CDD387497F789EA8401BCFFAE70F7F\
865EF3A86C14A03AF9288516947365910B221005B812CCA33744E5A0CAD25062390203010001A37D\
307B30790603551D010472307080100A6B6AF8F7D33BB8DE0AF0162400B5D2A14A3048310B300906\
0355040613024445311D301B060355040A1314696E736964652D73716C7365727665722E636F6D31\
1A301806035504031311436C725374726963745365637572697479821013E6F73872521EAF490BB7\
D86C75CC2F300906052B0E03021D050003820101007711A61A03705D55B7CDFC222EABA02C117174\
1F9B21E79105563A0C66B7A5AB62DD2AC92F5CD9B8479EECFD27019FFCD13765DAD2AE1FC8209F20\
E4E4D45BD98FEE57259BB55645E7655DAF26B457161F7A26512CFE5276D19D71A7E26B4F1B2965DC\
C1C3DE03E8A6F0556F088A16C04FE4DE2EF958BB36002D0718E16216AA034F18F982926CE8666992\
130C1B178D8D42930C7E46B0198A36106A369990F7FC506B2BE60CCE18B54782E6F518D6AF4D0D2F\
93BD7D9B834CE3A0378A50D0B0DEBE9DE5861D1A6528E9AA1E6E4E530E2FC65C85C0D7DAD911EB5D\
B64AFCDC07554B9B0BD7818C480222005B2FC972F128885894CB7DF9A965B4D35B5B6CDF0D

2. Building your project in SSDT will cause the error Error: SQL46005: Expected EXECUTABLE but encountered BINARY instead.

**Did this occur in prior versions? If not - which version(s) did it work in?**
yes, I guess it had never worked.
(DacFx/SqlPackage/SSMS/Azure Data Studio)

Contributor guide

Open the contributing guide

Research direction

Reproduce the SSDT build failure using the CREATE CERTIFICATE ... FROM BINARY statement and confirm SQL46005. Then locate the DacFx SQL parsing path for CREATE CERTIFICATE and determine what is required for this form to build successfully; done means the supplied statement builds without the error.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.