Link to home
Start Free TrialLog in
Avatar of Todd_Anderson
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
Avatar of ShogunWade
ShogunWade

Easiest way is to log in as the sql server service account if thats possible
ASKER CERTIFIED SOLUTION
Avatar of QuinnB74
QuinnB74

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Todd_Anderson

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