SQL Server Management Studio Express CTP - Restore DB Problem

I just installed SQL Server Management Studio Express CTP. I created an empty database and then I attempted to restore an existing .BAK file. When I launch the restore wizard, I chose to add a device and then browse where the .BAK file resides which is in my My Documents folder. When I go to browser C:\Documents and Settings\jwalker\(rest of path), Management Studio Express refuses to let me see anything beyond jwalker.

I'm logged into Management Studio Express using Windows as jwalker which is an Admin of the machine. Why won't it let me browse to the backup file Is this a limitation of the Express tool Is it a bug Or is it something I am doing wrong. Thanks for any help you can provide.

Answer this question

SQL Server Management Studio Express CTP - Restore DB Problem

Shelby Eaton
Steve,

It's my dev machine, so the SSMS Express and the SQL Server 2005 Express engine are both installed on the same machine. Adding the SQLServer2005User$.... account to the folder fixed the problem for me. Thanks for the response.
CHS
The browse dialog is showing the folders on the server. The dialog is also restricted to viewing the folders that the server's service accound can see.

The folder you are looking for are on server machine, not the client machine where Management Studio is running, right Does the service account used by the server have permissions to read the directories under jwalker
SQL Server Management Studio Express CTP - Restore DB Problem

Answer this question