I downloaded an 180 day eval copy of SQL server 2005 and we wish to utilize
it. However, we purchase an Open License. Is there a wey we can upgrade the
Eval SQL 2005 using the open license we purchase.

thanks
TomW

Short Answer: If it isnt expired then you can just run an update. If it has
expired you will have to uninstall then reinstall.
http://support.microsoft.com/kb/914158

http://www.microsoft.com/sql/downloa...uirements.mspx

Upgrading and Uninstalling the Trial Software
The 180-day trial version of SQL Server 2005 Enterprise Edition can be
upgraded to the fully licensed version of SQL Server 2005 Enterprise Edition
without uninstalling the trial software prior to the end of the 180-day
period. If upgrading to the fully licensed version of SQL Server 2005
Standard Edition, Workgroup Edition, or Developer Edition, it is recommended
that you uninstall the 180-day trial version of SQL Server 2005 Enterprise
Edition before installing the fully licensed version of the other editions.
Please refer to the product documentation for information about upgrading to
the fully licensed software.

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"twilliams" <twilliams@discussions.microsoft.com> wrote in message
news:09BDBD49-7C4F-46AD-851E-7085F36A6450@microsoft.com...
>I downloaded an 180 day eval copy of SQL server 2005 and we wish to utilize
> it. However, we purchase an Open License. Is there a wey we can upgrade
> the
> Eval SQL 2005 using the open license we purchase.
>
> thanks
> TomW

Thanks Warren. The eval has not expired yet however, we purchased an SQL
2005 standard edition. When I downloaded the trial version originally, I can
not recall it giving me a choice of which trial version to download (Standard
or Enterprise). How can one confirm which trial version they are are running.

Thanks
TomW

"Warren Brunk" wrote:

> Short Answer: If it isnt expired then you can just run an update. If it has
> expired you will have to uninstall then reinstall.
> http://support.microsoft.com/kb/914158
>
> http://www.microsoft.com/sql/downloa...uirements.mspx
>
> Upgrading and Uninstalling the Trial Software
> The 180-day trial version of SQL Server 2005 Enterprise Edition can be
> upgraded to the fully licensed version of SQL Server 2005 Enterprise Edition
> without uninstalling the trial software prior to the end of the 180-day
> period. If upgrading to the fully licensed version of SQL Server 2005
> Standard Edition, Workgroup Edition, or Developer Edition, it is recommended
> that you uninstall the 180-day trial version of SQL Server 2005 Enterprise
> Edition before installing the fully licensed version of the other editions.
> Please refer to the product documentation for information about upgrading to
> the fully licensed software.
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
>
> "twilliams" <twilliams@discussions.microsoft.com> wrote in message
> news:09BDBD49-7C4F-46AD-851E-7085F36A6450@microsoft.com...
> >I downloaded an 180 day eval copy of SQL server 2005 and we wish to utilize
> > it. However, we purchase an Open License. Is there a wey we can upgrade
> > the
> > Eval SQL 2005 using the open license we purchase.
> >
> > thanks
> > TomW
>
>
>

try this...

SELECT
CAST( SERVERPROPERTY('productversion') AS varchar(15)) AS productversion,
CAST( SERVERPROPERTY ('productlevel') AS varchar(15)) AS productlevel,
CAST( SERVERPROPERTY ('edition') AS varchar(20)) AS edition,
CAST( SERVERPROPERTY ('licensetype') AS varchar(15)) AS licensetype,
CAST( SERVERPROPERTY ('numlicenses') AS varchar(15)) AS Numlicenses


--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"twilliams" <twilliams@discussions.microsoft.com> wrote in message
news:2DABAA9E-DEC3-41D3-BE9B-D1249E326FEC@microsoft.com...
> Thanks Warren. The eval has not expired yet however, we purchased an SQL
> 2005 standard edition. When I downloaded the trial version originally, I
> can
> not recall it giving me a choice of which trial version to download
> (Standard
> or Enterprise). How can one confirm which trial version they are are
> running.
>
> Thanks
> TomW
>
> "Warren Brunk" wrote:
>
>> Short Answer: If it isnt expired then you can just run an update. If it
>> has
>> expired you will have to uninstall then reinstall.
>> http://support.microsoft.com/kb/914158
>>
>> http://www.microsoft.com/sql/downloa...uirements.mspx
>>
>> Upgrading and Uninstalling the Trial Software
>> The 180-day trial version of SQL Server 2005 Enterprise Edition can be
>> upgraded to the fully licensed version of SQL Server 2005 Enterprise
>> Edition
>> without uninstalling the trial software prior to the end of the 180-day
>> period. If upgrading to the fully licensed version of SQL Server 2005
>> Standard Edition, Workgroup Edition, or Developer Edition, it is
>> recommended
>> that you uninstall the 180-day trial version of SQL Server 2005
>> Enterprise
>> Edition before installing the fully licensed version of the other
>> editions.
>> Please refer to the product documentation for information about upgrading
>> to
>> the fully licensed software.
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>>
>> "twilliams" <twilliams@discussions.microsoft.com> wrote in message
>> news:09BDBD49-7C4F-46AD-851E-7085F36A6450@microsoft.com...
>> >I downloaded an 180 day eval copy of SQL server 2005 and we wish to
>> >utilize
>> > it. However, we purchase an Open License. Is there a wey we can
>> > upgrade
>> > the
>> > Eval SQL 2005 using the open license we purchase.
>> >
>> > thanks
>> > TomW
>>
>>
>>

Try:

SELECT serverproperty('licensetype')


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"twilliams" <twilliams@discussions.microsoft.com> wrote in message
news:2DABAA9E-DEC3-41D3-BE9B-D1249E326FEC@microsoft.com...
> Thanks Warren. The eval has not expired yet however, we purchased an SQL
> 2005 standard edition. When I downloaded the trial version originally, I
> can
> not recall it giving me a choice of which trial version to download
> (Standard
> or Enterprise). How can one confirm which trial version they are are
> running.
>
> Thanks
> TomW
>
> "Warren Brunk" wrote:
>
>> Short Answer: If it isnt expired then you can just run an update. If it
>> has
>> expired you will have to uninstall then reinstall.
>> http://support.microsoft.com/kb/914158
>>
>> http://www.microsoft.com/sql/downloa...uirements.mspx
>>
>> Upgrading and Uninstalling the Trial Software
>> The 180-day trial version of SQL Server 2005 Enterprise Edition can be
>> upgraded to the fully licensed version of SQL Server 2005 Enterprise
>> Edition
>> without uninstalling the trial software prior to the end of the 180-day
>> period. If upgrading to the fully licensed version of SQL Server 2005
>> Standard Edition, Workgroup Edition, or Developer Edition, it is
>> recommended
>> that you uninstall the 180-day trial version of SQL Server 2005
>> Enterprise
>> Edition before installing the fully licensed version of the other
>> editions.
>> Please refer to the product documentation for information about upgrading
>> to
>> the fully licensed software.
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>>
>> "twilliams" <twilliams@discussions.microsoft.com> wrote in message
>> news:09BDBD49-7C4F-46AD-851E-7085F36A6450@microsoft.com...
>> >I downloaded an 180 day eval copy of SQL server 2005 and we wish to
>> >utilize
>> > it. However, we purchase an Open License. Is there a wey we can
>> > upgrade
>> > the
>> > Eval SQL 2005 using the open license we purchase.
>> >
>> > thanks
>> > TomW
>>
>>
>>

The evaluation and developers editions both support the same
features of Enterprise.
So it's basically Enterprise Edition.

-Sue

On Mon, 11 Sep 2006 16:19:02 -0700, twilliams
<twilliams@discussions.microsoft.com> wrote:

>Thanks Warren. The eval has not expired yet however, we purchased an SQL
>2005 standard edition. When I downloaded the trial version originally, I can
>not recall it giving me a choice of which trial version to download (Standard
>or Enterprise). How can one confirm which trial version they are are running.
>
>Thanks
>TomW
>
>"Warren Brunk" wrote:
>
>> Short Answer: If it isnt expired then you can just run an update. If it has
>> expired you will have to uninstall then reinstall.
>> http://support.microsoft.com/kb/914158
>>
>> http://www.microsoft.com/sql/downloa...uirements.mspx
>>
>> Upgrading and Uninstalling the Trial Software
>> The 180-day trial version of SQL Server 2005 Enterprise Edition can be
>> upgraded to the fully licensed version of SQL Server 2005 Enterprise Edition
>> without uninstalling the trial software prior to the end of the 180-day
>> period. If upgrading to the fully licensed version of SQL Server 2005
>> Standard Edition, Workgroup Edition, or Developer Edition, it is recommended
>> that you uninstall the 180-day trial version of SQL Server 2005 Enterprise
>> Edition before installing the fully licensed version of the other editions.
>> Please refer to the product documentation for information about upgrading to
>> the fully licensed software.
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>>
>> "twilliams" <twilliams@discussions.microsoft.com> wrote in message
>> news:09BDBD49-7C4F-46AD-851E-7085F36A6450@microsoft.com...
>> >I downloaded an 180 day eval copy of SQL server 2005 and we wish to utilize
>> > it. However, we purchase an Open License. Is there a wey we can upgrade
>> > the
>> > Eval SQL 2005 using the open license we purchase.
>> >
>> > thanks
>> > TomW
>>
>>
>>