Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2008-10-01
6
620 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?

0
Comment
Question by:jasonwsaz
  • 2
  • 2
6 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 22621566
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.
0
 
LVL 8

Expert Comment

by:Julianva
ID: 22621786
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.
0
 
LVL 29

Expert Comment

by:QPR
ID: 22621809
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?
0
 

Accepted Solution

by:
jasonwsaz earned 0 total points
ID: 22623837
hmm...  actually before you guys responded I added full control to my documents to SQLServerMSSQLUser$

seemed to solve the problem...

Julianva - how do I figure out which user starts the SQL service?

QPR - When I would click on the little "+" sign next to the folder it would imply disapear as if nothing was in the folder.  By adding the user above the the respective folder it works now and I can browse the content of the folder.
0
 
LVL 8

Expert Comment

by:Julianva
ID: 22623901
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
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
backup job space check 4 42
SSRS - Date Report Options 2 27
query question 12 32
VB.NET Application Installation with sqlserver 8 28
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question