After Upgrade from SQLEXPRESS to STANDARD still denies CREATE ENPO   

Hi,

I have uninstalled Management Studio Express and upgraded SQLEXPRESS to 
STANDARD edititon with setup (forgot the name of the switch)=1 successfully.

But when I EXECUTE sp_reserve_http_namespace
I got "sp_reserve_http_namespace" is not supported on this edition of SQL 
Server.

What can I do to check the edition and to enable the web services feature?

Thanks for any hints,
Paul

date: Mon, 21 Jul 2008 03:25:02 -0700   author:   PaulBiz

Re: After Upgrade from SQLEXPRESS to STANDARD still denies CREATE ENPO   

Hello Paul,

SQL Server 2005 Standard Edition supports HTTP Endpoints. However your 
upgrade could be failed somehow. Because you'd get this error when you use 
Express or Workgroup Editions of SQL Server 2005.

Connect to your SQL Server instance and then run the following command to 
see the version information of your SQL Server instance.

SELECT @@Version

You can use the Query Editor in SQL Server Management Studio or SQLCMD which 
is a command prompt tool that comes with SQL Server 2005.

-- 
Ekrem Önsoy




"PaulBiz"  wrote in message 
news:3C69EA60-1B5A-465D-B428-5F6F3C439B69@microsoft.com...
> Hi,
>
> I have uninstalled Management Studio Express and upgraded SQLEXPRESS to
> STANDARD edititon with setup (forgot the name of the switch)=1 
> successfully.
>
> But when I EXECUTE sp_reserve_http_namespace
> I got "sp_reserve_http_namespace" is not supported on this edition of SQL
> Server.
>
> What can I do to check the edition and to enable the web services feature?
>
> Thanks for any hints,
> Paul

date: Mon, 21 Jul 2008 13:40:31 +0300   author:   Ekrem Önsoy