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 ...Remote SQL serverRemote SQL server
Previous
 
Next
New Post
8/4/2006 5:51 PM
 

Hey people,

i am trying to set up my web.config to connect to a remote SQL2000 database and i keep getting this error

Server Error in '/' Application.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +114
   DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +93
   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +3717
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

 

This is what my connection string looks like

<add key="SiteSqlServer" value="Server=24.207.17.240;Address=24.207.17.240,1433;Network=dbmssocn;Database=(DBname);uid=(username);pwd=*********;Trusted_Connection=False" />

i am not sure if its^ right...

i have opened port TCP 1433 on my firewall and forwarded it to my server

 

any help would be awesome.

-Steve

 
New Post
8/4/2006 11:55 PM
 

The address attribute is not legal AFAIR, and you don't need to specify trusted_connection is you're providing a username and password. In addition the dbmssocn value is only required if you need to force the selection to tcp/ip i.e. in a setup where you have named pipes and tcp/ip installed, and named pipes is the default. In most case's you'll find tcp/ip is the default, so a connection string such as :


<add name="SiteSqlServer" connectionString="Server=24.207.17.240,1433;Database=yourdatabase;uid=youruser;pwd=yourpassword;" providerName="System.Data.SqlClient"/>

(don't forget you need to set both connection strings)

Cathal


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
8/5/2006 1:56 PM
 

thanks cathal, i have figured it out. it was a firewall issue

much thanks,

steve

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Remote SQL serverRemote SQL server


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