Todd_Anderson
asked on
How can I change the default data directory in SQL Server 2005?
I can see the default data directory listed but it is grayed out. How can I change it?
Thanks,
Todd
Thanks,
Todd
Easiest way is to log in as the sql server service account if thats possible
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, sorry about the delay. Had to take care of some other things this morning.
QB's comment made me realize that I already had changed the default data directory. I had already moved the 'Model' database using the MS procedure so everything was working as I had wanted. What confused me was this:
Configuration Manager --> Services --> right click on SQL Server --> Properties --> Advanced tab
There is a listing for Data Path, which is grayed out, which is not the location of the Model database. I guess that is something different?
I created a test database and the default location was where the Model database is, which is what I want!
Thanks,
Todd
QB's comment made me realize that I already had changed the default data directory. I had already moved the 'Model' database using the MS procedure so everything was working as I had wanted. What confused me was this:
Configuration Manager --> Services --> right click on SQL Server --> Properties --> Advanced tab
There is a listing for Data Path, which is grayed out, which is not the location of the Model database. I guess that is something different?
I created a test database and the default location was where the Model database is, which is what I want!
Thanks,
Todd