August 14, 2012 at 3:54 am
Hi.
I m new to configure SQL 2005 in clustering mode..
Can any one point me out what to configure and how to configure for following scenario ...
1. An application (non-cluster aware), having following : Crystal Report 2008, Some DLL files, MSDTC, etc and SQL 2005 Server to run.. (It works in server/client environment),
2. Windows 2003 may be clustered, SQL 2005 also, but other components may be installed at both the clustered machines.
I know how to configure Windows Cluster
I little bit know how to configure SQL 2005 cluster
Q. 1.
====
Let me know how and what to configure for stable SQL 2005 cluster in clustering (mean services etc to be configured in win 2003 cluster).
Q. 2
===
How to configure database for remote clients connectivity ...
I tried to connect my virtual sever / SQL instance (SQL2K5VS\SQL2K5INS1) but error : no server found or access denied received..
Q. 3
===
Which IP to be accessed for clustered database (SQL 2005 server) ...
Naming Convention is like :
Domain Name : abc.net
Router : 192.168.1.1,
DC Server : 192.168.1.50,
Node1 : 192.168.1.11,
Node2 : 192.168.1.22,
Win Cluster Name : TCLUST (192.168.1.100)
MSDTC : 192.168.1.103
SQL Server Virtual Server Name (configured during installation of SQL 2005 ) : SQL2K5VS
SQL Server Instance : SQL2K5INS1 (192.168.1.101)
Please help ...........
Thanx
August 14, 2012 at 9:41 am
ufcheema (8/14/2012)
Q. 1.====
Let me know how and what to configure for stable SQL 2005 cluster in clustering (mean services etc to be configured in win 2003 cluster).
The installer configures all the clustered resources for you, you don't need to do anything here
ufcheema (8/14/2012)
Q. 2===
How to configure database for remote clients connectivity ...
I tried to connect my virtual sever / SQL instance (SQL2K5VS\SQL2K5INS1) but error : no server found or access denied received..
Have you enabled remote connections?
Have you enabled TCP?
ufcheema (8/14/2012)
Q. 3===
Which IP to be accessed for clustered database (SQL 2005 server) ...
Then clustered instance is accessed by the virtual server name and the instance name for a named instance or just the virtual server name for a default instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply