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
Todd_AndersonAsked:
Who is Participating?
 
QuinnB74Connect With a Mentor Commented:
Change the Data file location of the Model database (Right click on 'Model', Select Properties, Data Files Tab)

All new databases created will use this location as default.

Hope this Helps
QB
0
 
ShogunWadeCommented:
Easiest way is to log in as the sql server service account if thats possible
0
 
Todd_AndersonAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.