I need some assistance trying to figure out what is going on. We have been running our test SharePoint and test SQL together on the same server and it has been doing ok, but we decided to move SQL to its own server for a number of reasons. My issues though is once I moved the database over to our new SQL Server, SharePoint can no longer connect to it. The browser just shows a empty white page when trying to navigate to any sites on SharePoint. Using Fiddler, I can see that I am also getting a 401 Unauthorized, but not sure why. I used this process for moving the database Moving SharePoint to a different SQL server and here are the troubleshooting steps I have performed so far:
- Verified that I could open the databases on the new SQL Server from the old server via SQL Server Management Studio and the command line (sqlcmd).
- Successfully pinged new server from old server.
- Setup a SQL alias using the server name (even tried the IP). Both the old server and new server were running the database in the default instance
Now I'm thinking that permissions may be causing some kind of issue, but I am having trouble seeing how as I simply restored a backup of the database from the old server to the new server. I'm not sure how to really double check permissions though (as far as I can see everything looks the same when I compare the accounts and permissions in SQL Server Management for both servers).
Both servers are Windows 2008 R2 Standard and have Microsoft SQL Server 2012. The SharePoint server is running SharePoint 2013.
Any help would be greatly appreciated! Thanks!