Thanks to your help, i tryed to implement your solution, so i copy your code i dbo.addUser :

....

IF @UserID is null
    BEGIN
        INSERT INTO Users (
            Username,
            FirstName,
            LastName,
            AffiliateId,
            IsSuperUser,
            Email,
            DisplayName,
            UpdatePassword
          )
        VALUES (
            @Username,
            @FirstName,
            @LastName,
            @AffiliateId,
            @IsSuperUser,
            @Email,
            @DisplayName,
            @UpdatePassword
        )

        SELECT @UserID = SCOPE_IDENTITY()
    END

IF ( @DisplayName is null OR @DisplayName = '' )
    BEGIN
        SET @DisplayName = @FirstName + ' ' + @LastName
    END

...

My problem is it doesn't work, or not really. I explain myself

When a new user log on the intranet, it create a user on mmy DB but without the field Display name, after i have to unauthorized the user, and then only, the display name fill itself

Is it a normal work ?

 

Hi Lev,

I tried this in my database and it isn't working at all. I'm not getting any name fields at all in my user table. I'm only getting the AD userid.

Here's what my dbo.adduser stored proc looks like:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[AddUser]

@PortalID int,

@Username nvarchar(100),

@FirstName nvarchar(50),

@LastName nvarchar(50),

@AffiliateId int,

@IsSuperUser bit,

@Email nvarchar(256),

@DisplayName nvarchar(100),

@UpdatePassword bit,

@Authorised bit

AS

DECLARE @UserID int

SELECT @UserID = UserID

FROM Users

WHERE Username = @Username

IF ( @DisplayName is null OR @DisplayName = ' ' )

BEGIN

SET @DisplayName = @FirstName + ' ' + @LastName

END

IF @UserID is null

BEGIN

INSERT INTO Users (

Username,

FirstName,

LastName,

AffiliateId,

IsSuperUser,

Email,

DisplayName,

UpdatePassword

)

VALUES (

@Username,

@FirstName,

@LastName,

@AffiliateId,

@IsSuperUser,

@Email,

@DisplayName,

@UpdatePassword

)

SELECT @UserID = SCOPE_IDENTITY()

END

IF @IsSuperUser = 0

BEGIN

IF not exists ( SELECT 1 FROM UserPortals WHERE UserID = @UserID AND PortalID = @PortalID )

BEGIN

INSERT INTO UserPortals (

UserID,

PortalID,

Authorised

)

VALUES (

@UserID,

@PortalID,

@Authorised

)

END

END

SELECT @UserID

My setup is SQL 2000 (MSDE)

DotNetNuke 4.3.4 source

Win2k Server

Any ideas?

Thanks,

David

 

Lev,

Thanks for the info. I downloaded the LDAP browser and we were able to access AD. So I atleast know now that the server running DNN can access AD and we were able to verify that the givenName and sn fields were there and filled in properly. This leads me to believe that your first scenario is the problem and for some reason DNN itself can't access AD. Any ideas on what could be causing this and how to fix it? I'm also still getting the error that windows authentication is unavailable when ever I try to set it up through DNN and we've tried everything. Right now it's in a partial working state even though DNN says it's not available, users are getting auto logged in but we have to go into the database and fill in the name information. We also have another odd issue where one user keeps getting logged in as the server admin instead of himself. I'm starting to think somewhere along the line I borked something even though this is a fresh install and we haven't made any modifications to any of the code other then following the steps laid out here in the forums for trying to get windows auth working.

At this point I'm at a complete loss!

David