Configuring SQL 2005 Clustered Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Configuring SQL 2005 Clustered Database

Author

Topic

ufc
Starting Member

5 Posts

Posted - 2012-08-08 : 16:33:52

HI, to ALL.
===========

Q. 1
====

I M totally new in this field,, basically I M a network Administrator.

But due to some special activities I have been tasked to complete following project and run it for users. PLEASE HELP

One application having different (Non-Clustering awared) components is running in my environment :-

Server End : Crystal Reports, some local made software(s), MSDTC Components Special configuration, SQL 2005 Server and a database on separate server (DAS)..

Client End : A software / components to access data..

I have been tasked to cluster my servers for smooth operation and high availability...

I Have done till now : 2 Windows 2003 servers, with SP1, clustered (windows based and SQL 2005 in cluster mode at both serves with full configurations as it runs in non-cluster mode..

Now when I try to connect my application either from server (through my Admin module), or from an-other client, it gives errors like :

Error 1
=======
LoadCON 5 A network-related or instance-specific error occurred while estblishing connection to SQL Server.
The server was not found or was not accessible. Verify that the instance is correct and that SQL Server is configured
to allwo remote connectino. (Provider: Named Pipes provider, error: 40-Could not open a connection to SQL Server).

Error 2
======================
SYSTEM ERROR-CONTACT ADMINISTRATOR-ERROR 5 A network-related r instance-specific error occurred while establishing a connection
to SQL Server. The server was not ound or was ot accessible. Verify that the instance name is correct and that SQL Server is configured
to allow remote connections. (Provider: Named Pipes provider, error: 40-Could not open a connection to SQL Server).

Naming Convention is like :

Domain Name : abc.net
Windows Base cluster Name : TCLSUT
SQL Server Virtual Server Name(configured during installation of SQL 2005 ) : SQL2K5VS
SQL Server Instance : SQL2K5INS1

Q. 2
====
I don't now how to configure naming convention in SQL Server tables : AServer, DServer, Ref_table .... etc.. (which virtual server, instance name or cluster name is to be configured where),

Please help me to configure database for accessing data, smooth operation and how to configure database for accessing.

THANKS............ WAITING FOR URGENT REPLY IF POSSIBLE

chadmat
The Chadinator

1974 Posts

Posted - 2012-08-08 : 16:46:08

Why are you building a new cluster on unsupported OS build? At least install SP2.

What are you connecting to? If you set it up properly, it should be: SQL2K5VS\SQL2K5INS1

Can you connect locally?

-Chad

ufc
Starting Member

5 Posts

Posted - 2012-08-09 : 11:35:22

quote:
Originally posted by chadmat

Why are you building a new cluster on unsupported OS build? At least install SP2.

1. SP2 is already installed for Win 2003 servers.

quote:
What are you connecting to? If you set it up properly, it should be: SQL2K5VS\SQL2K5INS1

Can you connect locally?

2. I can successfully connect with "SQL2K5VS\SQL2K5INS1" or "TCLUST" through ODBC Driver Connection but when I run application it gives above mentioned error ...

chadmat
The Chadinator

1974 Posts

Posted - 2012-08-09 : 12:00:10

Try Surface Area Configuration and enable remote connections.

-Chad

ufc
Starting Member

5 Posts

Posted - 2012-08-09 : 12:35:26

quote:
Originally posted by chadmat

Try Surface Area Configuration and enable remote connections.

-Chad

May I get some tips/hints for configuration of same..........

chadmat
The Chadinator

1974 Posts

Posted - 2012-08-09 : 12:52:21

I don't have 2005 installed, and it has been a while since I have been in Surface Area Config, but if I remember correctly, it is just a checkbox, it should be pretty self explanitory.

-Chad

ufc
Starting Member

5 Posts

Posted - 2012-08-09 : 13:15:06

OOOOOOOOOOOOOOOOOOOOOOOOppppppppppppppppppsssssssssssssssssssssss .... .... It mean I have to wait for someone else to help me ahead,,,

So thanks for your help ... I will try me best to configure through your given tips ... Let see if successfull or not ....

VERY VERY VERY VERY THAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANX

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources