{"id":62,"date":"2014-01-02T22:32:25","date_gmt":"2014-01-02T14:32:25","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=62"},"modified":"2014-01-02T22:32:25","modified_gmt":"2014-01-02T14:32:25","slug":"disabling-and-renaming-the-sa-account","status":"publish","type":"post","link":"https:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html","title":{"rendered":"Disabling and Renaming the SA Account"},"content":{"rendered":"

Sudah bukan rahasia lagi bahwa didalam SQL Server ada user yang bernama SA apabila SQL Server tersebut menggunakan  Mixed mode Server Authentication. dan sudah kita ketahui bersama bahwa user SA memiliki Server Role sebagai sysadmin.<\/p>\n

Hal ini menjadi langkah awal yang baik bagi para \u2018perusak\u2019 untuk berusaha menembus keamanan SQL Server dengan menggunakan user tersebut, karena user tersebut sangat berkualitas dan memiliki otoritas penuh terhadap server.<\/p>\n

Oleh karena itu, sangat disarankan untuk mendisable user SA apabila anda menggunakan Mixed mode Server Authentication dan mengganti nama dari user SA tersebut dengan cara sebagai berikut (dalam sample code ini SA saya rename menjadi SUHERMANOK):<\/p>\n

*Note : sebelum melakukan ini pastikan sudah ada user lain yang memiliki Administrator privilages.<\/p>\n

\n
\n
USE<\/span> MASTER<\/pre>\n
<\/p>\n
GO<\/span><\/pre>\n
<\/p>\n
ALTER<\/span> LOGIN SA DISABLE<\/pre>\n
<\/p>\n
GO<\/span><\/pre>\n
<\/p>\n
ALTER<\/span> LOGIN SA WITH<\/span> NAME=[SUHERMANOK]<\/pre>\n
<\/p>\n
GO<\/pre>\n
<\/div>\n<\/div>\n
Demikian semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sudah bukan rahasia lagi bahwa didalam SQL Server ada user yang bernama SA apabila SQL Server tersebut menggunakan  Mixed mode Server Authentication. dan sudah kita ketahui bersama bahwa user SA memiliki Server Role sebagai sysadmin. Hal ini menjadi langkah awal yang baik bagi para \u2018perusak\u2019 untuk berusaha menembus keamanan SQL \u2026<\/p>\n
 Continue reading<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[21,22],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-sa","tag-security"],"yoast_head":"\nDisabling and Renaming the SA Account - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Disabling and Renaming the SA Account - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Sudah bukan rahasia lagi bahwa didalam SQL Server ada user yang bernama SA apabila SQL Server tersebut menggunakan  Mixed mode Server Authentication. dan sudah kita ketahui bersama bahwa user SA memiliki Server Role sebagai sysadmin. Hal ini menjadi langkah awal yang baik bagi para \u2018perusak\u2019 untuk berusaha menembus keamanan SQL \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-02T14:32:25+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Disabling and Renaming the SA Account\",\"datePublished\":\"2014-01-02T14:32:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html\"},\"wordCount\":125,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"keywords\":[\"SA\",\"Security\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html\",\"url\":\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html\",\"name\":\"Disabling and Renaming the SA Account - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"datePublished\":\"2014-01-02T14:32:25+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Disabling and Renaming the SA Account\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"https:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Disabling and Renaming the SA Account - Suherman Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html","og_locale":"en_US","og_type":"article","og_title":"Disabling and Renaming the SA Account - Suherman Blog","og_description":"Sudah bukan rahasia lagi bahwa didalam SQL Server ada user yang bernama SA apabila SQL Server tersebut menggunakan  Mixed mode Server Authentication. dan sudah kita ketahui bersama bahwa user SA memiliki Server Role sebagai sysadmin. Hal ini menjadi langkah awal yang baik bagi para \u2018perusak\u2019 untuk berusaha menembus keamanan SQL \u2026 Continue reading","og_url":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-01-02T14:32:25+00:00","author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Disabling and Renaming the SA Account","datePublished":"2014-01-02T14:32:25+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html"},"wordCount":125,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"keywords":["SA","Security"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html","url":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html","name":"Disabling and Renaming the SA Account - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"datePublished":"2014-01-02T14:32:25+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/disabling-and-renaming-the-sa-account.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Disabling and Renaming the SA Account"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"https:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":1,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":63,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/62\/revisions\/63"}],"wp:attachment":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}