I wonder if this question will need to be moved to the SharePoint SE site, but I believe this could be a simple a SQL Server security fix.
A little back story: Back in April we upgraded our SharePoint SQL Server backend (mirrored) from SQL 2005 to SQL 2014. We did this by way of mirroring from SQL 2005 (primary) to SQL 2014 (mirror). I don't believe the security settings and logins were extracted from the old server and placed in the new. I'll have to reach out to my infrastructure department to see if the server has been completely decommissioned.
My SharePoint Admin is trying to create a new site from the SharePoint Central Admin Site (SharePoint 2010), but gets the following error.
Error "Directory lookup for the file "D:\Data\NewSiteDB.mdf" failed with the operating system error 2(The system cannot find the file specified.). CREATE DATABASE failed. Some file names listed could not be created."
He told me that he used to be able to use his Active Directory account or a SQL Server SysAdmin account to create new sites, now he can't. I'm pretty sure that his AD account was not an admin of any kind on the SQL Servers regarding the SQL 2005 configuration. Further, he stated that he used a SQL Server SysAdmin account (in the SQL 2014 configuration) but it still failed.
- What can I do if the old server is decomm'd?
- If the server isn't decomm'd, and I can access, how do I extract all the logins, permissions, SID's, etc.?
- Is it possible to create a new mapping from the SharePoint Central Admin site to a new SQL/Windows login?
Let me know if you need any other info and thank you in advance for your help!