{"id":4722,"date":"2025-10-02T11:16:50","date_gmt":"2025-10-02T08:16:50","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=4722"},"modified":"2026-10-03T12:39:24","modified_gmt":"2026-10-03T09:39:24","slug":"localdbyi-baslatma-ve-localdbye-baglanma","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/localdbyi-baslatma-ve-localdbye-baglanma\/","title":{"rendered":"MSSQL LocalDB’yi ba\u015flatma ve LocalDB’ye ba\u011flanma"},"content":{"rendered":"
\n

LocalDB’yi ba\u015flatma ve LocalDB’ye ba\u011flanma<\/h2>\n<\/div>\n

Otomatik \u00f6rne\u011fe ba\u011flanma<\/p>\n

LocalDB kullanman\u0131n en kolay yolu, ba\u011flant\u0131 dizesini Server=(localdb)\\MSSQLLocalDB;Integrated Security=true<\/code>kullanarak ge\u00e7erli kullan\u0131c\u0131n\u0131n sahip oldu\u011fu otomatik \u00f6rne\u011fe ba\u011flanmakt\u0131r.<\/p>\n

Dosya ad\u0131n\u0131 kullanarak belirli bir veritaban\u0131na ba\u011flanmak i\u00e7in, benzeri<\/p>\n

Server=(LocalDB)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName=D:\\Data\\MyDB1.mdf<\/code><\/p>\n

<\/code>bir ba\u011flant\u0131 dizesi kullanarak baplan\u0131labilir.<\/p>\n

\n

Not<\/p>\n

Bilgisayardaki bir kullan\u0131c\u0131 LocalDB’ye ilk kez ba\u011flanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131nda, otomatik \u00f6rne\u011fin hem olu\u015fturulmas\u0131 hem de ba\u015flat\u0131lmas\u0131 gerekir.<\/p>\n

\u00d6rne\u011fin olu\u015fturulmas\u0131 i\u00e7in ek s\u00fcre, ba\u011flant\u0131 giri\u015fiminin zaman a\u015f\u0131m\u0131 iletisiyle ba\u015far\u0131s\u0131z olmas\u0131na neden olabilir. Bu durumda, olu\u015fturma i\u015fleminin tamamlanmas\u0131n\u0131 sa\u011flamak i\u00e7in birka\u00e7 saniye bekleyin ve yeniden ba\u011flan\u0131n.<\/p>\n<\/div>\n

\n

Adland\u0131r\u0131lm\u0131\u015f \u00f6rnek olu\u015fturma ve bu \u00f6rne\u011fe ba\u011flanma<\/h3>\n<\/div>\n

LocalDB, otomatik \u00f6rne\u011fe ek olarak adland\u0131r\u0131lm\u0131\u015f \u00f6rnekleri de destekler. LocalDB’nin SqlLocalDB.exe<\/code> adland\u0131r\u0131lm\u0131\u015f bir \u00f6rne\u011fini olu\u015fturmak,<\/p>\n

ba\u015flatmak ve durdurmak i\u00e7in program\u0131 kullan\u0131n. hakk\u0131nda SqlLocalDB.exe<\/code>daha fazla bilgi i\u00e7in bkz . SqlLocalDB yard\u0131mc\u0131 program\u0131<\/a>.<\/p>\n

\n

Konsol<\/span><\/p>\n

<\/div>\n<\/div>\n
REM Create an instance of LocalDB\r\n\"C:\\Program Files\\Microsoft SQL Server\\160\\Tools\\Binn\\SqlLocalDB.exe\" create LocalDBApp1\r\nREM Start the instance of LocalDB\r\n\"C:\\Program Files\\Microsoft SQL Server\\160\\Tools\\Binn\\SqlLocalDB.exe\" start LocalDBApp1\r\nREM Gather information about the instance of LocalDB\r\n\"C:\\Program Files\\Microsoft SQL Server\\160\\Tools\\Binn\\SqlLocalDB.exe\" info LocalDBApp1\r\n<\/code><\/pre>\n
\u00d6nceki kod \u00f6rne\u011findeki son sat\u0131r, a\u015fa\u011f\u0131daki tabloya benzer bilgiler d\u00f6nd\u00fcr\u00fcr.<\/p>\n
<\/div>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n
Kategori<\/th>\nDe\u011fer<\/th>\n<\/tr>\n<\/thead>\n
\u0130sim<\/strong><\/td>\nLocalDBApp1<\/code><\/td>\n<\/tr>\n
S\u00fcr\u00fcm<\/strong><\/td>\n<Current version><\/code><\/td>\n<\/tr>\n
Payla\u015f\u0131lan ad<\/strong><\/td>\n\"\"<\/code><\/td>\n<\/tr>\n
Sahibi<\/strong><\/td>\n<Your Windows user><\/code><\/td>\n<\/tr>\n
Otomatik olu\u015fturma<\/strong><\/td>\nNo<\/code><\/td>\n<\/tr>\n
Eyalet<\/strong><\/td>\nRunning<\/code><\/td>\n<\/tr>\n
Son ba\u015flang\u0131\u00e7 saati<\/strong><\/td>\n<Date and time><\/code><\/td>\n<\/tr>\n
\u00d6rnek kanal\u0131 ad\u0131<\/strong><\/td>\nnp:\\\\.\\pipe\\LOCALDB#F365A78E\\tsql\\query<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n
Not<\/p>\n
Uygulaman\u0131z 4.0.2’den \u00f6nce bir .NET Framework s\u00fcr\u00fcm\u00fc kullan\u0131yorsa, do\u011frudan LocalDB’nin adland\u0131r\u0131lm\u0131\u015f kanal\u0131na ba\u011flanman\u0131z gerekir.<\/p>\n
\u00d6rnek kanal ad\u0131 de\u011feri, LocalDB \u00f6rne\u011finin dinledi\u011fi adland\u0131r\u0131lm\u0131\u015f kanald\u0131r.<\/p>\n
\u00d6rnek kanal ad\u0131n\u0131n sonraki LOCALDB#<\/code> b\u00f6l\u00fcm\u00fc, LocalDB \u00f6rne\u011fi her ba\u015flat\u0131ld\u0131\u011f\u0131nda de\u011fi\u015fir.<\/p>\n
SQL Server Management Studio kullanarak LocalDB \u00f6rne\u011fine ba\u011flanmak i\u00e7in, <\/strong><\/p>\n
Veritaban\u0131 Altyap\u0131s\u0131na Ba\u011flan<\/strong> ileti\u015fim kutusunun Sunucu ad\u0131<\/strong> kutusuna \u00f6rnek kanal\u0131 ad\u0131n\u0131 yaz\u0131n.<\/p>\n
\u00d6zel program\u0131n\u0131zdan \u015funa benzer bir ba\u011flant\u0131 dizesi kullanarak LocalDB \u00f6rne\u011fine ba\u011flant\u0131 kurabilirsiniz:<\/p>\n
SqlConnection conn = new SqlConnection(@\"Server=np:\\\\.\\pipe\\LOCALDB#F365A78E\\tsql\\query\");<\/code><\/p>\n<\/div>\n
\n
LocalDB’nin payla\u015f\u0131lan bir \u00f6rne\u011fine ba\u011flanma<\/h3>\n<\/div>\n
LocalDB’nin payla\u015f\u0131lan bir \u00f6rne\u011fine ba\u011flanmak i\u00e7in, payla\u015f\u0131lan \u00f6rnekler i\u00e7in ayr\u0131lm\u0131\u015f ad alan\u0131na ba\u015fvurmak \u00fczere ba\u011flant\u0131 dizesine \\.\\<\/code> (ters e\u011fik \u00e7izgi + nokta + ters e\u011fik \u00e7izgi) ekleyin.<\/p>\n
\u00d6rne\u011fin, AppData<\/code> adl\u0131 payla\u015f\u0131lan bir LocalDB \u00f6rne\u011fine ba\u011flanmak i\u00e7in, (localdb)\\.\\AppData<\/code> gibi bir ba\u011flant\u0131 dizesi kullan\u0131n.<\/p>\n
Sahibi olmad\u0131\u011f\u0131 payla\u015f\u0131lan bir LocalDB \u00f6rne\u011fine ba\u011flanmak isteyen bir kullan\u0131c\u0131n\u0131n,<\/p>\n
Windows Kimlik Do\u011frulamas\u0131 veya SQL Server Kimlik Do\u011frulamas\u0131 giri\u015f bilgileri olmal\u0131d\u0131r.<\/p>\n
\n
Sorun giderme<\/h2>\n<\/div>\n
LocalDB, ge\u00e7erli kullan\u0131c\u0131n\u0131n ba\u011flam\u0131 alt\u0131nda basit bir \u00f6rnek olarak \u00e7al\u0131\u015f\u0131r.<\/p>\n
Bu, sorunlar\u0131n \u00e7o\u011funun sunucu d\u00fczeyinde yap\u0131land\u0131rma yerine \u00f6rnek durumu, dosya izinleri veya s\u00fcr\u00fcm uyu\u015fmazl\u0131klar\u0131yla ilgili oldu\u011fu anlam\u0131na gelir.<\/p>\n
A\u015fa\u011f\u0131daki ad\u0131mlar, en yayg\u0131n LocalDB sorunlar\u0131n\u0131 tan\u0131laman\u0131za ve \u00e7\u00f6zmenize yard\u0131mc\u0131 olabilir.<\/p>\n
\n
En son s\u00fcr\u00fcme y\u00fckseltme<\/h3>\n<\/div>\n
Bir\u00e7ok yayg\u0131n LocalDB sorunu SQL Server Express’in en son s\u00fcr\u00fcm\u00fcne y\u00fckseltilerek \u00e7\u00f6z\u00fcl\u00fcr. Y\u00fckleme medyas\u0131<\/a> b\u00f6l\u00fcm\u00fcnden en son s\u00fcr\u00fcm\u00fc indirin ve LocalDB’yi y\u00fckleyin. Daha yeni s\u00fcr\u00fcm, mevcut LocalDB ikili dosyalar\u0131n\u0131n yerini al\u0131r ve bilinen kararl\u0131l\u0131k ve uyumluluk sorunlar\u0131na y\u00f6nelik d\u00fczeltmeler i\u00e7erir.<\/p>\n
Y\u00fckselttikten sonra, g\u00fcncelle\u015ftirilmi\u015f ikili dosyalar\u0131 kullanmak i\u00e7in \u00f6rneklerinizi silin ve yeniden olu\u015fturun:<\/p>\n
\n
Windows Komut \u0130stemi<\/span><\/strong><\/p>\n
<\/div>\n<\/div>\n
sqllocaldb stop MSSQLLocalDB\r\nsqllocaldb delete MSSQLLocalDB\r\nsqllocaldb create MSSQLLocalDB\r\nsqllocaldb start<\/span> MSSQLLocalDB\r\n<\/code><\/pre>\n
\n
Dikkat<\/p>\n
Bir \u00f6rne\u011fi silmek, bu \u00f6rnekle ili\u015fkili t\u00fcm veritabanlar\u0131n\u0131 kald\u0131r\u0131r. \u00d6nemli verileri silmeden \u00f6nce yedekleyin.<\/p>\n<\/div>\n
\n
Y\u00fckleme ve \u00f6rnek durumunu do\u011frulama<\/h3>\n<\/div>\n
LocalDB’nin y\u00fckl\u00fc oldu\u011funu onaylamak ve \u00f6rne\u011finizin durumunu denetlemek i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n
\n
Windows Komut \u0130stemi<\/span><\/strong><\/p>\n
<\/div>\n<\/div>\n
sqllocaldb info\r\nsqllocaldb info MSSQLLocalDB\r\n<\/code><\/pre>\n
\u0130lk komut t\u00fcm \u00f6rnekleri listeler. \u0130kinci komut belirli bir \u00f6rne\u011fin s\u00fcr\u00fcm\u00fcn\u00fc, sahibini ve durumunu (\u00c7al\u0131\u015f\u0131yor veya Durduruldu) g\u00f6sterir.<\/p>\n
Tan\u0131nm\u0131yorsa sqllocaldb<\/code> LocalDB y\u00fcklenmemi\u015f veya y\u00fckleme yolu sistem PATH<\/code> de\u011fi\u015fkeninde olmayabilir.<\/p>\n
\u00c7al\u0131\u015fmayan bir \u00f6rne\u011fi ba\u015flatmak i\u00e7in:<\/p>\n
\n
Windows Komut \u0130stemi<\/span><\/p>\n
<\/div>\n<\/div>\n
sqllocaldb start<\/span> MSSQLLocalDB\r\n<\/code><\/pre>\n
\n
Hata g\u00fcnl\u00fcklerini g\u00f6zden ge\u00e7irme<\/h3>\n<\/div>\n
LocalDB, hata g\u00fcnl\u00fcklerini kullan\u0131c\u0131n\u0131n AppData<\/code> klas\u00f6r\u00fcne yazar:<\/p>\n
%LOCALAPPDATA%\\Microsoft\\Microsoft SQL Server Local DB\\Instances\\MSSQLLocalDB\\error.log<\/code><\/p>\n
Belirli hata iletilerini, ba\u015flatma hatalar\u0131n\u0131 veya yap\u0131land\u0131rma sorunlar\u0131n\u0131 denetlemek i\u00e7in bu dosyay\u0131 bir metin d\u00fczenleyicisinde a\u00e7\u0131n.<\/p>\n
\n
\u0130zinler<\/h2>\n<\/div>\n
SQL Server Express LocalDB \u00f6rne\u011fi, bir kullan\u0131c\u0131 taraf\u0131ndan kullan\u0131m\u0131 i\u00e7in olu\u015fturulan bir \u00f6rnektir. Bilgisayardaki herhangi bir kullan\u0131c\u0131 LocalDB \u00f6rne\u011fini kullanarak veritaban\u0131 olu\u015fturabilir, dosyalar\u0131 kendi kullan\u0131c\u0131 profili alt\u0131nda depolayabilir ve i\u015flemi kimlik bilgileri alt\u0131nda \u00e7al\u0131\u015ft\u0131rabilir. Varsay\u0131lan olarak, LocalDB \u00f6rne\u011fine eri\u015fim sahibiyle s\u0131n\u0131rl\u0131d\u0131r. LocalDB’de yer alan veriler, veritaban\u0131 dosyalar\u0131na dosya sistemi eri\u015fimiyle korunur. Kullan\u0131c\u0131 veritaban\u0131 dosyalar\u0131 payla\u015f\u0131lan bir konumda depolan\u0131yorsa, veritaban\u0131, sahip oldu\u011fu bir LocalDB \u00f6rne\u011fi kullan\u0131larak bu konuma dosya sistemi eri\u015fimi olan herkes taraf\u0131ndan a\u00e7\u0131labilir. Veritaban\u0131 dosyalar\u0131 kullan\u0131c\u0131lar veri klas\u00f6r\u00fc gibi korumal\u0131 bir konumdaysa, veritaban\u0131n\u0131 yaln\u0131zca o kullan\u0131c\u0131 ve bu klas\u00f6re eri\u015fimi olan t\u00fcm y\u00f6neticiler a\u00e7abilir. LocalDB dosyalar\u0131 bir kerede yaln\u0131zca bir LocalDB \u00f6rne\u011fi taraf\u0131ndan a\u00e7\u0131labilir.<\/p>\n
LocalDB her zaman kullan\u0131c\u0131n\u0131n g\u00fcvenlik ba\u011flam\u0131 alt\u0131nda \u00e7al\u0131\u015f\u0131r. LocalDB hi\u00e7bir zaman yerel Y\u00f6neticiler grubundan kimlik bilgileriyle \u00e7al\u0131\u015fmaz. Bu, LocalDB \u00f6rne\u011fi taraf\u0131ndan kullan\u0131lan t\u00fcm veritaban\u0131 dosyalar\u0131na, yerel Administrators grubu \u00fcyeli\u011fi d\u00fc\u015f\u00fcn\u00fclmeden sahip olan kullan\u0131c\u0131n\u0131n Windows hesab\u0131 kullan\u0131larak eri\u015filebilir olmas\u0131 gerekti\u011fi anlam\u0131na gelir.<\/p>\n
 <\/p>\n
Kaynak : SQL Server Express LocalDB (Yerel Veritaban\u0131 Motoru) – SQL Server | Microsoft Learn<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
LocalDB’yi ba\u015flatma ve LocalDB’ye ba\u011flanma Otomatik \u00f6rne\u011fe ba\u011flanma LocalDB kullanman\u0131n en kolay yolu, ba\u011flant\u0131 dizesini Server=(localdb)\\MSSQLLocalDB;Integrated Security=truekullanarak ge\u00e7erli kullan\u0131c\u0131n\u0131n sahip oldu\u011fu otomatik \u00f6rne\u011fe ba\u011flanmakt\u0131r. Dosya ad\u0131n\u0131 kullanarak belirli bir veritaban\u0131na ba\u011flanmak i\u00e7in, benzeri Server=(LocalDB)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName=D:\\Data\\MyDB1.mdf bir ba\u011flant\u0131 dizesi kullanarak baplan\u0131labilir. Not Bilgisayardaki bir kullan\u0131c\u0131 LocalDB’ye ilk kez ba\u011flanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131nda, otomatik \u00f6rne\u011fin hem olu\u015fturulmas\u0131 hem de […]<\/p>\n","protected":false},"author":4,"featured_media":4723,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-4722","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=4722"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4722\/revisions"}],"predecessor-version":[{"id":4725,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4722\/revisions\/4725"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/4723"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=4722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=4722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=4722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}