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

 

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.