We help IT Professionals succeed at work.

SQL Management Studio can't browse all my files when trying to attach a DB...

644 Views
Last Modified: 2012-05-05
Background:
I have created a database within Visual Studio.  The project is stored within MyDocuments\VisualStudio2008\Projects

Problem:
When I open up SQL Management Studio (connect via Windows Auth)...  I right click on databases and then select "attach"...  I then click add and try to navigate to my project folder.  At this point it will not let me browse beyond c\docs&settings\myUser

Question
How do I make it so that I can browse to thos edatabase files so I can attach them...

One thing I can think to do BUT I am not sure if ts safe to so is to give the SQLServerMSSQLUser$"myUserName"$SQLExpress full control or at least read control to my entire user account folder?  Is there any problems with doing that?

Comment
Watch Question

QPR

Commented:
When you say you can't browse beyond do you mean the folders aren't visible or you get access denied when you try to open them?
Does the windows account you use to log on to sql with have the necessary permissions to access that folder because that is the account being used when you are traversing the file system.

Commented:
Add the account that starts sql server to the administrators group on the server that have the files.

not this account - SQLServerMSSQLUser$

the account that starts the SQL service.
QPR

Commented:
Just to be able to open/see a folder? isn't that overkill?
If the original poster is doing this manually and logging on via windows authentication then surely it is their credentials that are being used to navigate to the bak/mdf file?
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
no user starts the sql service, you either have a domain account to start SQL service or you have the local account that starts the service.

go to control panel

choose administrator tools - then services - look for SQL server
then double click - choose the logon tab you will see what account starts SQL service
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.