Installation and Technical Issues

[hkeasling]

We would like to track Logon and Logoff for our users. Looked in Sage MAS 500 and it says the table has fields for tsmUser for these times but not utilized. Any suggestions on how to track?

[jnoll · Accepted solution]

If you are using SQL 2005 or greater and I hope you are, then you can do this inside of SQL Server if you right-click on the Server and select Properties from the context menu you can then go the the Security option. At this level you can log SQL Login for Successful Logins or Successful and Failed Logins. You can look in the SQL Books Online by doing a search on 'Logins [SQL Server]'. This is a great resource.

If you are in SQL Server 2008 here is a good resource.

http://msdn.microsoft.com/en-us/library/dd392015(v=SQL.100).aspx

[hkeasling]

Thanks for the info Joe, this will solve the issue.

Hugh