Login failed for user 'admin'

Last post 10-05-2007, 9:55 PM by mjhaynes. 4 replies.
Sort Posts: Previous Next
  •  10-05-2007, 12:19 PM 34051

    Login failed for user 'admin'

    Hello everyone!
     
    As stated in the subject line, I'm not getting the 'admin' user to login to the database...
     
    I've ran Cute Live Support as a module in DNN, without any problems...However, when I attempt to set this up on my server [Windows 2003 / SQL 2005 Standard Edition / IIS 6.0 running .NET Framework 2.0], I'm getting this same error every which way I go. 
     
    I'm using what I see in the database [dbo.MyUsers = UN:admin/PW:admin] and have done everything from granting full rights to the NETWORKSERVICE under the public/root folder [propagating through all child objects], the IIS Website and Virtual [tried it both ways], and the SQL Database.
     
    Nothing clears this up. 
     
    I've also ensured that the SQL TCP connections are listening on port 1433, disabled Windows Firewall, and enabled communications through my router on this and other related port. 
     
    In a previous troubleshooting session, I added a Login account in SQL Security for the database, which required a more encrypted password than 'admin'...and connected it to the database, and was able to login - but then I wasn't able to see the 'Admin' link in the top include file for the configuration page [like the Flash video/tutorial presentation shows]...
     
    I could logout, I could change the password, and re-login successfully - but still no 'Admin' link for me to setup an operator.
     
    Well, I've since deleted the directory, database, and IIS entry.  I've re-downloaded and configured the stand alone app, configured NETWORKSERVICE permissions on the directory, added the database, added the permissions for the NETWORKSERVICE, setup the IIS virtual, assigned permissions, ran the SQL queries against it, and attempted to login to no avail:
     
     
    I really liked the functionality from within DNN, but I need this one to be a stand alone...
     
    Has anyone else come across this, and found a solution?
     
    Thanks in advance for all of your help here on the threads!
  •  10-05-2007, 3:59 PM 34058 in reply to 34051

    Re: Login failed for user 'admin'

    mjhaynes,
     
    Can you tell me which user is admin? Do you have a username?
     
    For example, if you register a username Denis, you want him an admin of your web site.
     
    You can modify the Global.asax.cs file.
     
    Change line 55 from:
     

    if(string.Compare(useruniquename,"admin",true)==0)

    to:
     
    if(string.Compare(useruniquename,"Denis",true)==0)
     
    Then recompile the project.
     
     
     
     

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

  •  10-05-2007, 8:06 PM 34065 in reply to 34058

    Re: Login failed for user 'admin'

    Hi Adam,
     
    The short answer is 'no'...
     
    But, I did have a unique username assigned to the database before [as well as in the web.config file].  This user was registered uniquely within the SQL Security panel of the database...
     
    Username = 'chatadmin'
     
    Because I am using SQL Authentication instead of Windows Authentication for the login to the database, I just figured that it was necessary to have a user assigned in order to gain login privileges. 
     
    However, after 'chatting' with you earlier today, I was told that the username had to be 'admin' - at least the first username in the dbo.MyUsers table. 
     
    Fortunately or unfortunately [take your pick] SQL Server 2005 has strict built-in password encryption features, I wasn't able to assign a user 'admin', with a password of 'admin'...This was too weak of a password according to the SQL message...
     
    Nevertheless, I suppose at this point, I need to know if you feel it is best that I try this again, making changes to the global.asax.cs file and setup another SQL-based login user, with read and write privileges [I suppose I could go with dbo.owner]...?  As well as change the web.config file to coorelate?
     
    Thanks again for all your help!
     
     
     
  •  10-05-2007, 8:28 PM 34066 in reply to 34065

    Re: Login failed for user 'admin'

    >>Fortunately or unfortunately [take your pick] SQL Server 2005 has strict built-in password encryption features, I wasn't able to assign a user 'admin', with a password of 'admin'...This was too weak of a password according to the SQL message...
     
    Run LiveSupportWeb.SQL again your DB.

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

  •  10-05-2007, 9:55 PM 34067 in reply to 34066

    Re: Login failed for user 'admin'

    Here's what I get when I run the query against the 'CHAT' database I created [please see notes to follow]:
     
    ################################################################################

    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyUsers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

    drop table [dbo].[MyUsers]

    GO

    CREATE TABLE [dbo].[MyUsers] (

    [LoginName] [nvarchar] (20) NOT NULL ,

    [NickName] [nvarchar] (50) NOT NULL ,

    [Password] [nvarchar] (50) NOT NULL ,

    [Email] [nvarchar] (50) NOT NULL

    ) ON [PRIMARY]

    GO

    ALTER TABLE [dbo].[MyUsers] WITH NOCHECK ADD

    CONSTRAINT [PK_MyUsers] PRIMARY KEY CLUSTERED

    (

    [LoginName]

    ) ON [PRIMARY]

    GO

    CREATE UNIQUE INDEX [IX_MyUsers] ON [dbo].[MyUsers]([NickName]) ON [PRIMARY]

    GO

    -- Add the portal-administrator

    IF NOT EXISTS (SELECT LoginName FROM MyUsers WHERE LoginName='Admin')

    INSERT INTO MyUsers (LoginName, NickName, Password,Email) VALUES ('admin', 'admin', 'admin','admin@yoursite.com')
     
     
    ################################################################################
     
    At the end of all of this in the Message pane, I receive the following [which I've received every time I've ran th LiveSupportWeb.SQL query]:

    (1 row(s) affected)
     
    ################################################################################

    Upon running the query against the database a second time, I am still receiving the same results:

    http://makingthingsclickeveryday.com/liveChat

    I also discovered that my SQL server IS, in fact, running in mixed mode [Windows/SQL Authentication], and that this particular database, 'CHAT' is authenticating using Windows Authentication, which would suggest that there is no need to create the additional unique user/login account...But, the failed login doesn't help it's case...
     
    Am I wrong on this?  Does it even matter or help us zero-in on what may be causing the invalid login results?
     
    Thanks, as always!
     
     
     
     
View as RSS news feed in XML