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
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Not Associated with Trusted ConnectionNot Associated with Trusted Connection
Previous
 
Next
New Post
7/19/2006 4:24 PM
 
Darryll

Joined: 7/18/2006
Posts: 13

Greetings!

I need to install DNN on a different server than my database server.

I have:

Created a new user on the called ReportingUser

Registered this user with IIS using ASPNET_REGIIS - ga Domain\ReportingUser on the web server

Granted the appropriate rights to the user on the Root of the DotNetNuke web.

Modified two pertinent locations in the Web.Config to point to the the Production server, using a trusted connection and integrated security of SSPI.

Created a login for Domain\ReportingUser on the Production database server. This login have been made member of the public and db_owner groups on SQL server, both of which are dbo.

SQL Server is using mixed mode security.

I run the DNN installation script for v4.0.3 and I get an towards the end of the script about not being associated with a trusted connection, at which point I'm stuck.

I really don't know what to do to get this to work correctly. PLEASE HELP US.

Best Regards,

Darryll Petrancuri

NEST International

 
 
New Post
7/19/2006 5:55 PM
 
Darryll

Joined: 7/18/2006
Posts: 13

Here is the specific install output:

Version: 04.00.03



 

Installation Status Report

00:00:00.031 - Installing Version: 3.1.0
00:00:00.031 - Installing Script: DotNetNuke.SetUp.SqlDataProvider
00:00:00.046 - Installing Script: DotNetNuke.Schema.SqlDataProvider
00: - Installing Script: DotNetNuke.Data.SqlDataProvider
00:00:02.734 - Installing MemberRole Provider:
00:00:02.734 - Executing InstallCommon.sql
00:00:02.968 - Executing InstallMembership.sql
00:00:03.187 - Executing InstallProfile.sql
00:00:03.296 - Executing InstallRoles.sql
00:00:03.515 - Upgrading to Version: 3.1.1
00:00:04.265 - Upgrading to Version: 3.2.0
00:00:04.328 - Upgrading to Version: 4.0.0
00:00:04.453 - Upgrading to Version: 4.0.1
00:00:04.500 - Upgrading to Version: 4.0.2
00:00:04.515 - Upgrading to Version: 4.0.3
00:00:04.531 - Performing General Upgrades
00:00:04.718 - Loading Host Settings:
00:00:04.812 - Configuring SuperUser:
00:00:05.171 - Installing Desktop Modules:
00:00:05.187 - Installing Modules:
00:00:05.218 -   Installing Module File C:\DotNetNuke\Install\Module\Announcements_3.1_Install.zip:
00:00:05.546 -   Installing Module File C:\DotNetNuke\Install\Module\Contacts_3.1_Install.zip:
00:00:05.625 -   Installing Module File C:\DotNetNuke\Install\Module\Discussions_3.1_Install.zip:
00:00:05.703 -   Installing Module File C:\DotNetNuke\Install\Module\Documents_3.1_Install.zip:
00:00:05.781 -   Installing Module File C:\DotNetNuke\Install\Module\Events_3.1_Install.zip:
00:00:05.890 -   Installing Module File C:\DotNetNuke\Install\Module\FAQs_3.1_Install.zip:
00:00:05.968 -   Installing Module File C:\DotNetNuke\Install\Module\Feedback_3.1_Install.zip:
00: -   Installing Module File C:\DotNetNuke\Install\Module\HTML_3.1_Install.zip:
00:00:06.093 -   Installing Module File C:\DotNetNuke\Install\Module\IFrame_3.1_Install.zip:
00:00:06.125 -   Installing Module File C:\DotNetNuke\Install\Module\Image_3.1_Install.zip:
00:00:06.156 -   Installing Module File C:\DotNetNuke\Install\Module\Links_3.1_Install.zip:
00:00:06.234 -   Installing Module File C:\DotNetNuke\Install\Module\NewsFeeds_3.1_Install.zip:
00:00:06.250 -   Installing Module File C:\DotNetNuke\Install\Module\Survey_3.1_Install.zip:
00:00:06.359 -   Installing Module File C:\DotNetNuke\Install\Module\UserDefinedTable_3.1_Install.zip:
00:00:06.500 -   Installing Module File C:\DotNetNuke\Install\Module\UsersOnline_3.1_Install.zip:
00:00:06.546 -   Installing Module File C:\DotNetNuke\Install\Module\XML_3.1_Install.zip:
00:00:06.578 - Executing Additional Scripts:
00:00:06.578 -   Creating Portal: My Website
00:00:06.640 -   Error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
00:00:06.640 -   Portal failed to install:
00:00:06.656 - Installing Optional Resources:

All the problems stem from the bolded line above....

I've searched the forums to death and can find no solution!

Why? Why? Why?

 
 
New Post
7/19/2006 7:20 PM
 
Darryll

Joined: 7/18/2006
Posts: 13

Ok, so here's part of the problem...

First, please note, this is an IIS 6.0 Installation

The DefaultAppPool that the default web server was running under was NETWORK SERVICE. This won't work in an impersonation environment because the account being used for the integrated security / trusted connection is a domain account that was set up named Domain\ReportingUser.

It isn't enough that the DotNetNuke site runs as Domain\ReportingUsere AppDomain that IIS 6.0 for this application pool must be running under Domain\ReportingUser as well. So what I have now is Domain\ReportingUser as the Identify of the DefaultAppPool, Domain\ReportingUser as the Windows user account for Anonymous Access for the DotNetNuke web site, and Domain\ReportingUser as the Database Login for the DotNetNuke database on the SQL Server box.

But now, the following problem occurs:

File
Error   Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\vf9f6e9c.0.cs' could not be found error CS2008: No inputs specified

At the end of the install it says this is an unhandled error.

I'm beginning to thing impersonation is a BAD IDEA with DotNetNuke. Perhaps I'd be better of using a specific user name and password for the database connection to DotNetNuke and relying on ASP.NET 2.0's ability to encrypt the password. Because, all the time I'm spending on this seems like it's 1 step forward, 2.5 steps back.

Any thoughts?

Please help.

D
 
New Post
7/25/2006 12:41 PM
 
Shaun Hendricks

www.americanworkspace.net
Joined: 4/24/2006
Posts: 4

Ok I had this issue when I installed Active Directory onto my server.  I had to go to   c:\windows\microsoft.net 2.XX and grant the network service account full control of this directory and then i had to inherit permissions thru the whole file structure of this folder.  Then I had to go to c:\windows\temp and do the same thing for the network service account.  After that I had to reboot and then everything went to working fine.  It may help you to do this it may not, i hope it help and this will help the 3rd post on this forum for sure.

have a great day.

 
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Not Associated with Trusted ConnectionNot Associated with Trusted Connection


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