Licensing

[Former Member]

SAP licensing has an interesting 'feature' which allows a user to be connected twice to the same database. Sometimes this is helpful, i.e. when their client crashes, sometimes we would rather not have this 'feature' at all.

How can I tell from which PC the user is connected?

How can I tell if the user is connected twice?

[former_member201110 · Accepted solution]

Hi Piotr,

If you are using Windows Authentication to connect to the database and you are using separate workstations (rather that a TS or Citrix server) then you can probably use the database server to tell you who is connected. In SQL Server, you can use the sp_who stored procedure and this will identify the user (loginname), workstation (hostname) and company (dbname). You can get the same information through the Enterprise Manager (of Studio Management in SQL 2005). Sadly, this method is useless if you are using SQL authentication and each workstation is set to use the same connection details as you will then be unable to identify the users. It also can't tell you how many times the user is logged in to a company from the same workstation because it shows SQL connections and not SBO licenses used.

The SBO Gui itself can show you who is logged in but not how many times. There is a license server API available for reading license information but I've never used it so I can't say if it can be used to get the information you need. Perhaps someone else can clarify...?

Kind Regards,

Owen

[Former Member · Accepted solution]

I think the license server cannot help. It gives the logged in users, but it does not tell you where this user is connected from and to which database(company). As far as I remember if a certain user is connected twice (it doesn't matter whether this is to the same company or not) it is returned as a one logged in user.

Svilen