+ Post New Thread
Results 1 to 7 of 7
Network and Classroom Management Thread, My Little Helpdesk help needed in Technical; Could someone please send me a step by step document on how to get this working.. as I am stumped ...
  1. #1
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    My Little Helpdesk help needed

    Could someone please send me a step by step document on how to get this working.. as I am stumped

    1/ How to see if the server is OK for it

    2/ How to instal mysql / sql and how to make an empty database

    3/ Where to copy the MLH files (i know it's the root but where is that)

    Thanks :-)
    Last edited by Grommit; 2nd April 2008 at 11:40 AM.

  2. #2

    Join Date
    Jul 2007
    Location
    Devon
    Posts
    233
    Thank Post
    8
    Thanked 9 Times in 8 Posts
    Rep Power
    16
    1. If you can run MySQL/SQL Express/ IIS... you can run this. (I split IIS and database for other reasons and that works pretty well )

    2. I downloaded SQL 2005 Express from the microsoft site.

    Follow the instructions to install and set up a database from there too... it's pretty easy (except when it comes to granting access to SQL, I just used the SA account in the end )

    3. Copy the whole folder to C:\Inetpub\www_root\

    Unless you've set up another IIS account to run it, in which case, use that folder.


    I've not used 9.6b yet, so I might be wrong

  3. #3
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Lithium is correct is what he has stated.

    Do you already have an SQL server running at your school?? if you do can you not create a new database on there??

    If you do decide to go the MS SQL Express route I would also use mixed mode authentication as Windows only authentication can be difficult to setup.

    This link cover step by step installing of MS SQL Express:
    http://technet.microsoft.com/en-us/l.../ms143722.aspx

    This link covers step by step installing of MySQL:
    http://dev.mysql.com/doc/refman/5.0/...tallation.html

    To install MyLittleHelpdesk follow these steps:
    1 - Create an empty MySQL or MSSQL database with the relevant user access.
    2 - Unzip and upload the MLH folder to the root of your website.
    3 - Edit the details found in the incs\db_connect.asp file with the details of you databse server and user.
    4 - Point your browser at http://{your_url}/MLH/Install/ and follow the install wizard.
    5 - Your helpdesk is now ready to use.

    Let me know if you need anything else

  4. #4
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25
    Quote Originally Posted by ICTNUT View Post
    Lithium is correct is what he has stated.

    Do you already have an SQL server running at your school?? if you do can you not create a new database on there??

    If you do decide to go the MS SQL Express route I would also use mixed mode authentication as Windows only authentication can be difficult to setup.

    This link cover step by step installing of MS SQL Express:
    How to: Install SQL Server Express

    This link covers step by step installing of MySQL:
    MySQL :: MySQL 5.0 Reference Manual :: 2.4.8 Installing MySQL on Windows

    To install MyLittleHelpdesk follow these steps:
    1 - Create an empty MySQL or MSSQL database with the relevant user access.
    2 - Unzip and upload the MLH folder to the root of your website.
    3 - Edit the details found in the incs\db_connect.asp file with the details of you databse server and user.
    4 - Point your browser at http://{your_url}/MLH/Install/ and follow the install wizard.
    5 - Your helpdesk is now ready to use.

    Let me know if you need anything else

    Hi

    This little helpdesk is doing my head in :-)... I can't install it for love of money...

    PC XP Pro SP 2

    Installed IIS and MS SQL Express

    Copied the MLHD folder into the

    Made a database called in the database tree called "Helpdesk"

    Made a login in security tree below the Database tree...
    user: MLHD
    password: XXXX
    Made new login: sysadmin

    Run http://{your_url}/MLH/Install/

    SQL Server Name / IP: Is this the Name of the PC ?
    SQL Server Database Name: Helpdesk ?
    SQL Server Username: MLHD ?
    SQL Server Password: XXXX ?
    SQL Server Type: MySQL Server MS SQL Server ?

    And ity keeps failing,,, says there is a problem with the user account..

    Error Connecting to database on SQL Server

    Check the following is set up and correct:-

    SQL Server Username
    SQL Server Password


    -2147467259 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied..


    I need to have the helpdask so that the staff do not have to get user accounts to post a fault... as they are already authenticated by logging onto the PC..
    Last edited by Grommit; 1st April 2008 at 02:30 PM.

  5. #5
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25
    Any ideas why this isn't working ... anyone ?

  6. #6

    Join Date
    May 2007
    Location
    Hull, UK
    Posts
    256
    Thank Post
    6
    Thanked 13 Times in 13 Posts
    Rep Power
    17
    I had the same problem, this link sorted me out.

    Help configuring MSSQL2005 & MLH

  7. #7

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,923
    Thank Post
    709
    Thanked 551 Times in 366 Posts
    Blog Entries
    3
    Rep Power
    204
    Quote Originally Posted by Grommit View Post
    Hi

    This little helpdesk is doing my head in :-)... I can't install it for love of money...

    PC XP Pro SP 2

    Installed IIS and MS SQL Express

    Copied the MLHD folder into the

    Made a database called in the database tree called "Helpdesk"

    Made a login in security tree below the Database tree...
    user: MLHD
    password: XXXX
    Made new login: sysadmin

    Run http://{your_url}/MLH/Install/

    SQL Server Name / IP: Is this the Name of the PC ?
    SQL Server Database Name: Helpdesk ?
    SQL Server Username: MLHD ?
    SQL Server Password: XXXX ?
    SQL Server Type: MySQL Server MS SQL Server ?

    And ity keeps failing,,, says there is a problem with the user account..

    Error Connecting to database on SQL Server

    Check the following is set up and correct:-

    SQL Server Username
    SQL Server Password


    -2147467259 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied..


    I need to have the helpdask so that the staff do not have to get user accounts to post a fault... as they are already authenticated by logging onto the PC..
    Can be server name or IP but make sure that in following format for sql2005: -

    servernameorip\databasename

    Russ

SHARE:
+ Post New Thread

Similar Threads

  1. What do you look for in a helpdesk?
    By bizzel in forum Coding
    Replies: 19
    Last Post: 23rd March 2011, 04:41 PM
  2. My Little Helpdesk v0.9.6b
    By pmassingham in forum Downloads
    Replies: 5
    Last Post: 8th April 2008, 03:00 PM
  3. Medieval helpdesk
    By tomlin in forum General Chat
    Replies: 8
    Last Post: 12th October 2007, 11:35 AM
  4. One or Zero Helpdesk
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 18th October 2006, 08:30 AM
  5. advice needed on weather a new server is needed
    By projector1 in forum Hardware
    Replies: 3
    Last Post: 24th February 2006, 09:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •