February 7, 2005 at 1:01 pm
I have just taken over an SQL server 2000 box with a C: and D: drive. The D: is to be used for Data. However I can't attach to data on the D: drive or use it for back up because the File dialouge only shows the C: drive.
Can anyone point me in the right direction to get SQL Server to display those locations?
February 7, 2005 at 2:43 pm
Is this by any chance a clustered instance?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 7, 2005 at 2:54 pm
I am a developer very new to SQL 2000 admin. The Server was just set up for me to load a db onto. How would I tell? Then what could I do to reverse it?
February 7, 2005 at 2:56 pm
In Windows Explorer, when you right-click on the D: drive and select 'Properties', what does it tell you ? Is it of type 'Local Disk' ?
February 7, 2005 at 3:32 pm
Thanks for the direction. I have checked and yes it is a Local Disk.
February 7, 2005 at 3:42 pm
Run the following query on your server:
select serverproperty('IsClustered')
If it returns 1 you have a clustered server. If this is the case there are several steps you need to take to configure the disk as a clustered resource and make SQL Server dependent on it.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 7, 2005 at 3:51 pm
Ensure your C: and D: drives have the same NTFS security settings at the root level for the SQL Server account.
February 7, 2005 at 3:51 pm
Thanks but the query returned 0.
February 7, 2005 at 4:11 pm
Thanks PW! It is a permissions issue. The Domain Admins, DB users, Network Admins all have permission but it is not until I give everyone persmission that you see the drive.
Is there a special SQL account I should be granting permission?
P.S. Thanks for your help dcpeterson!
February 7, 2005 at 11:14 pm
The account(s) for SQL Server service and SQL Agent service must have List rights on the root of the drive, and must have full access on de directory where the dump-files and database files reside.
Normally, when you install SQL Server, this is done automatically.
Please search for SQL Server Security on the Microsoft website for more info.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply