Re: MSDTC Troubles, Do I Even Need It?

FYI, Security patch MS03-031 brings SQL up to build 818.

Also, you may have to run the setup program twice, depending on how you
removed the old node. If you only evicted the node from the cluster and did
not run the SQL setup, you will have to re-run the setup to remove the old
node from the SQL configuration information. Once the old node information
is gone from both SQL and the cluster configuration, you can follow the
steps Uttam described.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"Uttam Parui[MS]" <uttamkp@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:D1xb0yf9FHA.4028@xxxxxxxxxxxxxxxxxxxxxxxx
> If your old node had MS03-031, you will need to run MS03-031 setup on the
> old node and setup will automatically install MS03-031 on new node.
>
> If your node did not have MS03-031 (critical security patch for SQL Server
> 2000) then it is highly recommended that all SQL Server 2000 whether it is
> clustered or standalone have MS03-031 installed. This requires
> SP3/3a to be installed first).
>
> Best Regards,
>
> Uttam Parui
> Microsoft Corporation
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
>
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>


.

Relevant Pages

  • Re: Unable to reinstall SBS Monitoring
    ... Uninstall Windows SBS 2003 R2 components". ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Developer Edtn 2005 - WMI Error during installation - Error:2147500034 (0x800
    ... Here is some information from the Log files that are created from the SQL ... Server setup (C:\Program Files\Microsoft SQL Server\90\Setup ... Condition "Setup is running locally." ... Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp ...
    (microsoft.public.sqlserver.setup)
  • RE: migrating from wmsde to sql server
    ... but should I not be able to see a compnayweb instance in SQL ... I understand that the SQL Server 2000 Setup Control ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • SQL Server 2005 CTP Installation
    ... nachdem ich mich vor einer Weile schon einmal mit der Installation der SQL ... Refer to server error logs and setup logs for more information. ...
    (microsoft.public.de.sqlserver)
  • Re: SQL 2000 Problems on One Node Only
    ... Since it is a setup error, there will be a setup log file in the windows ... Installation of a named instance of SQL Server 2000 virtual server on a ... Windows 2003-based cluster fails ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)