{"id":14709,"date":"2025-11-05T12:12:36","date_gmt":"2025-11-05T09:12:36","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=14709"},"modified":"2025-11-05T12:13:41","modified_gmt":"2025-11-05T09:13:41","slug":"docker-ile-sql-server-management-studio-baglanma-islemi","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/docker-ile-sql-server-management-studio-baglanma-islemi\/","title":{"rendered":"Docker ile SQL Server Management Studio Ba\u011flanma \u0130\u015flemi"},"content":{"rendered":"

Yerel makinenize SQL Server kurmadan, h\u0131zl\u0131 bir test ortam\u0131 olu\u015fturmak m\u0131 istiyorsunuz? Docker<\/strong> tam size g\u00f6re. Sizler i\u00e7in bug\u00fcn SQL Server\u2019\u0131 konteyner i\u00e7inde aya\u011fa kald\u0131r\u0131p SSMS ile ba\u011flanmay\u0131<\/strong> ad\u0131m ad\u0131m anlataca\u011f\u0131z. Hadi ba\u015flayal\u0131m. \ud83d\ude42<\/p>\n

Docker Desktop\u2019u Kurun<\/h2>\n

Docker resmi sitesinden<\/a> sisteminize uygun s\u00fcr\u00fcm\u00fc indirin. Kurulumdan sonra bilgisayar\u0131 yeniden ba\u015flat\u0131n ve Docker\u2019\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n.<\/p>\n

SQL Server \u0130maj\u0131n\u0131 \u00c7ekin<\/h2>\n

Terminali (PowerShell\/CMD\/Terminal) y\u00f6netici olarak<\/strong> a\u00e7\u0131n:<\/p>\n

docker pull mcr.microsoft.com\/mssql\/server:2022-latest<\/code><\/pre>\n
Farkl\u0131 s\u00fcr\u00fcm istiyorsan\u0131z:<\/strong> 2019-latest<\/code>, 2017-latest<\/code> gibi etiketleri kullan\u0131n.<\/p>\n
Konteyneri Ba\u015flat\u0131n<\/h2>\n
docker run -d --name mssql-test \\\r\n  -e \"ACCEPT_EULA=Y\" \\\r\n  -e \"MSSQL_SA_PASSWORD=GucluSifre123!\" \\\r\n  -p 1533:1433 \\\r\n  mcr.microsoft.com\/mssql\/server:2022-latest<\/code><\/pre>\n
Parametre A\u00e7\u0131klamalar\u0131:<\/h3>\n\n\n\n\n\n\n\n
Parametre<\/th>\nA\u00e7\u0131klama<\/th>\n<\/tr>\n
-d<\/code><\/td>\nArka planda \u00e7al\u0131\u015f\u0131r<\/td>\n<\/tr>\n
--name mssql-test<\/code><\/td>\nKonteynere isim verir<\/td>\n<\/tr>\n
-p 1533:1433<\/code><\/td>\nYerel 1533 \u2192 Konteyner 1433<\/td>\n<\/tr>\n
MSSQL_SA_PASSWORD<\/code><\/td>\nEn az 8 karakter, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf, rakam, \u00f6zel karakter<\/strong> i\u00e7ermeli<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n
Hata al\u0131rsan\u0131z:<\/strong> docker logs mssql-test<\/code><\/p>\n<\/div>\n
SSMS ile Ba\u011flan\u0131n<\/h2>\n
    \n
  1. SSMS<\/strong>\u2019i a\u00e7\u0131n<\/li>\n
  2. Server name<\/strong>: 127.0.0.1,1533<\/code><\/li>\n
  3. Login<\/strong>: sa<\/code><\/li>\n
  4. Password<\/strong>: GucluSifre123!<\/code><\/li>\n<\/ol>\n
    Ba\u011flant\u0131 kuruldu!<\/strong> Art\u0131k SQL Server\u2019\u0131n\u0131z haz\u0131r.<\/p>\n
    Volume Kullan\u0131n<\/h2>\n
    Konteyner silinirse veriler kaybolur. Bunu \u00f6nlemek i\u00e7in:<\/p>\n
    Volume Olu\u015fturun<\/h3>\n
    docker volume create sql-data<\/code><\/pre>\n
    Volume ile Konteyner Ba\u015flat\u0131n<\/h3>\n
    docker run -d --name mssql-prod \\\r\n  -e \"ACCEPT_EULA=Y\" \\\r\n  -e \"MSSQL_SA_PASSWORD=GucluSifre123!\" \\\r\n  -p 1433:1433 \\\r\n  -v sql-data:\/var\/opt\/mssql \\\r\n  mcr.microsoft.com\/mssql\/server:2022-latest<\/code><\/pre>\n
    Art\u0131k veritaban\u0131 dosyalar\u0131 sql-data<\/code> volume\u2019\u00fcnde saklan\u0131r.<\/p>\n
    Kullan\u0131\u015fl\u0131 Docker Komutlar\u0131<\/h2>\n\n\n\n\n\n\n\n
    Komut<\/th>\nA\u00e7\u0131klama<\/th>\n<\/tr>\n
    docker ps<\/code><\/td>\n\u00c7al\u0131\u015fan konteynerleri listeler<\/td>\n<\/tr>\n
    docker stop mssql-test<\/code><\/td>\nKonteyneri durdurur<\/td>\n<\/tr>\n
    docker start mssql-test<\/code><\/td>\nKonteyneri ba\u015flat\u0131r<\/td>\n<\/tr>\n
    docker rm mssql-test<\/code><\/td>\nKonteyneri siler (volume silinmez)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    Sizlerle payla\u015ft\u0131\u011f\u0131m\u0131z bu y\u00f6ntemle:<\/p>\n