{"id":1825,"date":"2026-09-12T11:52:23","date_gmt":"2026-09-12T08:52:23","guid":{"rendered":"https:\/\/narhost.com\/destek\/mssql-veritabani-olusturma-kullanici-yetkilendirme\/"},"modified":"2026-09-12T11:52:23","modified_gmt":"2026-09-12T08:52:23","slug":"mssql-veritabani-olusturma-kullanici-yetkilendirme","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/mssql-veritabani-olusturma-kullanici-yetkilendirme\/","title":{"rendered":"MSSQL Veritaban\u0131 Olu\u015fturma ve Kullan\u0131c\u0131 Yetkilendirme (SSMS)"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son g\u00f6zden ge\u00e7irme: Eyl\u00fcl 2026 \u00b7 SQL Server 2022 ve Windows Server 2022 resmi dok\u00fcman\u0131na g\u00f6re<\/p>\n<div id=\"hizli-cozum\" class=\"ai-box ai-box--cozum\">\n<p class=\"ai-box-title\">H\u0131zl\u0131 \u00e7\u00f6z\u00fcm<\/p>\n<p><strong>MSSQL veritaban\u0131 olu\u015fturma kullan\u0131c\u0131 yetkilendirme<\/strong> i\u015flemini SQL Server Management Studio (SSMS) ile yapars\u0131n\u0131z: sunucuya ba\u011flan\u0131n, yeni veritaban\u0131n\u0131 olu\u015fturun, bir sunucu giri\u015fi (login) a\u00e7\u0131n, bu giri\u015fi veritaban\u0131 kullan\u0131c\u0131s\u0131na e\u015fleyin ve rol atay\u0131n.<\/p>\n<ol>\n<li>SSMS ile sunucunuza ba\u011flan\u0131n.<\/li>\n<li>Object Explorer&#8217;da <strong>Databases<\/strong>&#8216;e sa\u011f t\u0131klay\u0131p <strong>New Database<\/strong>&#8216;i se\u00e7in.<\/li>\n<li><strong>Security \u2192 Logins<\/strong> alt\u0131nda yeni bir login olu\u015fturun.<\/li>\n<li>Login&#8217;i veritaban\u0131 i\u00e7inde kullan\u0131c\u0131 olarak e\u015fleyip rol atay\u0131n.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>Yok (SSMS masa\u00fcst\u00fc uygulamas\u0131)<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Windows Server 2019 \/ 2022, SQL Server (VDS\/VPS)<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>Sunucuda Administrator (RDP) ve SQL Server sysadmin<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/vds-sunucu\" title=\"Narhost VDS Sunucu\">VDS Sunucu<\/a><\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Sunucuya RDP ile Administrator hesab\u0131yla ba\u011flanabildi\u011finizi do\u011frulay\u0131n.<\/li>\n<li>SQL Server kurulu olmal\u0131; kurulu de\u011filse \u00f6nce <a href=\"https:\/\/narhost.com\/destek\/windows-sunucuda-mssql-sql-server-kurulumu\/\" title=\"Windows Sunucuda MSSQL SQL Server Kurulumu - Narhost Destek\">kurulum kart\u0131na<\/a> bak\u0131n.<\/li>\n<li>SSMS sunucuda ya da kendi bilgisayar\u0131n\u0131zda y\u00fckl\u00fc olmal\u0131.<\/li>\n<li>Mixed Mode kimlik do\u011frulama kullanacaksan\u0131z <code>sa<\/code> \u015fifresini bilmelisiniz.<\/li>\n<\/ul>\n<\/div>\n<figure class=\"nh-sema\"><img src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mssql-veritabani-olusturma-kullanici-yetkilendirme-sema-narhost.webp\" alt=\"MSSQL veritaban\u0131 olu\u015fturma kullan\u0131c\u0131 yetkilendirme ak\u0131\u015f \u015femas\u0131 \u2014 SSMS ile veritaban\u0131, login ve kullan\u0131c\u0131 ad\u0131mlar\u0131\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>SSMS ile d\u00f6rt ad\u0131mda tamamlan\u0131r: sunucuya ba\u011flanma, yeni veri taban\u0131 a\u00e7ma, giri\u015f (login) olu\u015fturma ve kullan\u0131c\u0131 e\u015fleme.<\/figcaption><\/figure>\n<h2>MSSQL veritaban\u0131 olu\u015fturma kullan\u0131c\u0131 yetkilendirme ne i\u015fe yarar<\/h2>\n<p>Windows Server \u00fczerinde SQL Server kurdu\u011funuzda varsay\u0131lan olarak yaln\u0131z sistem y\u00f6neticisi hesab\u0131 (<code>sa<\/code> ya da sunucudaki Windows kimli\u011finiz) ba\u011flanabilir. Uygulaman\u0131z\u0131n kendi verilerine eri\u015febilmesi i\u00e7in ayr\u0131 bir veritaban\u0131, ayr\u0131 bir login ve bu login&#8217;e verilen s\u0131n\u0131rl\u0131 bir rol gerekir.<\/p>\n<p>Bu ayr\u0131m g\u00fcvenlik i\u00e7in \u00f6nemlidir: uygulama hesab\u0131 yaln\u0131zca kendi veritaban\u0131na eri\u015fir, sunucudaki di\u011fer veritabanlar\u0131n\u0131 g\u00f6remez ve sunucu d\u00fczeyinde i\u015flem yapamaz. VDS\/VPS&#8217;te i\u015fletim sistemi ve \u00fczerine kurulan SQL Server sizin sorumlulu\u011funuzdad\u0131r; Narhost altyap\u0131y\u0131 ve a\u011f\u0131 sa\u011flar, veritaban\u0131 ve kullan\u0131c\u0131 y\u00f6netimini sunucunuzda siz yapars\u0131n\u0131z.<\/p>\n<h2>Ad\u0131m ad\u0131m veritaban\u0131 olu\u015fturma ve yetkilendirme<\/h2>\n<ol class=\"kb-adimlar\">\n<li><strong>SSMS ile sunucuya ba\u011flan\u0131n.<\/strong> Sunucu ad\u0131 alan\u0131na makine ad\u0131n\u0131 ya da IP adresini yaz\u0131p Windows Authentication veya SQL Server Authentication ile ba\u011flan\u0131n.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: Object Explorer&#8217;da sunucu ad\u0131 ve alt\u0131nda Databases, Security klas\u00f6rleri g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<li><strong>Yeni veritaban\u0131n\u0131 olu\u015fturun.<\/strong> Databases \u00fczerine sa\u011f t\u0131klay\u0131p New Database&#8217;i se\u00e7in, veritaban\u0131na bir ad verin ve dosya boyutu ayarlar\u0131n\u0131 varsay\u0131lan b\u0131rak\u0131p OK&#8217;e t\u0131klay\u0131n. Ayn\u0131 i\u015flemi T-SQL ile de yapabilirsiniz:\n<pre><code class=\"language-sql\">CREATE DATABASE OrnekVeritabani;<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: Databases klas\u00f6r\u00fc alt\u0131nda yeni veritaban\u0131 ad\u0131 listelenir.<\/p>\n<\/li>\n<li><strong>Sunucu d\u00fczeyinde bir login olu\u015fturun.<\/strong> Security \u2192 Logins \u00fczerine sa\u011f t\u0131klay\u0131p New Login&#8217;i se\u00e7in, login ad\u0131n\u0131 girin, SQL Server Authentication&#8217;\u0131 i\u015faretleyip \u015fifre belirleyin.\n<pre><code class=\"language-sql\">CREATE LOGIN uygulama_kullanicisi WITH PASSWORD = 'GucluBirSifre!123';<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: Security \u2192 Logins alt\u0131nda yeni login ad\u0131 g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<li><strong>Login&#8217;i veritaban\u0131 kullan\u0131c\u0131s\u0131na e\u015fleyin ve rol atay\u0131n.<\/strong> Olu\u015fturdu\u011funuz veritaban\u0131 \u2192 Security \u2192 Users alt\u0131nda New User ile login&#8217;i se\u00e7in, ard\u0131ndan <code>db_datareader<\/code> ve <code>db_datawriter<\/code> rollerini i\u015faretleyin.\n<pre><code class=\"language-sql\">USE OrnekVeritabani;CREATE USER uygulama_kullanicisi FOR LOGIN uygulama_kullanicisi;ALTER ROLE db_datareader ADD MEMBER uygulama_kullanicisi;ALTER ROLE db_datawriter ADD MEMBER uygulama_kullanicisi;<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: kullan\u0131c\u0131, veritaban\u0131n\u0131n Security \u2192 Users listesinde ilgili rollerle g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<\/ol>\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/databases\/create-a-database?view=sql-server-ver16\" title=\"Create a Database - SQL Server resmi dok\u00fcman\u0131, Microsoft Learn\" target=\"_blank\" rel=\"noopener\">Microsoft&#8217;un resmi dok\u00fcman\u0131na g\u00f6re<\/a> yeni bir veritaban\u0131 olu\u015ftururken dosya boyutu ve b\u00fcy\u00fcme ayarlar\u0131n\u0131 elle de\u011fi\u015ftirmedi\u011finiz s\u00fcrece SQL Server makul varsay\u0131lanlar uygular; k\u00fc\u00e7\u00fck ve orta \u00f6l\u00e7ekli uygulamalar i\u00e7in bu varsay\u0131lanlar yeterlidir.<\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/create-a-database-user?view=sql-server-ver16\" title=\"Create a Database User - SQL Server resmi dok\u00fcman\u0131, Microsoft Learn\" target=\"_blank\" rel=\"noopener\">Microsoft&#8217;un veritaban\u0131 kullan\u0131c\u0131s\u0131 dok\u00fcman\u0131na g\u00f6re<\/a> bir login&#8217;in veritaban\u0131na eri\u015febilmesi i\u00e7in o veritaban\u0131 i\u00e7inde ayr\u0131ca bir kullan\u0131c\u0131 olarak e\u015flenmesi gerekir; login olu\u015fturmak tek ba\u015f\u0131na eri\u015fim vermez.<\/p>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Uygulaman\u0131z\u0131n ba\u011flant\u0131 dizesinde yeni login ad\u0131n\u0131 ve \u015fifresini kullanarak veritaban\u0131na ba\u011flanmay\u0131 deneyin. SSMS&#8217;te <strong>Connect<\/strong> ekran\u0131nda SQL Server Authentication&#8217;\u0131 se\u00e7ip yeni login ile oturum a\u00e7\u0131n; yaln\u0131zca yetkilendirdi\u011finiz veritaban\u0131n\u0131 g\u00f6rmesi ve sunucudaki di\u011fer veritabanlar\u0131na eri\u015fememesi beklenen sonu\u00e7tur.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00e7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>Login olu\u015fturuldu ama ba\u011flanam\u0131yorsunuz.<\/strong> SQL Server Configuration Manager&#8217;da TCP\/IP protokol\u00fcn\u00fcn etkin oldu\u011funu ve servisin yeniden ba\u015flat\u0131ld\u0131\u011f\u0131n\u0131 kontrol edin; <a href=\"https:\/\/narhost.com\/destek\/windows-firewall-nasil-yapilandirilir\/\" title=\"Windows g\u00fcvenlik duvar\u0131 nas\u0131l yap\u0131land\u0131r\u0131l\u0131r - Narhost Destek\">g\u00fcvenlik duvar\u0131nda 1433 portunun a\u00e7\u0131k oldu\u011funu<\/a> do\u011frulay\u0131n.<\/li>\n<li><strong>&#8220;Login failed for user&#8221; hatas\u0131 al\u0131yorsunuz.<\/strong> Sunucunun Mixed Mode ile kuruldu\u011fundan ve login&#8217;in devre d\u0131\u015f\u0131 b\u0131rak\u0131lmad\u0131\u011f\u0131ndan emin olun; gerekirse kimlik do\u011frulama modunu <a href=\"https:\/\/narhost.com\/destek\/windows-sunucuda-mssql-sql-server-kurulumu\/\" title=\"Windows Sunucuda MSSQL SQL Server Kurulumu - Narhost Destek\">kurulum kart\u0131ndaki ad\u0131mlarla<\/a> de\u011fi\u015ftirin.<\/li>\n<li><strong>Sunucuya uzaktan eri\u015femiyorsunuz.<\/strong> Ba\u011flant\u0131 ad\u0131mlar\u0131n\u0131 <a href=\"https:\/\/narhost.com\/destek\/windows-sunucuya-uzak-masaustu-baglantisi-rdp-nasil-gerceklestirilir\/\" title=\"Windows sunucuya RDP ba\u011flant\u0131s\u0131 nas\u0131l yap\u0131l\u0131r - Narhost Destek\">RDP ba\u011flant\u0131 rehberinden<\/a> kontrol edin.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Talebe \u015funlar\u0131 ekleyin: sunucu ad\u0131 ya da IP, olu\u015fturmak istedi\u011finiz veritaban\u0131 ad\u0131, ald\u0131\u011f\u0131n\u0131z tam hata mesaj\u0131 ve denedi\u011finiz ad\u0131mlar (\u015fifre payla\u015fmay\u0131n).<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi a\u00e7\">Destek talebi a\u00e7<\/a><\/div>\n<div class=\"kb-ilgili\">\n<p class=\"label\">Sonraki ad\u0131mlar<\/p>\n<ul>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucu-rdp-yonetimi-rehberi\/\" title=\"Windows Sunucu RDP Y\u00f6netimi Rehberi - Narhost Destek\">Windows Sunucu RDP Y\u00f6netimi Rehberi<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucuda-mssql-sql-server-kurulumu\/\" title=\"Windows Sunucuda MSSQL SQL Server Kurulumu - Narhost Destek\">Windows Sunucuda MSSQL Kurulumu<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucuya-uzak-masaustu-baglantisi-rdp-nasil-gerceklestirilir\/\" title=\"Windows sunucuya RDP ba\u011flant\u0131s\u0131 nas\u0131l yap\u0131l\u0131r - Narhost Destek\">Sunucuya RDP ile Ba\u011flanma<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-firewall-nasil-yapilandirilir\/\" title=\"Windows g\u00fcvenlik duvar\u0131 nas\u0131l yap\u0131land\u0131r\u0131l\u0131r - Narhost Destek\">Windows G\u00fcvenlik Duvar\u0131 Ayarlar\u0131<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>MSSQL veritaban\u0131 olu\u015fturma kullan\u0131c\u0131 yetkilendirme i\u00e7in sa hesab\u0131n\u0131 m\u0131 kullanmal\u0131y\u0131m?<\/h3>\n<p>Hay\u0131r. <code>sa<\/code> hesab\u0131 sunucu y\u00f6neticisi hesab\u0131d\u0131r ve uygulamalarda kullan\u0131lmamal\u0131d\u0131r; her uygulama i\u00e7in ayr\u0131, s\u0131n\u0131rl\u0131 yetkili bir login olu\u015fturun.<\/p>\n<h3>Veritaban\u0131m\u0131 sonradan geni\u015fletebilir miyim?<\/h3>\n<p>Evet, sunucunuzdaki disk alan\u0131 yetti\u011fi s\u00fcrece veritaban\u0131 boyutunu SSMS&#8217;te dosya \u00f6zelliklerinden b\u00fcy\u00fctebilirsiniz.<\/p>\n<h3>db_owner m\u0131, db_datareader\/db_datawriter m\u0131 kullanmal\u0131y\u0131m?<\/h3>\n<p>\u00c7o\u011fu uygulama i\u00e7in db_datareader ve db_datawriter yeterlidir; db_owner veritaban\u0131 \u00fczerinde tam yetki verir ve yaln\u0131z y\u00f6netim hesaplar\u0131 i\u00e7in ayr\u0131lmal\u0131d\u0131r.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL veritaban\u0131 olu\u015fturma kullan\u0131c\u0131 yetkilendirme i\u015flemi SQL Server Management Studio (SSMS) ile d\u00f6rt ad\u0131mda yap\u0131l\u0131r: veritaban\u0131, sunucu giri\u015fi (login), kullan\u0131c\u0131 e\u015fleme ve rol atama.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,12],"tags":[221,222,225],"class_list":["post-1825","post","type-post","status-publish","format-standard","hentry","category-windows-hosting","category-vds-server","tag-windows-server","tag-mssql","tag-ssms"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=1825"}],"version-history":[{"count":0,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1825\/revisions"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=1825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=1825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=1825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}