Hi,
my SQL version is 2005 standard. I have to activate with license.

I have already installed 2005 standard but now I want to activate with my new license. is it possible. can anyone give me steps to activate with license.

Thanks,

Hello - As far as I am aware, Unlike Windows Operating System, there is no activation process required for SQL Server Standard Edition. The process is only applicable for Enterprise Evaluation Edition which has built-in Expiry period of 180 Days after which you have upgrade to either Enterprise edition or follow steps to downgrade it.

For Non-trial editions such as Standard Edition or Enterprise edition, you just need to make sure that you have valid License in Soft copy or Hard-copy

More information here:

http://www.techsoup.org/support/articles-and-how-tos/guide-to-sql-server-editions-and-licensing#licensing

Hope this helps !

Hello Manu,

Thank you for your email.

please find the screenshot attached and suggest on the same.

Thank in advance.

Hello - There is no screenshot that we can see. Can you post it correctly again ?

Hi,

sorry. please find the screenshot attached here.

Thanks,

Its already standard.

Yes, it is a standard and it is going to expire in 57 days. I want to activate the permanent license. how can we do that. is there a way of activation of license without uninstall and reinstall.

Thanks,

Hello - You need not worry about this. The information displayed is only for illustration purpose and is valid ONLY for Enterprise Evaluation Edition.

In-fact in my environment, I am already running SQL Server 2008 Standard Edition which as per the below T-SQL query should have got expired on 15th March 2015 whereas It did not because it is Standard Edition.

Just be sure that you have obtained paper or soft-copy license from Microsoft

SELECT
@@SERVERNAME SERVERNAME,
CREATE_DATE 'Installation Date',
SERVERPROPERTY('EDITION') 'Edition',
DATEADD(DD, 180, CREATE_DATE) AS 'Expiry Date'
FROM SYS.SERVER_PRINCIPALS
WHERE SID = 0X010100000000000512000000

Hope this helps !

Hello Manu,

Thanks for your reply. I am using the same query.

I am worried as it is production environment. how can we can check whether the license is applied or not?

Thanks & Regards,

Prasad