Posted on: 8/5/2013 4:19:31 AM | Views : 720

This issue seems to have been raised before but unfortunately I haven't been able to resolve my problem. My installation of localdb seems to have gone OK. I can create a local database (.mdf) file through Visual Studio 2012 Express (Although I have not yet been able to connect to it from a VBA program - However, for the moment, that is a separate issue).
When I try to create a database using the SQL Server Management Studio, I can connect to (localDB)\v11.0 but when I attempt to create a new database I get the following message:
"A file activation error occurred. The physical file name "xxxx.mdf" may be incorrect. Diagnose and correct additional errors and retry the operation. CREATE DATABASE failed. Some file names could not be created. Check related errors. (Microsoft SQL Server, Error 5105)" 
I have attached the creation script below:

Go to the complete details ...