How security is set on drives of Windows 2003 Server to let only specific SQL Server acces to them?
Posted on 2009-12-16
How security is set on drives of Windows Server 2003 to let only specific SQL Server acces to them?
- Windows 2003A, has SQL Server 2005 installed and has those drives: C, D, E,F
- Windows 2003B, has also SQL server 2005 installed and SQL Management Studio
1- I open SQL Management Studio on Windows 2003B and connect on SQL databases of Windows 2003A
2- When I try to restore a database from file, I can only acces to E and F drives of Windows 2003A
How security is set to get only acces to specific drives?