I’ve set up a 2013 Farm, and our database server’s default file path has changed. When I try to provision any service (Search, Profiles), SP attempts to create a database for the service app, I get the exception below in red.
New-SPEnterpriseSearchServiceApplication : A database exception occurred when creating Search Application: Directory lookup for the file “L:\Databases\SQLDATA\IntranetSearch.mdf”
It is trying to create a database file in a path that is no longer valid file path. The SQL Server default path has changed to another mapped letter. How do I tell SharePoint to update where it should be putting these when I’m provisioning a service. I’ve tried both through the central admin and through Powershell.
Thanks
The SQL reboot and rerunning the configuration wizard did indeed resolve this issue. I was able to provision my search and profile services properly. Thanks, I appreciate the responses.
Hi Doug,
No problem. Not really as when certain major changes are made to the farm such as say an update being applied then you would be expected to run through the products and configuration wizard as part of the update process anyway. The only slight ramification would be that certain SharePoint related services are restarted as part of running through the wizard but you will get a warning advising you of this.
Thanks
Henry
Hi Henry,
Thanks for the response. Our DBA will be restarting SQL server this evening during our maintenance window and I’ll run the config wizard again.
Are there any ramifications to running the config wizard to an established farm? I’ll follow up tomorrow morning with the results of this.
Thanks
Hi,
Restart the SQL Service. If this has already been performed then run the Products and Configuration Wizard. Let me know how you get on?
Thanks
Henry
