TITLE: Microsoft SQL Server Management Studio —————————— Attach database failed for Server ”. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17224.0+((SSMS_Rel_17_4).180212-1043)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— Database ” cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery. Could not open new database ”. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 3415)

Merhaba,

 

Sql server management studio’da halihazırda olan .mdf uzantılı database file’nızı import etmek isterken aşağıdaki şekilde bir hatayla karşılaşıyorsanız ,

TITLE: Microsoft SQL Server Management Studio —————————— Attach database failed for Server ”. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17224.0+((SSMS_Rel_17_4).180212-1043)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&

EvtID=Attach+database+Server&nkIdLi=20476 —————————— ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— Database ” cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery. Could not open new database ”. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 3415)

TITLE Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server ''. (Microsoft.SqlServer.Smo) For help, click httpgo.microsoft.comfwlinkProdName=Microsoft+SQL+Server&ProdVer=14.0.17

Çözüm olarak;

Sql server kurulu olan diskinizi seçerek ,

C:\Program Files\Microsoft SQL Server\MSSQL13.OG\MSSQL\DATA

altına eklemek istediğiniz .mdf uzantılı dosyayı atınız  ve tekrardan deneyiniz.

Microsoft tarafında detay için tıklayınız.

For help, click: http://go.microsoft.com/fwlinkProdName=Microsoft%20SQL%20Server&ProdVer=13.00.1601&

EvtSrc=MSSQLServer&EvtID=3415&LinkId=20476

Sağlıcakla.

Oğuz ALTUNTAŞ © 2018

error: Oğuz ALTUNTAŞ © 2020