On a recent Skype for Business Enterprise Server deployment, we added a new SFB Pool with the appropriate infrastructure ie. Backend SQL Cluster, DFS Network share.
When it was time to Publish the topology we selected all the defaults for SQL where it will “Automatically Determine database file location” where the installer will look at the available space on the hard drives of the SQL Server and setup the databases and files.
The Topology Published with errors: Creating Database Failed
Upon opening the log file to view the contents of the error it Stated “System.IO.IOException: The network name cannot be found.”
After multiple troubleshooting steps:
- Pinging the SQL server cluster from the SBF Server
- Pinging from the SQL cluster to the SFB Front End Server
- Browsing to built in shares C$, D$, E$ from the SQL server
- Browsing to built in shares C$, D$, E$ from the SFB server
- Ensuring that the below network options were turned on the SQL server:
- Network Discovery
- File and Printer Sharing
- Validating the SQL cluster
- Port information
- TCP/IP was enabled
None of the above worked, what did work however was when we republished the topology and the “Select Database” window was presented to us, we selected the Database and clicked the Advanced button and the chose “Use SQL Server instance defaults” where it will created the databases based on the instance and configuration completed by the DBA.
The wizard completed successfully and we were able to continue on with the deployment, hope this helps someone that may run into this issue.