Groups | Blog | Home
all groups > sql server clustering > november 2005 >

sql server clustering : x64 2003 Cluster - SQL2000 named instance fail


maxxmobile
11/24/2005 3:53:02 AM
Hi!

We would like to install a named instance on a Windows Server 2003 Cluster.
The named pipes settings are set correct but during the installation the
instance name fail -> "Bring Online" process -> rollback installation.

The same setup procedere on a Windows Server 20003 x86 run without errors.
Is there something difference to do on x64 - the default instance will work.

Any help would be fine.

uttamkp NO[at]SPAM online.microsoft.com
12/1/2005 12:35:00 AM
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

Josh Martins
12/4/2005 7:24:44 PM
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?

[quoted text, click to view]

Josh Martins
12/5/2005 2:48:18 PM
Make sure that you are running the correct CliConfig.exe, do a search for
it. You need to run it from the WOW directory, if you run the normal 32-bit
one the settings are not detected by the setup.

[quoted text, click to view]

AddThis Social Bookmark Button