|
Home > Archive > MS SQL Server > October 2005 > How to verify SQL edition once evaluation is expired
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to verify SQL edition once evaluation is expired
|
|
| Johnny Chow 2005-10-20, 8:23 pm |
| 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('EDIT
ION'), SERVERPROPERTY('ENGI
NEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny Chow
| |
| Jerry Spivey 2005-10-20, 8:23 pm |
| Johnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\Mi
crosoft SQL Server
HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\MS
SQLServer
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('EDIT
ION'), SERVERPROPERTY('ENGI
NEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
>
> Thank you in advance,
>
> Johnny Chow
>
| |
| Johnny Chow 2005-10-20, 8:23 pm |
| Hi,
I went to HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\MS
SQLServer, 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\S
OFTWARE\Microsoft\Mi
crosoft SQL Server
> HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\MS
SQLServer
>
> HTH
>
> Jerry
> "Johnny Chow" <jchow10@gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Jerry Spivey 2005-10-20, 8:23 pm |
| Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/defaul...kb;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\S
OFTWARE\Microsoft\MS
SQLServer, 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 Chow 2005-10-20, 8:23 pm |
| Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products...08014f8e8.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/defaul...kb;en-us;321185
>
> HTH
>
> Jerry
> "Johnny Chow" <jchow10@gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@TK2MSFTNGP14.phx.gbl...
>
>
|
|
|
|
|