How to verify SQL edition once evaluation is expired

Hi,
SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
service can't start. The problem is I could not use "osql -E" to get into
command prompt due the service. Therefore, I could not implement SELECT
SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny Chow
Johnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
> service can't start. The problem is I could not use "osql -E" to get into
> command prompt due the service. Therefore, I could not implement SELECT
> SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
> Thank you in advance,
> Johnny Chow
>
|||Hi,
I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
current version= 8.00.194 but when search this version number on google.com
.. Some of sites said SQL 2000 server without patch and other said it is
MSDE version. How do I tell if it is MSDE or SQL server? Please correct if
am wrong, I thought MSDE never expired. I know some people will install
MSDE and SQL agent. Well this is well be hard to make distinquish version.
Any tips and information will be appreciated.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Johnny,
> Look through the following registry keys (regedt32)- might provide this
> information:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>
|||Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/default...b;en-us;321185
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
> current version= 8.00.194 but when search this version number on
> google.com . Some of sites said SQL 2000 server without patch and other
> said it is MSDE version. How do I tell if it is MSDE or SQL server?
> Please correct if am wrong, I thought MSDE never expired. I know some
> people will install MSDE and SQL agent. Well this is well be hard to make
> distinquish version. Any tips and information will be appreciated.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>
|||Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products/...8014f8e8.shtml .
I also built another sql evaluation test machine; I was able to upgrade
retail version successfully; but another machine, if I said cancel before
start to upgrade then it will gray out "upgrading your existing
installation". I believed it was a bug in the program.
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OpbgAoB1FHA.2540@.TK2MSFTNGP09.phx.gbl...
> Johnny,
> Try:
> HOW TO: Identify your SQL Server Service Pack version and edition
> http://support.microsoft.com/default...b;en-us;321185
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
sql