Hi guys,
I have a question. Can anyone telle me how to attach a database generated by DotNetNuke 4.5.5 web site to SQL Server 2005 Standard Edition on a machine running Windows Vista Business OS.
I had successfully installed it before on an XP machine but on Windows Vista, I am continously getting Log file error messages. When I atach the database, it shows 2 files, an mdf and a log file, I simply delete the log file and attach database then it gives me error message that log file can not be created. Following is the error message.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'DEV01\SQLSTANDARD2005'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&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)
------------------------------
Could not open new database 'DMD'. CREATE DATABASE is aborted.
File activation failure. The physical file name "C:\DotNetNuke_Build\Website\App_Data\Database2_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?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=1813&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Can anybody help me sorting out this problem?
Thanks.