+ Post New Thread
Results 1 to 6 of 6
EduGeek Logon Tracker Thread, SQL Server Details in Projects:; Hi, Im having some trouble with the Edugeek Logon Tracker. Every time i run the script i get this error ...
  1. #1
    fairm010's Avatar
    Join Date
    Jun 2010
    Location
    C:/Windows/System32/
    Posts
    1,143
    Thank Post
    47
    Thanked 146 Times in 128 Posts
    Rep Power
    45

    SQL Server Details

    Hi, Im having some trouble with the Edugeek Logon Tracker.

    Every time i run the script i get this error message (Attached).

    As far as i can work out it is a problem with the details I have entered in the Logon & Logoff Scripts.

    This is my code... anything wrong with it?

    Const DB_Server = "SERVER01\SQLEXPRESS"
    Const DB_Name = "edugeeklogontacker"
    Const DB_User = "DEDWORTH\matt f"
    Const DB_Pass = ""

    'This must be a user with admin rights on the remote PCs
    Const strShutDownUser = "DEDWORTH\matt f"
    Const strShutDownPass = "password
    Attached Thumbnails Attached Thumbnails SQL Server Details-untitled.bmp  

  2. #2
    sister_annex's Avatar
    Join Date
    Jan 2009
    Location
    Wolverhampton
    Posts
    593
    Thank Post
    99
    Thanked 135 Times in 119 Posts
    Rep Power
    49
    Ok slap me if i'm wrong but spaces in usernames??

  3. #3
    sister_annex's Avatar
    Join Date
    Jan 2009
    Location
    Wolverhampton
    Posts
    593
    Thank Post
    99
    Thanked 135 Times in 119 Posts
    Rep Power
    49
    also, did you set up SQLExpress with SQL Authentication or windows(mixed) authentication?

  4. #4
    fairm010's Avatar
    Join Date
    Jun 2010
    Location
    C:/Windows/System32/
    Posts
    1,143
    Thank Post
    47
    Thanked 146 Times in 128 Posts
    Rep Power
    45

    change

    Ive changed the login, its now Username:Tracker
    password: tracker

    I set it up with Windows authentication.

  5. #5
    sister_annex's Avatar
    Join Date
    Jan 2009
    Location
    Wolverhampton
    Posts
    593
    Thank Post
    99
    Thanked 135 Times in 119 Posts
    Rep Power
    49
    have you enabeld the TCP/IP configuration to enabled - without this the server wont accept remote connections

    Usually;
    start>Programs>MS SQL 2005>Configuration>SQL Server Configuration

    select SQL Server 2005 Network Configuration> protocols for <instance>

    Right click named pipes select enable
    do the same for TCP/IP

    restart the SQL Services

    see if that helps

  6. #6

    Join Date
    Apr 2006
    Posts
    388
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    In addition to the above, if you're attempting to log in using a SQL account like that you'll need to ensure that mixed mode is enabled. Have a look at this: How do I configure SQL Server 2005/2008 to accept SQL Authentication?

    I'm a big fan of using SQLCMD to troubleshoot login issues, as it takes your code/application out of the equation. So for example, you can test that you've got a valid login and that your database is accesible by using a command like:

    sqlcmd -U tracker -P tracker -S SERVER01\SQLEXPRESS -d edugeeklogontacker

    You can do this from the server's command line to test that the login is valid, or for full effect test from a client PC (that has SQLEXPRESS or better installed) and also test the connectivity. If it's successful you get a rather low-key prompt 1>

    If you're wanting to use Windows authentication then things get a little livlier - I don't know enough about the app to know if it supports it, sorry.

SHARE:
+ Post New Thread

Similar Threads

  1. Installing Moodle on Windows Server, SQL Server, IIS
    By apearce in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 11th October 2011, 04:34 PM
  2. Replies: 5
    Last Post: 21st June 2010, 10:46 AM
  3. SQL Server
    By DSapseid in forum Windows
    Replies: 1
    Last Post: 18th May 2009, 12:48 PM
  4. SQL Server
    By wesleyw in forum Windows
    Replies: 5
    Last Post: 28th June 2006, 08:42 AM
  5. sql server
    By chrbb in forum Windows
    Replies: 17
    Last Post: 18th January 2006, 11:23 PM

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
  •