Original User: asrujit
Jamal,
Just FYI,
even if you change the default data location of the Database files in SQL Server for a particular Instance, the newly created geodatabase using ArcGIS interface will still have its data files in the default location set by Microsoft.
So, the only option will be to create the database in SQL Server first at your preferred location, and then use the enable geodatabase option to convert it into a geodatabase.
Regards,