SQL Server or MSDE?

UDDI Services is implemented either as an MDSE or SQL Server 2000 database. Which database you use depends on how many simultaneous users you plan to support.

Sue Mosher

March 29, 2004

1 Min Read
ITPro Today logo in a gray background | ITPro Today

In distributed installations, you can use only Microsoft SQL Server 2000 as the database. When you're performing a standalone installation, the deciding factor for whether to use SQL Server or Microsoft SQL Server 2000 Desktop Engine (MSDE) is knowing how many simultaneous users you plan to support. MSDE's managed concurrency workload governor lets it support only five concurrent workloads at typical speed; all subsequent connections run at a significantly degraded speed. Therefore, I recommend using SQL Server 2000 for the Universal Description, Discovery, and Integration (UDDI) database. SQL Server 2000 must already be installed on the same machine as UDDI Services, or you must be able to point to an existing instance of SQL Server 2000 on another machine before you can install UDDI Services.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like