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

HomeHomeDNN Open Source...DNN Open Source...Provider and Extension ForumsProvider and Extension ForumsAuthenticationAuthenticationConfirmed: Intranet AD autologinConfirmed: Intranet AD autologin
Previous
 
Next
New Post
11/9/2006 8:58 AM
 

In my first post, I mentioned that I had uncommented that line (it is a bit hard to find, buried in item 2b).  All of the testing mentioned here was done with that line uncommented.

 
New Post
11/9/2006 9:57 AM
 

How is your connection string setup to authenticate against your database, and is your database on a different box to the front end? If you have impersonate set to true and you are using "Integrated Security=SSPI", then your users have to be able to connect to the database with their credentials. Similarly, they may need NTFS privileges on the file system IIS uses.

I am currently struggling with a similar (intermittent) error. I have users that get this error...

DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

This may or may not be related, but seems to be whether users manage to use kerberos authentication or end up using NTLM authentication against the portal.

 

 
New Post
11/9/2006 11:15 AM
 

I know I'm getting in on this late, but I have ran into some of these issues also and let me share how I tackled some of them:

to create an Intranet portal for use by domain users only.  I want DNN to recognize who is logged into Windows so that users do not need to login the the portal.  I will be using group membership to restrict viewing of certain pages to certain groups.

Since we ghost all of our machines before we send them out, I change the settings in IE to automatically logon with current user login name and password.  I set this by default and then the users will be logged on to the portal when they hit the page. That takes care of the automatic login for when a user is on campus and at their machine.

Incomplete user profiles in AD cause problems

If a user does not have email in AD (many of our users do not have email), the user is still created in DNN, but the email field is blank.

I deal with the same situation here.  What I did to take care of this problem is that I added a SQL Trigger to the table that checks the fields after a user is created.  If the Email or First/Last Names are blank the Trigger fires and updates the fields.

I don't know how to redirect http://myserver to http://myserver/admin/WindowsSignIn.aspx when users first open the page.

Ok, try not to fall down laughing over this one, very simple and it serves the purpose.  I created an HTML page that does an automatic redirect to the login page.  Set the priority of how pages are access in IIS and made sure that index.html was the first page that was accessed from that site.

Hope that helps some.

Steven

 

 
New Post
11/9/2006 2:53 PM
 

When I change to <authentication type="Windows"/> and <identity impersonate="true"/>, I get a "cannot connect to database" error.  I thought that perhaps this is because the SQL connection is not able to connect with the existing connection string.  I then found this link at Microsoft that describes the different fields in the connection string.

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx.

I changed the connetion strings (in both places) to "...;Integrated Security=false;User ID=sa;Pwd=thepassword;..." hoping to force the connection to the DB using the SA user credentials I created when I installed SQL2K5E.  This did not work.  DNN did not even connect to the database.  So much for that idea.

At this point, using <authentication type="Forms"> I still can use http://myportal/admin/security/WindowsSignIn.aspx to get the current Windows user signed in.  I am not sure how to get automatic sign in when just entering the URL http://myportal.

It sounds like many users have already given up and either provided a link on the Home page to login as the current user, provided a desktop shortcut to do the same, or forced users' home page to be that URL.  All of these work to some extent.

I would sure like to find out why I cannot get a change in web.config (or elsewhere) to obviate the need for such workarounds.

 
New Post
11/9/2006 9:41 PM
 

Okay I might cover ground that you already have done but that's only because I've confused what you've done with another post.

Here's how I've got it setup on our intranet (and going by memory because I don't have my laptop home with me tonight to check my dev site):

1.I think if you remove the Integrated Security=false from the connection string it should work. Verify that your sql box takes connections in both modes (Windows Authentication and SQL).
2. Uncomment the <add name="Authentication..... or whatever it is exactly
3. Around the impersonation lines..... I left the DNN default and only uncommented the <identity impersonate... line and set it to <identity impersonate=true userName="domain\username" password="password" />. I ran into the same problems you did if I tried it any other way. Now, once you do that you may have to give that user the same rights as your ASPNET/Network Service account on your DNN install and possibly the Microsoft.NET directory in the Windows directory on your webserver.
4. All sites where I work are automatically trusted due to Group Policy.

Hope that helps a little bit.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Provider and Extension ForumsProvider and Extension ForumsAuthenticationAuthenticationConfirmed: Intranet AD autologinConfirmed: Intranet AD autologin


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