User gets an error that they are already logged in

As with the local version of this error, this can occur because the connection to the database was abruptly severed and the database is holding onto the login. The solution to this is to open the Management Studio\Enterprise Manager and go to the query analyzer. From here select the proper database to work with and use the command [SELECT * FROM LOGIN]. This will allow you to see all of the users logged into the system at the time. If only one user is displayed and it is the user having the issue, then the command [DELETE FROM LOGIN] will be sufficient to resolve the problem. If, however, more than one user is displayed, you will need to add a WHERE clause to specify which user to delete from the system so as not to disrupt other users. You can use either the user’s ID or Name to make this specification. It is also possible that this is not an error but that another user is actually using the login to connect. In this case, the network administrator will need to track down the IP address currently connected to the database and either ask them to log out or ask the user to wait until the other user is done or create a new login in the software.