jasonwsaz
asked on
SQL Management Studio can't browse all my files when trying to attach a DB...
Background:
I have created a database within Visual Studio. The project is stored within MyDocuments\VisualStudio20
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$"myUser
I have created a database within Visual Studio. The project is stored within MyDocuments\VisualStudio20
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$"myUser
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.
not this account - SQLServerMSSQLUser$
the account that starts the SQL service.
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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.