Thanks for all your help at those hours in the morning haha!

Hi,

Thanks for your help, the issue was the Permissions.

Eventually once i had updated my admin accounts on my desktop it allowed me to attach the DB after deleting the...

After running the command you stated before this is the error:

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Log.ldf" may be incorrect.

Msg 5123, Level 16, State 1, Line...

The command

Create database test;

GO

Completed successfully ....

Not sure if this is what you mean:

How do i verify the accounts? Basically i have just installed tonight and set only one user with default settings. How can i change this?

Basically i am the only user...

Here are two print screens again, the first with the log file still attached the second with the log file removed ...

And here is how it looks when i...

Could it be that i have not a defined admin account? Apart from the sole account i set it up with (Default settings) ?

Also in the SSCM should i have...

I have two sample databases:

AdventureWorks2008R2_Data.mdf

AdventureWorksDW2008R2_Data.mdf

Neither will attach

C:\Program Files\Microsoft SQL Server\100\Tools\Samples\ ..File name.

Ive even just tried right clicking on SSMS and running as administrator. Still doesnt work

Right i installed this pretty quick and it has updated my version:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright...

Thanks im running the update now, fingers crossed it will now work.

ill give it a go in the morning and leave the update running tonight.

Thanks again

Sorry Jason i am totally new to this, so i should download the SP1 from the link i have shown? I thought in the reply earlier from me it states...

Thanks for your help!

Would i need to download this by any chance: http://www.microsoft.com/en-us/download/details.aspx?id=26727 (SQLServer2008R2SP1-KB2528583-x64-ENU.exe)

This is what came back:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer Edition (64-bit)...

Still the same error unfortunately;

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Log.ldf" may be incorrect.

Msg 5123, Level 16, State 1, Line 1

CREATE FILE encountered operating system...