Products

Solutions

Resources

Partners

Community

Blog

About

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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...HELP - An error has occurred. Error: Links is currently unavailable - SOLVED!HELP - An error has occurred. Error: Links is currently unavailable - SOLVED!
Previous
 
Next
New Post
4/11/2006 1:10 AM
 
I finally got the DNN site build and run thank in large part to this forum.  Now the first thing I notice is that I get "Error: Links is currently unavailable" on every component of the page.  Does anyone have any suggestions about this?    Thx
Forgot to add this...DNN 4.0.2 / IIS5.1 / WinXp / .Net2.0 / VS2005
Here's my appsettings from web.config. Something must be off here:
<appSettings>
    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->
    <add key="SiteSqlServer" value="Data Source=<myservername>\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|dnn.mdf;" />
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>
    -->
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <!--  Alternative Install Templates (included in package)
    <add key="InstallTemplate" value="Club.install.config" />
    <add key="InstallTemplate" value="Personal.install.config" />
    <add key="InstallTemplate" value="SmallBusiness.install.config" />
    -->
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false" />
    <add key="InstallationDate" value="4/11/2006" />
  </appSettings>
=================
Here is the last error in the admin/log viewer area. Says something about sproc GetLinks not existing but I checked and it's there.
ModuleId: 345
ModuleDefId: 102
FriendlyName: Links
ModuleControlSource: DesktopModules/Links/Links.ascx
AssemblyVersion: 04.00.02
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID: 0
PortalName: My Website
UserID: -1
UserName:
ActiveTabID: 36
ActiveTabName: Home
AbsoluteURL: /DotNetNuke_2/Default.aspx
AbsoluteURLReferrer: http://localhost/DotNetNuke_2/Install/Install.aspx?mode=Install
ExceptionGUID: 5f3fc247-18c2-45bc-8e03-0f07f901338d
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: The stored procedure 'dbo.dnn_GetLinks' doesn't exist.
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.dnn_GetLinks' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.dnn_GetLinks' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Links.SqlDataProvider.GetLinks(Int32 ModuleId) at DotNetNuke.Modules.Links.LinkController.GetLinks(Int32 ModuleId) at DotNetNuke.Modules.Links.Links.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
StackTrace:
Source:
Server Name: SPYGLASS
==============================
Ok it works.  It was the appsettings connection string for the db. The first entry below is in the format the comes with DNN.  The second one is the one I modified to get the DNN site to work.  A little different format but works.  Thanks all.  Hope this helps others down the line.  Now to see what this baby can do!!

  <!--      <add key="SiteSqlServer" value="Data Source=SPYGLASS\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|dnn.mdf;" /> -->
    <add key="SiteSqlServer" value="Data Source=SPYGLASS\SQLEXPRESS;Database=<myDB>;User ID=<UID>;Password=<PWD>;Connection Timeout=5" />

 
New Post
4/11/2006 6:31 AM
 
Please post the complete error which can be found in 'Admin/Log Viewer'. It should be marked in red.
Be certain to include the DNN version your running.


 
New Post
4/11/2006 11:34 AM
 
I am having this problem also.  I am running DNN 4.0.2 on IIS 6 and SQL 2000 Enterprise.  The error is occuring for all core modules, but as far as I can tell it is not happening for any third-party modules.

Error: Links is currently unavailable.
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) ---> System.Data.SqlClient.SqlException: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Links.SqlDataProvider.GetLinks(Int32 ModuleId) at DotNetNuke.Modules.Links.LinkController.GetLinks(Int32 ModuleId) at DotNetNuke.Modules.Links.Links.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
 
New Post
4/11/2006 12:13 PM
 
http://forums.asp.net/thread/1215700.aspx

Make sure that the connection string is in web.config twice(2x).  Once in
<connectionStrings>
and once in
<appSettings>
The second one is the one that you need to be really concerned about.  It is there for backwards compatibility and the modules that are not showing are DNN 3 .NET 1.1 modules running on a DNN4 .NET 2 install. 
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...HELP - An error has occurred. Error: Links is currently unavailable - SOLVED!HELP - An error has occurred. Error: Links is currently unavailable - SOLVED!


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