Infralution Support

gmantri · Joined: 02 Dec 2009 Posts: 4 Location: India

Hi,

I downloaded the licensing product yesterday and start using it. So far I am finding it extremely easy to understand and use. However I have some questions:

1. When I use License Key Generator application to generate license keys (say I am generating 2 keys), it generates different keys but they don't get stored in the database. However when I use the License Tracker application to generate license keys, it always generate same license keys. Is this an evaluation thing?

2. I found the License Tracker extremely slow. I believe it is talking to the database as I switch between the tabs to get the information. My database is SQL Server 2008 and is running locally on my computer. What could be the reason for that?

As I explore this product more, I am sure I will have a lot of questions. Are there any threads on this forum dedicated just for starters like me so that I don't end up asking same questions which have been asked before and save everybody some time.

Thanks again

Gaurav Mantri

Infralution · Joined: 28 Feb 2005 Posts: 5027

gmantri · Joined: 02 Dec 2009 Posts: 4 Location: India

Infralution · Joined: 28 Feb 2005 Posts: 5027

billb · Joined: 27 Dec 2009 Posts: 5

FWIW, I just began evaluating yesterday and I'm experiencing the exact same behavior with what seems like a very similar configuration (Win 7 x64, 4GB of RAM). Not a deal killer, but seemed strange. I only have 1 product but even with 0 products, it behaved this way.

Infralution · Joined: 28 Feb 2005 Posts: 5027

Were you using an SQL database also or the Access backend? If you switch to Access does the performance improve? We will setup a test machine with this configuration and do some of our own testing.
_________________
Infralution Support

billb · Joined: 27 Dec 2009 Posts: 5

Infralution · Joined: 28 Feb 2005 Posts: 5027

You don't need to have Access installed to use the Access database. Just run the License Tracker Installer Wizard and select the Access option.
_________________
Infralution Support

tomazv · Joined: 29 Jan 2010 Posts: 5

I am also evaluating the product and have the same problem.

Configuration: Vista x64, 4GB RAM, SQL 2008 SP1 Express edition

I switched to Access, and it works fine.

However, when I try to switch back to SQL database using License Tracker Configuration Wizard, I get an error (SQL Server does not exist or access denied). If I use SQL Server Management Studio, I can connect to the server.

Infralution · Joined: 28 Feb 2005 Posts: 5027

What are you setting as the SQL Server name? For SQL Express the server name should probably be ".\SQLEXPRESS". If you want to copy the data from you Access database into the SQL Server database you will have to specify an empty or new database (by setting the Database Name to a database that doesn't exist yet).
_________________
Infralution Support

Infralution · Joined: 28 Feb 2005 Posts: 5027

I have loaded up a test machine with a similar configuration as reported by billb and gmantri:

Win 7 x64, 4Gb RAM, SQL Express 2008 with SP1 installed

Unfortunately I was unable to replicate any performance issues. Switching tabs was almost instantaneous with the "Maintain Selection on Sort" option turned off. With it turned on it still only takes a second or two even with a large database. I also tried SQL Express 2005 without any issues.

Are you running SQL Server running on the local machine or connecting to a remote instance?

What are you setting the "SQL Server" entry to in the Wizard?

It should be ".\SQLEXPRESS" if you are running a local instance of SQL Express.
_________________
Infralution Support

tomazv · Joined: 29 Jan 2010 Posts: 5

I have tried using different authentication modes (windows, sql) and server names (., localhost, 127.0.0.1) but it didn't help. When I restared my machine, I was able to change configuration from Access back to SQL, but the application was still very slow when switching tabs.

But then I enabled TCP/IP protocol on the server side using Sql Server Configuration Manager and it worked!

So I guess SQL Server needs to have TCP/IP protocol enabled (it is disabled by default). Now I am also able to change configuration to SQL through the Configuration Wizard without any problems.

Infralution · Joined: 28 Feb 2005 Posts: 5027

This seems strange since on my machine TCP/IP is also marked as disabled in the configuration manager - but I'm not seeing any performance issues.

Anyway good that you've got it working - I'm wondering if this will help the others who have had a similar issue?
_________________
Infralution Support

Infralution · Joined: 28 Feb 2005 Posts: 5027

Also found this forum post which seems to reflect something similar:

http://okdw.com/Community/forums/p/28118/162160.aspx#162160

Scroll down to the last post in the thread.
_________________
Infralution Support

tomazv · Joined: 29 Jan 2010 Posts: 5

It's not an issue for me anymore, but maybe this will help your other users.

Today I also downloaded and install license tracker on my work machine (Win7 x64) and the same thing happend. Also, the solution was the same.

Maybe it's because I have SQL Express installed under the default instance name (MSSQLSERVER). So when I connect to the server, I use "." and not ".\SQLEXPRESS". It shouldn't matter, but it's the only thing I can think of that both machines have in common.