• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2683
  • Last Modified:

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
0
Todd_Anderson
Asked:
Todd_Anderson
1 Solution
 
ShogunWadeCommented:
Easiest way is to log in as the sql server service account if thats possible
0
 
QuinnB74Commented:
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
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now