January 3, 2012 at 4:37 am
I am using SQL server, below are the information of it
Description: SQL Server Database Services 2008 R2
ProductName:SQL2008
Type:RTM
Version:10
SPLevel:1
PatchType:SP
PatchLevel:10.51.2500.0
ProductVersion:10.50.1600.1
I wanter to check the expiry date of this version..
i tried to find out it in two way: (1) C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\setup.txt (2) Microsoft SQLSERVER management Studio -> Help->about
but in both i didn't get expiry date of version.
Thanks & Regards,
Pallavi
January 3, 2012 at 5:13 am
What do you mean by expiry date?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2012 at 5:18 am
Some trial versions has expiry date which are downloaded from internet.
after 102 days or 120 days the version get expired...
So i wanted to know the free downloaded version expiration date in MSSQL 2008 R2...
Thanks & Regards,
Pallavi
January 3, 2012 at 5:42 am
The eval version is 180 days, so look at the date of the setup logs (which will be the date of installation) and calculate 180 days from there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2012 at 7:08 am
Just to make sure you installed EVAL edition only...
SELECT SERVERPROPERTY('productversion'),
SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
January 3, 2012 at 7:14 am
:hehe:
You can check the windows installer for the SQL Product code to pull out the install date
In registry look under,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\<GUID>\InstallProperties
Notes :
The "InstallDate" key will have the date stored in YYYYMMDD
For SQL 2008 you can search for "Microsoft SQL Server 2008 Database Engine Services" to get the correct GUID.
For SQL 2005 you can search for "Microsoft SQL Server 2005" only to get the correct GUID
January 3, 2012 at 10:09 am
Open the Management Studio, click on the “Help” of Menu Bar and then on “About”. A new window will appear, where you will see some thing like if you have trial version installed:
Microsoft SQL Server Management Studio (expires in xxx days)
January 3, 2012 at 9:15 pm
I checked there in Help -> About ->
but it doesn't mentioned the date i got the below informtion
Microsoft SQL Server Management Studio:10.50.2500.0
Microsoft Data Access Components (MDAC) :3.85.1117
Microsoft MSXML:2.6 3.0 5.0 6.0
Microsoft Internet Explorer :6.0.2900.2180
Microsoft .NET Framework :2.0.50727.3053
Operating System:5.1.2600
Thanks & Regards,
Pallavi
January 4, 2012 at 7:04 am
Is it installed on local machine or remote server?
January 5, 2012 at 12:35 am
Installed on remote server...
How can i extend date of expiry??????
OR
Please tell the solution if you have any ...
Thanks & Regards,
Pallavi
January 5, 2012 at 7:10 am
Hi ,
Well only way to extend the date is buy a similar version and update it. There is no way to extend automatically . Or consult to your Manager as well as sysadmin group.
January 5, 2012 at 7:16 am
pallavi.unde (1/5/2012)
Installed on remote server...How can i extend date of expiry??????
Buy a licensed copy of SQL Server and upgrade.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply