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
Ok slap me if i'm wrong but spaces in usernames??
also, did you set up SQLExpress with SQL Authentication or windows(mixed) authentication?
Ive changed the login, its now Username:Tracker
I set it up with Windows authentication.
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 :)
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.