sharepoint using previous default database location


I've changed the default database location on sql server and when I create a database with the manager studio everything works ok but when I create a new content database using central administration in sharepoint, the database created uses the previous settings.

carolosmagnusAsked:
Who is Participating?
 
carolosmagnusConnect With a Mentor Author Commented:
The solution is to restart the sql server. Even if "Running values" shows the new value setting for default database location.
I find out this by creating a database with transatsql script. "create database dbname" was taking the previous values of default database location if none specified so did sharepoint.
0
 
OestoneeCommented:
Did you re-run the configuration wizard to point to your new SQL instance?
0
 
carolosmagnusAuthor Commented:
It's not a new instance. It's only the default location for creating database I've changed on the sql server
0
 
OestoneeCommented:
I would still re-run the wizard....
0
 
carolosmagnusAuthor Commented:
I need a solution not just a "try and see what happens". Don't want to be rude but I'm having this in a production server
0
All Courses

From novice to tech pro — start learning today.