I am on 4.8.1 and when I go to host -> SQL I get this message " Error: SQL is currently unavailable."  I have 2 similar dnn installations on this same server, dev and prod and they both do this.  this also happened on my old instance (same server) back at version 4.6 but it didnt seem to hurt anything so i never tracked it down.  i have searched on here and google and cant find anything about this.  Here is the event log:\

ModuleId: 325
ModuleDefId: 65
FriendlyName: SQL
ModuleControlSource: Admin/Portal/SQL.ascx
AssemblyVersion: 04.08.01
PortalID: 0
PortalName:
UserID: 1
UserName: host
ActiveTabID: 21
ActiveTabName: SQL
RawURL: /Host/SQL/tabid/21/portalid/0/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 785e9a1a-6a26-4361-882c-631ce2be20a4
InnerException: ...\httpdocs\Admin\Portal\SQL.ascx.vb(97): error BC30456: 'Instance' is not a member of 'DataProvider'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Web.Compilation.BuildManager.CompileWebFile
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: ...\httpdocs\Admin\Portal\SQL.ascx.vb(97): error BC30456: 'Instance' is not a member of 'DataProvider'. ---> System.Web.HttpCompileException: ...\httpdocs\Admin\Portal\SQL.ascx.vb(97): error BC30456: 'Instance' is not a member of 'DataProvider'. at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings) --- End of inner exception stack trace ---
Source:

(i removed some path stuff and put ... in its place)

TIA for any help!

any ideas on how to correct the problem?

I do.  Based on what you are saying perhaps I should set up a third instance and install the extra modules 1 by 1 and after each one check the SQL function?  Or is it likely to be be a certain class and I should work it from another angle?

Thanks!