Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Several modules fail to load with SQL error: 26Several modules fail to load with SQL error: 26
Previous
 
Next
New Post
7/7/2006 8:09 PM
 
don Vickers


www.ExcellentSystems.us
Joined: 12/26/2005
Posts: 68

I have had to restore the DNN database and move some things from another system and am now getting module load failures on the FAQ and iFrame modules.  I have searched for this in the forums and found that I did have an incorrect password for the database in the AppSetting.  I corrected this but the errors persist on just these modules while the rest of the site (on my local system) seems to work properly.

 

I would appreciate any ideas or pointers about how I can correct this problem.

 

Thanks!

 

The core of the error generated for the module failures is:

 

DotNetNuke.Services.Exceptions.ModuleLoadException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

 
New Post
7/8/2006 8:08 AM
 
don Vickers


www.ExcellentSystems.us
Joined: 12/26/2005
Posts: 68

The system is now displaying all modules happily.  The caching must have been causing the change of the database in AppSettings to not take effect until the system was restarted.
 
New Post
7/8/2006 8:23 AM
 

Joined: 1/1/0001
Posts: 0
As the error says it seems that you have IIS and SQL on different servers. If that is so you need to configure the SQL server to allow remote connections. This is done from within the SQL Server Surface Area Confguration.
 
New Post
7/9/2006 11:16 PM
 
don Vickers


www.ExcellentSystems.us
Joined: 12/26/2005
Posts: 68

Thanks for the reply and thoughts but there is a single computer in play at the moment.  I know the message states that the ‘remote’ computer may not being allowing ‘remote’ connections but the only computer is my test box.

 

What was most strange was that the problem only seemed to afflict the 2 module types.  Only the FAQ module on the home page and several iFrame modules on multiple pages emitted this error.

 

As far as I can tell, the root cause was that I had the wrong SQL account listed in the AppSettings for the database.

 

Now, if only I could get my production site working I would be actually happy.  I am hoping that I can get more ideas going at this thread.

 

Thanks!!
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Several modules fail to load with SQL error: 26Several modules fail to load with SQL error: 26


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out