SharePoint Experts, Information Architects, Expert Witness

SICG provides a broad array of business and technology consulting from architecture to design to deployment of global systems with a focus on surfacing data in the enterprise. We focus on the "How", not just the possible. Contact me direct: david_sterling@sterling-consulting.com or call 704-873-8846 x704.

Search This Blog

Monday, February 17, 2020

Using SQL Alias unable to connect after power failure

Odd situation with SharePoint 2019 on premise - we had a power failure and on restart, the entire farm was down. It too a bit of research - logs were no help - simply 'could not connect'.

After going back through all of the settings, it turns out it was 'cliconfg' - the alias I set up (SPSQL) was still there, but instead of pointing to the server, it replaced the Server Name with SPSQL - go figure?

Reset via cliconfg and viola - everything back to normal