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!

jdroger2

This error ('Instance' is not a member of 'DataProvider') often appears druing development when SqlDataProvider and main module are from different versions or for example some references are missed. Your situation is nonclear, because Core modules should work properly. Did you make any changes in the core?

Sergey

please do not crosspost the same question in multiple forums. see my answer here: