Creating a small project to help with larger projects, so… with VS2013, I created a new MDF file, no issues. Open up SSMS, attached the database… no issues. I even start creating the tables, primary keys, foreign keys, the database diagram, still… no issues. I save everything and create a backup, and then… it happens. Cannot detach database, its in use. Close SSMS, restart the server, open it back up, recovery in process O.o, so I stop/restart the server, nada, disconnect and reconnect to the DB, hey, that fixed it. I close it out (w/o detaching first), open up VS2013, and now, I cannot open the MDF file… login failed O.o… wth.
I go into SSMS, detach the DB, and still failing login with VS2013. After an hour, I copy the DB to another folder, and it allows me to connect to the file in VS2013, wtf? /sigh… first world problems.