CREATE CERTIFICATE FROM BINARY
- 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
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