Re: x64 2003 Cluster - SQL2000 named instance fail

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm having the exact same problem. The default instance works fine but the
named instance fails.

This happens on single nodes clusers where the named pipes alias is not even
required, also, even if you do have the alias the problem still occurs.

The following can the found in the event log:

The description for Event ID ( 17052 ) in Source ( MSSQL$InstanceName )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description;
see Help and Support for details. The following information is part of the
event: [sqsrvres] OnlineThread: Error connecting to SQL Server.

If you look at the logs you will see that SQL Server setup is successfull,
in the cluster log you will notice the a connection to the SQL Server named
instance cannot be established.

Any others ideas?

"Uttam Parui[MS]" <uttamkp@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:mGNmT8g9FHA.1236@xxxxxxxxxxxxxxxxxxxxxxxx
> Have looked at the setup files particularly
>
> sqlstp.log
> sqlstpN.log where N is an integer
> sqlclstr.log -- this may have more info if the setup failed when it was
> trying to bring the resource online.
>
>
> 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: Failed on installation of SQL Server SP3a on Failover Cluster
    ... this is interfering with setup. ... For information about the Strategic Technology Protection ... Program and to order your FREE Security Tool Kit, ... Microsoft highly recommends that users with Internet access update their ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 on Win2k3 Unable to Install
    ... When you run the setup, are you stopping any services or programs OR are you doubl-clicking setup.exe and letting it run. ... For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, ... Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MSDTC Troubles, Do I Even Need It?
    ... 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. ... For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, ... Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. ...
    (microsoft.public.sqlserver.clustering)
  • RE: SP3a on new cluster nodes
    ... Open Cluster Admin and make sure that the node where you will be runing the service setup own all the resources in the SQL group. ... For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, ... Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS setup fails
    ... I have performed further research about the intergrated setup wizard ... you run the Setup program for Small Business Server. ... the Sysvol folder is located in the Windows folder. ... companies that are independent of Microsoft. ...
    (microsoft.public.windows.server.sbs)