I've done a search and tried a few things and nothing is working.
This is the error we're getting:
There is an error during the draw <layer name>(1.) DBMS table not found[42S02:[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name '<DB name>,(2.) <service Account>,(3.) <view/table>',(4.) ].
It's ONLY happening on non-SDE databases. They reside on the same SQL server as SDE.
It's ONLY happening after upgrading to 10.4.1 from 10.3.1. Prior to the upgrade, it all worked fine.
We can view the data just fine in ArcMap, but once the service is published, we get errors in the Service when we try to load it and nothing draws.
What we have checked:
We can replicate it on other servers, so it's clearly not a one off.
MSSQL DB version is 2014 Enterprise edition.
Up to date DB drivers.
All ArcGIS for Server updates are done.
Service accounts have permissions in the DB.
Data store is registered and validates.
Service doesn't load in browser OR in ArcMap. Which is as I would expect since I suspect the server.
We occasionally get : Failed to rename cache folder.
We have even tried a test server, creating a new service from scratch and publishing as the service account with no luck.
I'm looking for some ideas. What have we missed?