I am trying to add the above db sample file to SQL Server 2012. When I try to attach it, I get the error shown at the end.
I am adding it in SSMS. When I select the file, it adds the .mdf and .ldf, and I removed the .ldf. The file is not read-only.
I have also downloaded the AdventureWorks2012 OLTP database, and that attaches fine, I cannot see any difference.
I am sure it is a permissions problem somewhere, but I cannot see where. Anyone have any ideas?
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'VISIZEN'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not open new database 'AdventureWorksDW2012'. CREATE DATABASE is aborted.
File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2012_log.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only. (Microsoft SQL Server, Error: 1813)
For help, click: http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------