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 ...
22nd June 2010, 12:02 PM #1
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
IDG Tech News
23rd June 2010, 08:19 AM #2
Ok slap me if i'm wrong but spaces in usernames??
23rd June 2010, 08:22 AM #3
also, did you set up SQLExpress with SQL Authentication or windows(mixed) authentication?
23rd June 2010, 10:05 AM #4
Ive changed the login, its now Username:Tracker
I set it up with Windows authentication.
23rd June 2010, 10:20 AM #5
have you enabeld the TCP/IP configuration to enabled - without this the server wont accept remote connections
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
23rd June 2010, 10:51 AM #6
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.
By apearce in forum Virtual Learning Platforms
Last Post: 11th October 2011, 04:34 PM
By localzuk in forum MIS Systems
Last Post: 21st June 2010, 10:46 AM
By DSapseid in forum Windows
Last Post: 18th May 2009, 12:48 PM
By wesleyw in forum Windows
Last Post: 28th June 2006, 08:42 AM
By chrbb in forum Windows
Last Post: 18th January 2006, 11:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)