How do I know if I have Enterprise or Standard on my machine?

I go to help>About and it just says SQL Server 2005

Microsoft SQL Server Management Studio Version 9.00.1399.00

You can use osql at the command prompt like this:

osql -S yourServerName -E -q "select CAST(SERVERPROPERTY('edition') AS VARCHAR)

|||

The problem I'm having is that I'm unable to establish and instance of a server so I don't know or have a server name.

This is one of the reasons why I want to know the edition I have. As I understand it, Enterprise edition does not support XP Pro OS, which is what I'm running. If I have enterprise then I figure I might as well give up on trying to get this solved. If I have standard, then I won't give up so easily.

|||If you can get to the SQL Server Configuration Manager, select SQL Server 2005 Services in the left pane, then right click on the SQL Server process and select properties, go to Advanced tab and look at the entry "Stock Keeping Unit Name".|||

I can get to the SQL Configuration Manager, however when I right click on SQL Server 2005 Services "SQL Server process" is not shown.

Also, seems like I don't have SQL Server Browser Service installed. The file sqlbrowser.exe is not in my 90\Shared folder.

Any ideas?

Thanks

|||

An easy way is to go to the registry and look for this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\Edition

Note: You'll have this key for each component installed, so you'll find them here as well:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup\Edition

Thanks,
Sam Lester (MSFT)

|||

Ok got it..

I have standard edition...So that rules out OS incompatibility theory I was under the assumption that I working under.

So back to my main problem.

I'm unable to establish a local server instance on my machine.

I have established remote server instances, but not local..

Any ideas?

Thanks

How do I get SQL Server 2000 Personal Edition

Does SQL Server 2000 Personal Edition install from the SQL Server 2000
Standard CD? I see on the Microsoft website that licensing SQL Server 2000
Standard entitles users to SQL Server 2000 Personal but I don't see an
option for installing Personal. Is it a separate CD?David,
I don't have the CD here to confirm. However, I believe it's on the CD under
Personal/MSDE folder.
--
-oj
http://www.rac4sql.net
"David Morrison" <me@.nospam.com> wrote in message
news:unXLtoG5DHA.1948@.TK2MSFTNGP12.phx.gbl...
> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server
2000
> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>|||it came on a separate CD purchased in 2001, don't know how it is now.
"David Morrison" <me@.nospam.com> wrote in message
news:unXLtoG5DHA.1948@.TK2MSFTNGP12.phx.gbl...
> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server
2000
> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>

How do I find what version of SQL Server is installed?

Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
Venki
Sorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||use master
select @.@.version
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:

How do I find what version of SQL Server is installed?

Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>> Hello:
>> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
>> editions.
>> Can you tell me how I can determine which flavor is installed?
>> I thought I had Standard Edition but when I tried to install Standard
>> Edition of the Reporting services, it said that it was a wrong type.
>> Thanks.
>> Venki

How do I find what version of SQL Server is installed?

Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>