Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible version of the AdventureWorks database to make sure it was working. To do so, I right clicked on my main database server in the explorer window > Restore Database and attempted to mount a .bak file using Source > Device > Add. I downloaded the AdVentureWorks .bak file from http://msftdbprodsamples.codeplex.com/releases/view/55330 into my user directory, however when I try to access this directory, it comes up blank:

SQL Server Management Studio

I'm currently authenticated using my Microsoft account (i.e. I logged in using my Microsoft account during my Win8 installation and setup my user profile accordingly).

My question is - shouldn't I be able to see my user directory structure? If not, is there a new convention for Win8 that I'm not aware of?

Incidentally, I was able to restore my database by copying the file to the C:\ root and restoring from there.

share|improve this question
If you are using Windows to authenticate, then user information is not stored in the database, thats handled by Windows. –  Ramhound Nov 2 '12 at 12:54
I'm not trying to authenticate to the database - if you look you can see I'm already connected. What I want to do is be able to select files from my Windows user directory through the dialogues in SSMS to load a file into that database. For some reason, I can't access my user profile from within these dialogues. I can access C:\Users\aaron_000\Downloads from Windows Explorer. It looks to be a bug in SSMS to me. –  Aaron Newton Nov 3 '12 at 3:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.