Di Penjelajah Objek SQL Server Management Studio (SSMS), klik kanan server, lalu pilih Properti. Pada halaman Keamanan, di bawah Autentikasi server, pilih ‘Mode autentikasi SQL dan Windows’, lalu pilih OK. Anda harus me-restart server.<\/p>\n\n\n\n
Anda dapat mencoba mengakses Database dari baris perintah dengan:<\/p>\n\n\n\n
sqlcmd -S server -d database -U nama pengguna -P kata sandi<\/p>\n\n\n\n
Contoh:<\/p>\n\n\n\n
sqlcmd -S SQLEXPRESS -d OFFICE_DB -U vs4 -P 123456qAz!<\/p>\n","protected":false},"excerpt":{"rendered":"
Di Penjelajah Objek SQL Server Management Studio (SSMS), klik kanan server, lalu pilih Properti. Pada halaman Keamanan, di bawah Autentikasi server, pilih ‘Mode autentikasi SQL dan Windows’, lalu pilih OK. Anda harus me-restart server. Anda dapat mengakses Database dari perintah berikut: sqlcmd -S server -d database -U nama penguga -P kata sandi Contoh: […]<\/p>\n","protected":false},"author":65283547,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[559],"tags":[765254636],"class_list":["post-237","post","type-post","status-publish","format-standard","hentry","category-yang-lain","tag-kata-sandi-masuk-mssql-nama-pengguna"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4CoHV-3P","jetpack-related-posts":[{"id":174,"url":"https:\/\/vkrastev1blog.com\/2022\/02\/08\/create-dump-from-oracle-schema-in-console-in-linux\/","url_meta":{"origin":237,"position":0},"title":"Buat Dump dari skema Oracle di konsol di Linux","author":"vkrastev2014","date":"08.02.2022","format":false,"excerpt":"It is not easy to find the correct way to execute expdp command in console. There are some steps before you execute expdp command. First you have to create a directory on the computer where Oracle DB is, where you will put the dump files than you have to grant\u2026","rel":"","context":"In "Yang lain"","block_context":{"text":"Yang lain","link":"https:\/\/vkrastev1blog.com\/category\/yang-lain\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":224,"url":"https:\/\/vkrastev1blog.com\/2022\/06\/01\/eclipse-problem-by-changing-git-password\/","url_meta":{"origin":237,"position":1},"title":"Masalah Eclipse dengan mengubah kata sandi GIT","author":"vkrastev2014","date":"01.06.2022","format":false,"excerpt":"I have had a problem by changing the GIT password in Eclipse. Eclipse could not change the password in the secure storage and I couldn't use GIT anymore. You schould do following: Eclipse go to Preferences -> General -> Security -> Secure storage and in Contents tab delete \"Default Secure\u2026","rel":"","context":"In "Jawa"","block_context":{"text":"Jawa","link":"https:\/\/vkrastev1blog.com\/category\/jawa\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":55,"url":"https:\/\/vkrastev1blog.com\/2014\/05\/11\/important-shell-script-commands-which-are-oft-used\/","url_meta":{"origin":237,"position":2},"title":"Perintah skrip Shell penting yang sering digunakan","author":"vkrastev2014","date":"11.05.2014","format":false,"excerpt":"Here is a list of some important shell commands: ---- Using Screen command screen -ls -- for a list of avaliable active screens screen -x .... - the Name from -ls output to join to this active screen Go out of the Screen with 'ctrl a+d' without stopping it ----\u2026","rel":"","context":"In "Yang lain"","block_context":{"text":"Yang lain","link":"https:\/\/vkrastev1blog.com\/category\/yang-lain\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":167,"url":"https:\/\/vkrastev1blog.com\/2022\/02\/01\/sql-developer-execute-big-sql-files-scripts-in-sql-developer\/","url_meta":{"origin":237,"position":3},"title":"Pengembang SQL – mengeksekusi file\/skrip .sql besar di Pengembang SQL","author":"vkrastev2014","date":"01.02.2022","format":false,"excerpt":"SQL Developer - execute big .sql files\/scripts in SQL Developer Open SQL Developer than press Alt - F10 and it will show you a Choose Connection dialog. Choose a Connection and it opens a SQL Editor for that connection. Write in it just @C:\\Users\\KrastevV\\Project\\sql.sql Sign @ followed by the Path\u2026","rel":"","context":"In "Yang lain"","block_context":{"text":"Yang lain","link":"https:\/\/vkrastev1blog.com\/category\/yang-lain\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":229,"url":"https:\/\/vkrastev1blog.com\/2022\/06\/03\/eclipse-tomcat-no-catalina-out-log\/","url_meta":{"origin":237,"position":4},"title":"Eclipse Tomcat tidak ada log catalina.out","author":"vkrastev2014","date":"03.06.2022","format":false,"excerpt":"In Eclipse you have already added Tomcat as Server than you do following: In the servers tab, double-click on the Tomcat Server. You will get a screen called Overview.Click on \"Open launch configuration\". Click on the \"Common\" tab.Towards the bottom of the screen you can check the \"Output File\" checkbox\u2026","rel":"","context":"In "Jawa"","block_context":{"text":"Jawa","link":"https:\/\/vkrastev1blog.com\/category\/jawa\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":194,"url":"https:\/\/vkrastev1blog.com\/2022\/03\/30\/java-configure-log4j2-in-your-project\/","url_meta":{"origin":237,"position":5},"title":"Java mengkonfigurasi Log4j2 di Proyek Anda","author":"vkrastev2014","date":"30.03.2022","format":false,"excerpt":"Log4j2 and SLF4j Binding DependenciesTo make Log4j2 work with SLF4J, we need to include the following 3 dependencies. log4j-slf4j-impl.jar \u2013 Log4j 2 SLF4J binding. It allows applications coded to the SLF4J API to use Log4j2 as the implementation.log4j-api.jar \u2013 provides the adapter components required for implementers to create a logging\u2026","rel":"","context":"In "Jawa"","block_context":{"text":"Jawa","link":"https:\/\/vkrastev1blog.com\/category\/jawa\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/users\/65283547"}],"replies":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":4,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":241,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/237\/revisions\/241"}],"wp:attachment":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}