{"id":15715,"date":"2026-09-16T16:56:55","date_gmt":"2026-09-16T13:56:55","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=15715"},"modified":"2026-09-16T16:56:55","modified_gmt":"2026-09-16T13:56:55","slug":"mssql-veritabani-baglanti-ve-yonetim-rehberi","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mssql-veritabani-baglanti-ve-yonetim-rehberi\/","title":{"rendered":"MSSQL Veritaban\u0131 Ba\u011flant\u0131 Ve Y\u00f6netim Rehberi"},"content":{"rendered":"

\u0130netmar ailesi olarak bu yaz\u0131m\u0131zda hosting hesab\u0131n\u0131zdaki MSSQL veritaban\u0131na SQL Server Management Studio (SSMS) ile nas\u0131l ba\u011flanaca\u011f\u0131n\u0131z\u0131 ve temel i\u015flemleri nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 anlataca\u011f\u0131z.<\/p>\n

1. Gerekli program<\/h2>\n

SQL Server Management Studio (SSMS)<\/strong> \u2014 Microsoft’un \u00fccretsiz veritaban\u0131 y\u00f6netim arac\u0131.<\/p>\n

\u0130ndirme:<\/strong> Microsoft’un resmi sitesinden “SQL Server Management Studio download” aramas\u0131 ile ula\u015fabilirsiniz.<\/p>\n

2. Ba\u011flant\u0131 bilgileri<\/h2>\n

Bu bilgiler Plesk panelinizde Veritabanlar\u0131<\/em> b\u00f6l\u00fcm\u00fcnde yer al\u0131r:<\/p>\n\n\n\n\n\n\n\n\n\n
Alan<\/th>\nDe\u011fer<\/th>\n<\/tr>\n<\/thead>\n
Sunucu Ad\u0131<\/td>\n<sunucu_ip_veya_adresi><\/code><\/td>\n<\/tr>\n
Kimlik Do\u011frulama<\/td>\nSQL Server Kimlik Do\u011frulamas\u0131<\/td>\n<\/tr>\n
Kullan\u0131c\u0131 Ad\u0131<\/td>\n<panelde_yazan_kullan\u0131c\u0131><\/code><\/td>\n<\/tr>\n
Parola<\/td>\n<panelde_belirledi\u011finiz_parola><\/code><\/td>\n<\/tr>\n
Veritaban\u0131 Ad\u0131<\/td>\n<panelde_yazan_veritaban\u0131_ad\u0131><\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

3. Ba\u011flanma ad\u0131mlar\u0131<\/h2>\n

SSMS’i a\u00e7t\u0131\u011f\u0131n\u0131zda gelen Ba\u011flan penceresinde:<\/p>\n

    \n
  1. Sunucu Ad\u0131 alan\u0131na sunucu adresini yaz\u0131n<\/li>\n
  2. Kimlik Do\u011frulamas\u0131 olarak “SQL Server Kimlik Do\u011frulamas\u0131” se\u00e7in<\/li>\n
  3. Kullan\u0131c\u0131 ad\u0131 ve parolan\u0131z\u0131 girin<\/li>\n
  4. Veritaban\u0131 Ad\u0131 alan\u0131na veritaban\u0131n\u0131z\u0131n ad\u0131n\u0131 yaz\u0131n<\/li>\n
  5. Sunucu Sertifikas\u0131na G\u00fcven<\/strong> kutusunu i\u015faretleyin<\/li>\n
  6. Ba\u011flan butonuna bas\u0131n<\/li>\n<\/ol>\n

    \u00d6nemli: Veritaban\u0131 Ad\u0131 alan\u0131<\/h3>\n

    Bu alan bo\u015f b\u0131rak\u0131lmamal\u0131d\u0131r. G\u00fcvenlik yap\u0131land\u0131rmam\u0131z gere\u011fi, sunucudaki veritaban\u0131 listesi kullan\u0131c\u0131lara kapal\u0131d\u0131r \u2014 b\u00f6ylece hi\u00e7bir m\u00fc\u015fteri di\u011fer m\u00fc\u015fterilerin veritabanlar\u0131n\u0131 g\u00f6remez. Veritaban\u0131 ad\u0131n\u0131 yazarak ba\u011fland\u0131\u011f\u0131n\u0131zda kendi veritaban\u0131n\u0131za sorunsuz eri\u015firsiniz.<\/p>\n

    Bu alan pencerede g\u00f6r\u00fcnm\u00fcyorsa Se\u00e7enekler >><\/strong> butonuna basarak geni\u015fletin.<\/p>\n

    Sertifika uyar\u0131s\u0131 al\u0131rsan\u0131z<\/h3>\n

    “The certificate chain was issued by an authority that is not trusted”<\/em> hatas\u0131 al\u0131rsan\u0131z, Sunucu Sertifikas\u0131na G\u00fcven<\/strong> kutusunu i\u015faretlemeyi atlam\u0131\u015fs\u0131n\u0131z demektir. Kutuyu i\u015faretleyip tekrar deneyin.<\/p>\n

    4. \u00c7al\u0131\u015fma y\u00f6ntemi<\/h2>\n

    Ba\u011fland\u0131ktan sonra sol taraftaki Nesne Gezgini a\u011fac\u0131nda veritaban\u0131n\u0131z listelenmez. Bu normaldir ve yukar\u0131da a\u00e7\u0131klanan g\u00fcvenlik yap\u0131land\u0131rmas\u0131ndan kaynaklan\u0131r.<\/p>\n

    \u0130\u015flemlerinizi sorgu penceresi \u00fczerinden yapars\u0131n\u0131z:<\/p>\n

      \n
    • \u00dcst men\u00fcden Yeni Sorgu (New Query)<\/strong> butonuna bas\u0131n<\/li>\n
    • Sorgunuzu yaz\u0131n<\/li>\n
    • F5<\/code> tu\u015fu veya Y\u00fcr\u00fct (Execute)<\/strong> butonu ile \u00e7al\u0131\u015ft\u0131r\u0131n<\/li>\n<\/ul>\n

      5. Temel sorgular<\/h2>\n

      Hangi veritaban\u0131na ba\u011fl\u0131y\u0131m?<\/h3>\n

      Veritaban\u0131 ad\u0131n\u0131z\u0131 d\u00f6nd\u00fcrmelidir. Farkl\u0131 bir \u015fey d\u00f6nerse ba\u011flant\u0131da veritaban\u0131 ad\u0131n\u0131 yazmay\u0131 atlam\u0131\u015fs\u0131n\u0131z demektir.<\/p>\n

      SELECT DB_NAME();<\/pre>\n
      Tablolar\u0131m\u0131 listele<\/h3>\n
      SELECT TABLE_NAME\r\nFROM INFORMATION_SCHEMA.TABLES\r\nWHERE TABLE_TYPE = 'BASE TABLE'\r\nORDER BY TABLE_NAME;<\/pre>\n
      Bir tablonun s\u00fctunlar\u0131n\u0131 g\u00f6r<\/h3>\n
      SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE\r\nFROM INFORMATION_SCHEMA.COLUMNS\r\nWHERE TABLE_NAME = 'tablo_adiniz'\r\nORDER BY ORDINAL_POSITION;<\/pre>\n
      Tablo i\u00e7eri\u011fini g\u00f6r\u00fcnt\u00fcle<\/h3>\n
      TOP 100<\/code> ilk 100 sat\u0131r\u0131 getirir. B\u00fcy\u00fck tablolarda tamam\u0131n\u0131 \u00e7ekmek yerine bunu kullanman\u0131z \u00f6nerilir.<\/p>\n
      SELECT TOP 100 * FROM tablo_adiniz;<\/pre>\n
      Kay\u0131t say\u0131s\u0131n\u0131 \u00f6\u011fren<\/h3>\n
      SELECT COUNT(*) FROM tablo_adiniz;<\/pre>\n
      T\u00fcm tablolar\u0131n kay\u0131t say\u0131lar\u0131n\u0131 topluca g\u00f6r<\/h3>\n
      SELECT t.name AS tablo, SUM(p.rows) AS kayit_sayisi\r\nFROM sys.tables t\r\nJOIN sys.partitions p ON t.object_id = p.object_id\r\nWHERE p.index_id IN (0, 1)\r\nGROUP BY t.name\r\nORDER BY t.name;<\/pre>\n
      Veritaban\u0131 boyutunu \u00f6\u011fren<\/h3>\n
      SELECT\r\nname AS dosya,\r\nsize * 8 \/ 1024 AS boyut_mb\r\nFROM sys.database_files;<\/pre>\n
      G\u00f6r\u00fcn\u00fcmleri (View) listele<\/h3>\n
      SELECT TABLE_NAME\r\nFROM INFORMATION_SCHEMA.VIEWS\r\nORDER BY TABLE_NAME;<\/pre>\n
      Sakl\u0131 yordamlar\u0131 (Stored Procedure) listele<\/h3>\n
      SELECT name\r\nFROM sys.procedures\r\nORDER BY name;<\/pre>\n
      6. Tablo olu\u015fturma ve d\u00fczenleme<\/h2>\n
      Yeni tablo olu\u015ftur<\/h3>\n
      CREATE TABLE musteriler (\r\nid INT IDENTITY(1,1) PRIMARY KEY,\r\nad NVARCHAR(100) NOT NULL,\r\neposta NVARCHAR(150),\r\nkayit_tarihi DATETIME DEFAULT GETDATE()\r\n);<\/pre>\n
      S\u00fctun ekle<\/h3>\n
      ALTER TABLE musteriler ADD telefon NVARCHAR(20);<\/pre>\n
      S\u00fctun sil<\/h3>\n
      ALTER TABLE musteriler DROP COLUMN telefon;<\/pre>\n
      Tablo sil<\/h3>\n
      DROP TABLE musteriler;<\/pre>\n
      Bu i\u015flem geri al\u0131namaz. Silmeden \u00f6nce verilerinizi yedekledi\u011finizden emin olun.<\/em><\/p>\n
      7. Yedekleme<\/h2>\n
      Veritaban\u0131n\u0131z\u0131n yede\u011fini Plesk paneli \u00fczerinden alabilirsiniz: Veritabanlar\u0131<\/strong> b\u00f6l\u00fcm\u00fcnde ilgili veritaban\u0131n\u0131n yan\u0131ndaki d\u0131\u015fa aktarma se\u00e7ene\u011fini kullan\u0131n.<\/p>\n
      SSMS \u00fczerinden komutla yedek alma yetkisi g\u00fcvenlik gere\u011fi k\u0131s\u0131tl\u0131d\u0131r.<\/p>\n
      Verilerinizi SQL beti\u011fi olarak almak isterseniz sorgu sonu\u00e7lar\u0131n\u0131 kopyalayabilir veya SSMS’in Sonu\u00e7lar\u0131 Dosyaya Kaydet<\/strong> \u00f6zelli\u011fini kullanabilirsiniz.<\/p>\n
      8. S\u0131k kar\u015f\u0131la\u015f\u0131lan durumlar<\/h2>\n\n\n\n\n\n\n\n\n\n
      Durum<\/th>\nSebep ve \u00e7\u00f6z\u00fcm<\/th>\n<\/tr>\n<\/thead>\n
      Veritaban\u0131 a\u011fa\u00e7ta g\u00f6r\u00fcnm\u00fcyor<\/td>\nNormaldir. Sorgu penceresi \u00fczerinden \u00e7al\u0131\u015f\u0131n.<\/td>\n<\/tr>\n
      “Login failed for user”<\/td>\nKullan\u0131c\u0131 ad\u0131 veya parola hatal\u0131. Plesk panelinden kontrol edin.<\/td>\n<\/tr>\n
      Sertifika hatas\u0131<\/td>\n“Sunucu Sertifikas\u0131na G\u00fcven” kutusunu i\u015faretleyin.<\/td>\n<\/tr>\n
      DB_NAME() master d\u00f6n\u00fcyor<\/td>\nBa\u011flant\u0131da veritaban\u0131 ad\u0131n\u0131 yazmam\u0131\u015fs\u0131n\u0131z. Ba\u011flant\u0131y\u0131 kapat\u0131p tekrar kurun.<\/td>\n<\/tr>\n
      “Invalid object name”<\/td>\nTablo ad\u0131 hatal\u0131 veya farkl\u0131 bir veritaban\u0131ndas\u0131n\u0131z.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      9. Uygulama ba\u011flant\u0131 dizesi<\/h2>\n
      Web uygulaman\u0131zdan ba\u011flanmak i\u00e7in kullanaca\u011f\u0131n\u0131z ba\u011flant\u0131 dizesi \u00f6rnekleri:<\/p>\n
      .NET \/ ASP.NET<\/h3>\n
      Server=<sunucu_adresi>;Database=<veritabani_adi>;User Id=<kullanici>;Password=<parola>;TrustServerCertificate=True;<\/pre>\n
      PHP (PDO)<\/h3>\n
      $dsn = \"sqlsrv:Server=<sunucu_adresi>;Database=<veritabani_adi>;TrustServerCertificate=True\";\r\n$pdo = new PDO($dsn, \"<kullanici>\", \"<parola>\");<\/pre>\n
      Classic ASP (ADO)<\/h3>\n
      Provider=SQLOLEDB;Data Source=<sunucu_adresi>;Initial Catalog=<veritabani_adi>;User Id=<kullanici>;Password=<parola>;<\/pre>\n
      Ba\u011flant\u0131 dizesinde veritaban\u0131 ad\u0131n\u0131 belirtti\u011finiz i\u00e7in uygulamalar\u0131n\u0131z bu k\u0131s\u0131tlamadan etkilenmez.<\/p>\n
      10. Destek<\/h2>\n
      Ba\u011flant\u0131 veya yetki konusunda sorun ya\u015farsan\u0131z destek talebi a\u00e7abilirsiniz. Talebinizde \u015funlar\u0131 belirtmeniz \u00e7\u00f6z\u00fcm\u00fc h\u0131zland\u0131r\u0131r:<\/p>\n
        \n
      • Veritaban\u0131 ad\u0131<\/li>\n
      • Kullan\u0131c\u0131 ad\u0131<\/li>\n
      • Ald\u0131\u011f\u0131n\u0131z hata mesaj\u0131n\u0131n tam metni<\/li>\n
      • Hangi ad\u0131mda hata ald\u0131\u011f\u0131n\u0131z<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        \u0130netmar ailesi olarak bu yaz\u0131m\u0131zda hosting hesab\u0131n\u0131zdaki MSSQL veritaban\u0131na SQL Server Management Studio (SSMS) ile nas\u0131l ba\u011flanaca\u011f\u0131n\u0131z\u0131 ve temel i\u015flemleri nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 anlataca\u011f\u0131z. 1. Gerekli program SQL Server Management Studio (SSMS) \u2014 Microsoft’un \u00fccretsiz veritaban\u0131...<\/p>\n","protected":false},"author":2,"featured_media":15718,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-15715","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/15715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=15715"}],"version-history":[{"count":2,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/15715\/revisions"}],"predecessor-version":[{"id":15717,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/15715\/revisions\/15717"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/15718"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=15715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=15715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=15715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}