We have a four node cluster which was in a NT 4.0 domain - only two of them active. Our goal is to make 3 active 1 passive. Recently we migrated to Active Directory on Win 2003. The CLuster nodes are running win 2003 as well.

In the NT 4 domain I was able to run the setup and create named instance without any problem. The same setup does not run anymore in Active Directory Environment. Though everything continued to work fine - I can't install the additional instance on the cluster. I know I have to run the setup on one node first.

Baiscally the setup creates the cluster resourcesm it starts the SQL service but fails to connect to it and then rolls back and cleans up. I get following app logs:
The description for Event ID ( 17052 ) in Source ( MSSQL$OZONEDBI ) 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] checkODBCConnectError: sqlstate = 01000; native error = 274d; message = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).


and another one:

The description for Event ID ( 17052 ) in Source ( MSSQL$OZONEDBI ) 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] ODBC sqldriverconnect failed


Any Ideas? Would greatly appreciate your help...Thanks in advance.
-Mintz.

Have you looked at this:

PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server on a
Windows 2003-Based Cluster Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;815431&Product=sql2k

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

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]
them active. Our goal is to make 3 active 1 passive. Recently we migrated to
Active Directory on Win 2003. The CLuster nodes are running win 2003 as
well.
[quoted text, click to view]
without any problem. The same setup does not run anymore in Active Directory
Environment. Though everything continued to work fine - I can't install the
additional instance on the cluster. I know I have to run the setup on one
node first.
[quoted text, click to view]
service but fails to connect to it and then rolls back and cleans up. I get
following app logs:
[quoted text, click to view]
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] checkODBCConnectError: sqlstate = 01000; native error = 274d;
message = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
[quoted text, click to view]
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] ODBC sqldriverconnect failed
[quoted text, click to view]

Hello Mintz,

Its nice that you cut and paste some of the error messages. This helps in giving some useful suggestion. I believe you are experiencing the issue mentioned in

815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431

The KB explains why the setup fails and has a workaround. Basically, you will need to make named piped alias.

HTH,

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

Thanks very much Uttam - yes you are right. Actually I forgot - I added TCP/IP alias instead of named pipes. SO after the named pipe alias, i am able to create the new instance and virtual server. Greatly apprecaite your response.

Have a great day..!!
-Mintz

[quoted text, click to view]