Licenses Mysteriously Deactivated

tlbroadbent · November 25, 2008 10:12AM

I opened the SQL Response client today and all SQL servers showed the message "trial period has expired." All of these servers had activated licenses. The Server menu showed showed both Activate Server License and Deactivate Server License in a disabled state. Likewise, right-clicking the each server showed the Licenses entries on the menu were disabled.

I uninstalled and the installed the Alert Repository. Now all SQL Servers indicate the activated license and the Deactivate menu selection is enabled. Is there a known reason why this might occur? Is there anything we can do to prevent this from occurring in the future?

I was out of the office and had not used SQL Response client for a few days. It appears that SQL Response Alert Repository stopped functioning sometime on Nov. 20. We have no alerts for nearly five days.

Additional information: At 9:15AM on Nov. 20, the server hosting the Alert Repository was rebooted. At 9:19AM SQL Response recorded an alert that the SQL Server computers were unrachable. There are no other alersts from that point until the Repository was reinstalled this morning.

Thank you for your assistance.

Nigel Morse · November 25, 2008 12:18PM

Hi
Really sorry you've had this problem - I'm not sure what's happened... i've not hear of this before at least.

Could you please answer the following first:
- When you reinstalled did you have to reactivate or did the servers just come back as activated?
- Did you try just restarting the alert repository service before reinstalling?

Also if you could gather the logs from the Alert Repository machine (in documents and settings/all users/application data/red gate/logs/....) and then send them to support@red-gate.com (and put a link to this forum post in so they know to send the files to me) that would be great - thanks.

tlbroadbent · November 25, 2008 6:54PM

Nigel,

Thanks for your reply. I sent the logs in one ZIP file.

I did not try to restart the Alert Repository before reinstallig.

I did not have to activate licenses. They were activated when I connected to the repository.

Terry

Nigel Morse · November 26, 2008 3:58AM

Thanks. I suspect that just restarting the service would have worked as well in that case - but obviously it shouldn't happen in the first place. I'll take a look at the logs and see what I can glean.

Nigel Morse · November 27, 2008 6:55AM

Ok - the logs came through. Because they were so big the ones for the time when it was rebooted had been deleted, however the ones that were left showed the problem.

There's a bug in the Microsoft SQL connection stuff for which there is a fix on here http://support.microsoft.com/kb/948176. Sadly it seems to be an on-request fix rather than a download, however they do say it would be in the next service pack (though if that is shipped yet I can't tell - The list of fixes for .NET 2.0 SP1 doesn't list this fix (http://support.microsoft.com/kb/945757/))

It seems that once this error occurs it keeps recurring so the only way is to restart the repository and hope it doesn't happen again.

However we'll try and make a case to reproduce it here and then hopefully we can try and put a workaround in to fix, or at least detect this happening and take action. I'll add it to our issue tracking system in the meantime.

EDIT: So that people searching for this error the stack trace in the log that shows this is like

06:26:00.616|Error  |AlertRepository     |28 |SqlServerUpMonitor : Failed to get information from SQL Server &lt;servername&gt; &#40;code 0&#41;|System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at SNINativeMethodWrapper.SNIOpenEx&#40;ConsumerInfo consumerInfo, String constring, IntPtr& pConn, Boolean fInitSec, Byte&#91;&#93; sspiBuffer, Byte&#91;&#93; instanceName, Boolean fOverrideCache, Boolean fSync&#41;
   at System.Data.SqlClient.SNIHandle..ctor&#40;ConsumerInfo myInfo, String serverName, Boolean integratedSecurity, Byte&#91;&#93; serverUserName, Boolean ignoreSniOpenTimeout, Int32 timeout, Byte&#91;&#93;& instanceName, Boolean flushCache, Boolean fSync&#41;
   at System.Data.SqlClient.TdsParserStateObject.CreatePhysicalSNIHandle&#40;String serverName, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Byte&#91;&#93;& instanceName, Boolean integratedSecurity, Byte&#91;&#93; serverUserName, Boolean flushCache, Boolean async&#41;
   at System.Data.SqlClient.TdsParser.Connect&#40;ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject&#41;
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin&#40;ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject&#41;
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover&#40;String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart&#41;
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist&#40;SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance&#41;
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor&#40;DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance&#41;
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection&#40;DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection&#41;
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection&#40;DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options&#41;
   at System.Data.ProviderBase.DbConnectionPool.CreateObject&#40;DbConnection owningObject&#41;
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest&#40;DbConnection owningObject&#41;
   at System.Data.ProviderBase.DbConnectionPool.GetConnection&#40;DbConnection owningObject&#41;
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection&#40;DbConnection owningConnection&#41;
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection&#40;DbConnection outerConnection, DbConnectionFactory connectionFactory&#41;
   at System.Data.SqlClient.SqlConnection.Open&#40;&#41;
   at g.a&#40;String &#41;
   at l.GetConnection&#40;&#41;
   at aw.a&#40;V &#41;
   at az.a&#40;&#41;
   at az.RunNow&#40;&#41;

tlbroadbent · November 28, 2008 11:40AM

Nigel,

Thanks for the update. I'll discuss installing the Hotfix with our team. In the meantime, if the problem occurs again, I will restart the Repository.

xdai · January 7, 2009 3:10PM

Hi,

we are using sql response 1.1. Have the same issues on this topic, this morning two servers with active licenses specifying that trial period expired. I have to restart alert repository service, and the problem fixed. Please let us know what would be the permanent fix. thanks

Nigel Morse · January 7, 2009 4:57PM

If you're seeing the same stack trace in the logs then the only fix available now is the hotfix from Microsoft that I mentioned in my last post here.

xdai · January 7, 2009 4:58PM

no, it is different, that's why i post it.

Nigel Morse · January 7, 2009 5:01PM

Ah - in which case it may be a different problem. Could you send the alert repository logs to support@red-gate.com (and reference this thread in your email so they know to send it to me - thanks)

xdai · January 7, 2009 5:07PM

i just sent two log files, please let me know you got it. thanks

xdai · January 7, 2009 5:54PM

i tried to send two log files, but they are big, like 20M (not sure you could receive it), can you suggest another way (ftp) to get it?

Nigel Morse · January 8, 2009 3:25AM

If you email support they should be able to sort out an ftp transfer you.

Nigel Morse · January 8, 2009 6:43AM

Thanks - I have them now. The problem here is very different so I've passed the logs to the current response team who are investigating a similar issue to the one you seem to have.

thanks

Scott Herbert · January 15, 2009 6:04PM

I had this problem as well. Swore a bit, re-entered my serial numbers and all was back to normal. Fingers crossed it doesn't happen again.

dylanfinney · March 18, 2009 2:24PM

Scott Herbert wrote:

I had this problem as well. Swore a bit, re-entered my serial numbers and all was back to normal. Fingers crossed it doesn't happen again.

Exact same resolution here. Strange because prior to this happening I was at the limit of my license and when I re-entered it I received no errors. Maybe this re-activation doesn't look for valid license seats to be left?

tyronc12 · November 29, 2024 5:45PM

ninguno fué capaz de aclarar como activar office , estaría muy bueno que lo hicieran, especificamente office del año 2019, tiene que haber alguna manera de hacerlo que no sea pagando la licencia ¿verdad? no creo estar tan demente, alguna manera debe haberla, pero ¿como? si alguien aqui pudiera ayudarme estaría mas que agradecido, gracias

jeki · November 29, 2024 6:06PM

Hola. Averiguar cómo activar Office 2019, sin comprar una licencia, puede ser complicado. Normalmente, no hay formas legales de saltarse la licencia y lo mejor es utilizar métodos de activación oficiales. Si tienes familiares o amigos, puede que tengan una licencia que puedan compartir.También si buscas en google, puedes encontrar información sobre cómo activarlo.

Irena · December 4, 2024 8:32AM

Tienes toda la razón en que encontrar una forma legal de activar Office 2019 puede ser complicado. Siempre es mejor ceñirse a los métodos oficiales para evitar posibles problemas posteriores. Mi consejo es que utilices Office 2019 descargar. Allí encontrarás todo lo que te interesa, seguro. ¡Pero recuerda siempre que usar los canales oficiales es lo más seguro!

Licenses Mysteriously Deactivated

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk