SQL Server Details

[fairm010]

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

[sister_annex]

Ok slap me if i'm wrong but spaces in usernames??

[sister_annex]

also, did you set up SQLExpress with SQL Authentication or windows(mixed) authentication?

[fairm010]

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

I set it up with Windows authentication.

[sister_annex]

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

[theriver]

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.