Login failed for user 'admin'

  •  10-05-2007, 12:19 PM

    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!
View Complete Thread