How do I: Install the UDDI services database components on a SQL2005 instance.

When installing UDDI services database components onto your SQL2005 instance you may receive this error:

The database instance does not meet the minumum version or service pack level requirements...

The database instance does not meet the minumum version or service pack level requirements...

This issue occurs because the UDDI installation process examines the value of the CSDVersion registry entry for SQL Server. The CSDVersion registry entry is used for SQL Server 2000 service packs. The CSDVersion registry entry is not used for SQL Server 2005. Therefore, this version check fails when you try to install the UDDI Services database components on an instance of SQL Server 2005.

To fix this you can follow the steps outline in this Microsoft Support document http://support.microsoft.com/kb/927230 or cut and paste the following script into a blank text document and save as a batch file.

@echo off
setlocal
if {%1}=={} goto defi
set ni=%1
set ni=%ni:”=%
set key=”HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\%ni%\MSSQLServer\CurrentVersion”
goto getver
:defi
set key=HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
:getver
set cv=0.0
for /f “Tokens=2*” %%a in (‘reg query %key% /V CurrentVersion^|find /i “REG_SZ”‘) do (
set cv=%%b
)
@echo reg add %key% /V CSDVersion /T REG_SZ /F /D “%cv%”
reg add %key% /V CSDVersion /T REG_SZ /F /D “%cv%”
@echo After installing the UDDI Services database components, run the following command:
@echo reg delete %key% /V CSDVersion /F
endlocal

After running this batch file re-attempt your UDDI services installation and you will be able to install your UDDI services database components to your SQL2005 instance.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: