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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...web.config? Connect to SQL 2005 Serverweb.config? Connect to SQL 2005 Server
Previous
 
Next
New Post
3/11/2008 1:22 PM
 

 Hi. I was hoping for some help in setting up DotNetNuke (web.config).

I have installed IIS and have configured a Web Site on a remote server. I develop on my local machine using 'Visual Web Developer 2008'.

 I created a new web site and chose the template 'DotNetNuke Web Application'. I am a little confused regards configuring the web.config file? Here is what I have done:

Connection String:

[quote]

<add name="MY-SERVER" connectionString="Server=(MY-SERVER\MyNamedInstance);Database=DotNetNuke;uid=myusername;pwd=********;"

="System.Data.SqlClient" />

 [/quote] 

 <appSettings>

[quote]

add key="MY-SERVER" value="Server=(MY-SERVER\MyNamedInstance);Database=DotNetNuke;uid=myusername;pwd=*******;"/> providerName="System.Data.SqlClient" />

[/quote]

I get a run time error when I hit CTRL+F5 on the web.config file? http://1.1.1.1/MyWebSite/

I created a Database within SQL Server 2005 - DotNetNuke (empty).

In the real world I would like to connect to 'Development' database within SQL Server 2005, however I do not know the implications when configuring DotNetNuke to connect? Will it alter tables?

Help very much appreciated.

Kind Regards,

Philip

 
New Post
3/11/2008 2:51 PM
 

Philip,

What is the run time error that you receive?

Thanks,

Ian


Software Engineer
Co-Founder, dnnGallery
Stack Overflow: Ian Robinson
Twitter: @irobinson
Linked In: Ian Robinson
 
New Post
3/11/2008 3:41 PM
 

Hi Ian. From memory the error was telling me to create a custom error page from within IIS to get more information.

I was able to launch the DotNetNuke welcome page but the default.aspx page failed to open when I hit CTRL+F5 (aplogies for being vague). I trashed the site and was going to have another go tomorrow after (fingers crossed) getting some help from this forum!!

I want to create a dynamic site. The Database(s) will be housed on MS SQL Server 2005. If you can point me in the right direction you would make me a happy man!

Thanks,

Phil.

Set-Up

A: Windows 2003 Server running IIS 6.0 ASP.NET 2.0 SP1

B: Developing Locally using 'Visual Web Developer 2008'

C: MS SQL Server 2005 64 bit (various DB's)

Want to use B to create web site then connect to C to retreive Data then view the resulting ASP Web Page via A.....

Hope that all makes sense?

 
New Post
3/11/2008 4:48 PM
 

Hey Phil,

The error message you were receiving was the "generic" error message. If you encounter that again you can update your web.config file to show you the "real" error message: search for the following in your web.config "RemoteOnly" and replace with "Off" (it is in the custom errors section).

To outline the basic steps for installation:

  • Download Install version of DotNetNuke, unzip to your favorite directory (e.g. c:\inetpub\wwwroot\DotNetNuke_2)
  • Apply appropriate security permissions for Network Service account to that directory (Full Control if you're comfortable, might need to experiement if not)
  • create database and corresponding login (db owner if you're comfortable, custom access if not)
  • test login credentials and make sure that user can log in using management studio
  • in IIS create your application and make sure it execute scripts, has default.aspx, is using asp.net 2.0, has a host header...etc...
  • modify your web.config's connection strings to use the database server and user credentials you created earlier (also, optionally turn off "remoteonly" as mentioned above -- if you want to see any error messages that may come up in the future...probably not the best idea in production though :)
  • type in your site's URL and select "auto" install option (my personal recommendation).

That's it in a nutshell.....there are plenty of more detailed tutorials out there if you search for them, but this should set you on the right track

Take care,

Ian

 


Software Engineer
Co-Founder, dnnGallery
Stack Overflow: Ian Robinson
Twitter: @irobinson
Linked In: Ian Robinson
 
New Post
3/12/2008 4:00 AM
 

Thanks Ian..............one last question if I may? If I create a Web Site in IIS should I place the files within wwwroot or create a sub folder within intepub for my site? I aim to create Intranet Site(s). The server hosting IIS has IP 10.2.2.50. I added a HOST CNAME record in DNS : 'intranet' pointing to myserver.mydomain.local. If I enter this url in a web browser  the default Web Site directory within IIS is displayed, not 'intranet'?

I am sure the resolution is quite simple................I HOPE!!

Thanks,

Phil.

 

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...web.config? Connect to SQL 2005 Serverweb.config? Connect to SQL 2005 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