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 ...SQL Server connection- install of DNN 4.00.02 with SQL Server 2005 and Windows server 2003SQL Server connection- install of DNN 4.00.02 with SQL Server 2005 and Windows server 2003
Previous
 
Next
New Post
2/21/2006 11:53 AM
 
I have resolved my problem. Thank you for all your suggestions. Oliver's suggestion of removing my dnnuser from having a windows account and making the user only be an SQL login solved the problem. I am curious how I would make a windows user able to work, but for now at least my installation succeeded. Thanks again for all the help and helpful suggestions.

Deb
 
New Post
2/21/2006 5:34 PM
 

Deba, then your problem was number one of my previous post. You weren't matching the format of the connection string to the format SQL is using: Mixed Authentication (Windows/SQL). Please refer to SQL documentation on Authentication mode to learn more about this. It's very useful to know not only why it didn't work, but how it should work.


Do you know the truth when you hear it?
Néstor Sánchez
The Dúnadan Raptor -->Follow Me on Twitter Now!
 
New Post
2/22/2006 12:58 AM
 
You can use Windows authentication easily. I wouldn't create a seperate local user on your machine unless you just want too, but DNN will run under either <machine name>\ASPNET or <machine name>\NETWORK SERVICE depending on your OS which already exists on your machine.

So...here are (my) step by step instructions for you to get your DNN 4.0.2 install running using Windows Authentication. This is assuming you have IIS, .NET framework 2.0, and SQL 2005 Express installed.

Create the C:\DotNetNuke directory

Apply the following permissions to the C:\DotNetNuke folder
Full Control to <machine name>\ASPNET
-OR-
Full Control to <machine name>\NETWORK SERVICE
Full Control to SYSTEM
Full Control to <machine name>\Administrators
Read & Execute to <machine name>\Users
Some of these permissions may not be necessary or can be reduced but this is what worked (easy) for me

Extract DotNetNuke_4.0.2_Install.zip to C:\DotNetNuke

Create a virtual directory named DotNetNuke in IIS

Change the default document to Default.aspx on the Documents tab of the DotNetNuke virtual directory

Change the ASP.NET version to 2.0.50727 on the ASP.NET tab of the DotNetNuke virtual directory

Create <machine name>\ASPNET OR <machine name>\NETWORK SERVICE Login (Security>Logins) in SQL 2005 Express

Create DotNetNuke database with <machine name>\ASPNET OR <machine name>\NETWORK SERVICE as owner in the C:\DotNetNuke\App_Data directory

After database has been created, expand DotNetNuke>Security>Users and double click dbo
Under Owned Schemas check db_owner

Replace permissions on the C:\DotNetNuke folder

Rename the release.config file to release.config.bak

Copy the release.config.bak file as web.config

Open the web.config file and modify the following lines

<connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
    <add name="SiteSqlServer" connectionString="Data Source=.\<your sql server instance name>;Initial Catalog=DotNetNuke;Integrated Security=True;"/>

<appSettings>
     <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->
     <add key="SiteSqlServer" value="Data Source=.\<your sql server instance name>;Initial Catalog=DotNetNuke;Integrated Security=True;"/>

Navigate to http://localhost/DotNetNuke
 
New Post
2/22/2006 3:56 AM
 
Hi

> Data Source=.\;

How do I determine this? Is it by default SQLExpress? or my Server name eg Saturn?

Best regards

Andre
 
New Post
2/22/2006 10:41 AM
 
By default it says ".\SQLExpress" Change that to ".\<sql server instance name>" where <sql server instance name> is your SQL server instance name.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL Server connection- install of DNN 4.00.02 with SQL Server 2005 and Windows server 2003SQL Server connection- install of DNN 4.00.02 with SQL Server 2005 and Windows server 2003


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