{"id":2721,"date":"2020-01-30T12:46:00","date_gmt":"2020-01-30T09:46:00","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=2721"},"modified":"2021-01-15T10:23:32","modified_gmt":"2021-01-15T07:23:32","slug":"sql-2017-clr-strict-security-hatasi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-2017-clr-strict-security-hatasi\/","title":{"rendered":"SQL 2017 Clr strict security hatas\u0131"},"content":{"rendered":"\n
\n\n\n

sp_configure \u2018clr enabled\u2019, 0
GO
RECONFIGURE
GO<\/p>\n

EXEC sp_configure \u2018show advanced options\u2019,1;
GO
RECONFIGURE;
GO
EXEC sp_configure \u2018clr strict security\u2019,0;
GO
RECONFIGURE;
GO<\/p>\n

SQL RESTART ED\u0130LMEL\u0130<\/p>\n

\n

Yukar\u0131daki i\u015fi \u00e7\u00f6zmez ise detay yetki dahil a\u015fa\u011f\u0131dakileri uygulay\u0131n\u0131z<\/p>\n

————————————————————————————————————<\/p>\n\n\n

sp_configure \u2018clr enabled\u2019, 1
GO
RECONFIGURE
GO<\/p>\n\n\n\n

EXEC sp_configure \u2018show advanced options\u2019,1;
GO
RECONFIGURE;
GO
EXEC sp_configure \u2018clr strict security\u2019,0;
GO
RECONFIGURE;
GO<\/p>\n\n\n\n

SQL RESTART ED\u0130LMEL\u0130<\/p>\n\n\n\n

Y\u0130NE OLMAZ \u0130SE A\u015eA\u011eIDAK\u0130LER\u0130 UYGULAYIN (VERI TABANI ISIMLERINE DIKKAT)<\/p>\n\n\n\n

\n\n\n\n

USE<\/p>\n\n\n\n

master;<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

EXEC<\/p>\n\n\n\n

sp_configure ‘clr enabled’, ‘1’;<\/p>\n\n\n\n

RECONFIGURE<\/p>\n\n\n\n

WITH OVERRIDE;<\/p>\n\n\n\n

go<\/p>\n\n\n\n

EXEC sp_configure ‘show advanced options’, ‘1’;<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

RECONFIGURE;<\/p>\n\n\n\n

EXEC sp_configure ‘clr enabled’ ,1<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

RECONFIGURE<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

EXEC sp_configure ‘clr enabled’   — make sure it took<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

ALTER DATABASE MikroDB_V15_XXX SET TRUSTWORTHY ON;  <\/p>\n\n\n\n

EXEC sp_configure ‘show advanced options’, 1<\/p>\n\n\n\n

RECONFIGURE;<\/p>\n\n\n\n

EXEC sp_configure ‘clr strict security’, 0;<\/p>\n\n\n\n

RECONFIGURE;<\/p>\n\n\n\n

EXEC sys.sp_configure N’show advanced options’, N’0′;<\/p>\n\n\n\n

RECONFIGURE WITH OVERRIDE;<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

EXEC sp_configure ‘show advanced options’, 1<\/p>\n\n\n\n

RECONFIGURE;<\/p>\n\n\n\n

EXEC sp_configure ‘clr strict security’, 0;<\/p>\n\n\n\n

RECONFIGURE;<\/p>\n\n\n\n

EXEC sys.sp_configure N’show advanced options’, N’1′;<\/p>\n\n\n\n

RECONFIGURE WITH OVERRIDE;<\/p>\n\n\n\n

EXEC sys.sp_configure N’clr strict security’, N’0′;<\/p>\n\n\n\n

RECONFIGURE WITH OVERRIDE;<\/p>\n\n\n\n

EXEC sys.sp_configure N’show advanced options’, N’0′;<\/p>\n\n\n\n

RECONFIGURE WITH OVERRIDE;<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

EXEC sys.sp_configure N’show advanced options’, N’1′;<\/p>\n\n\n\n

RECONFIGURE WITH OVERRIDE;<\/p>\n\n\n\n

EXEC sys.sp_configure N’clr strict security’, N’1′;<\/p>\n\n\n\n

RECONFIGURE WITH OVERRIDE;<\/p>\n\n\n\n

EXEC sys.sp_configure N’show advanced options’, N’0′;<\/p>\n\n\n\n

RECONFIGURE WITH OVERRIDE;<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

ALTER DATABASE MikroDB_V15_XXX SET TRUSTWORTHY ON;<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

USE MikroDB_V15_XXX<\/p>\n\n\n\n

GO<\/p>\n\n\n\n

EXEC sp_changedbowner ‘SRV\\Administrator’<\/p>\n\n\n\n

GO<\/p>\n","protected":false},"excerpt":{"rendered":"

sp_configure \u2018clr enabled\u2019, 0GORECONFIGUREGO EXEC sp_configure \u2018show advanced options\u2019,1;GORECONFIGURE;GOEXEC sp_configure \u2018clr strict security\u2019,0;GORECONFIGURE;GO SQL RESTART ED\u0130LMEL\u0130 Yukar\u0131daki i\u015fi \u00e7\u00f6zmez ise detay yetki dahil a\u015fa\u011f\u0131dakileri uygulay\u0131n\u0131z ———————————————————————————————————— sp_configure \u2018clr enabled\u2019, 1GORECONFIGUREGO EXEC sp_configure \u2018show advanced options\u2019,1;GORECONFIGURE;GOEXEC sp_configure \u2018clr strict security\u2019,0;GORECONFIGURE;GO SQL RESTART ED\u0130LMEL\u0130 Y\u0130NE OLMAZ \u0130SE A\u015eA\u011eIDAK\u0130LER\u0130 UYGULAYIN (VERI TABANI ISIMLERINE DIKKAT) USE master; GO EXEC […]<\/p>\n","protected":false},"author":4,"featured_media":2722,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,10],"tags":[],"class_list":["post-2721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mikro","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=2721"}],"version-history":[{"count":8,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2721\/revisions"}],"predecessor-version":[{"id":3542,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2721\/revisions\/3542"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/2722"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=2721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=2721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=2721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}