| Author |
Topic |
|
kdfarber
Starting Member
24 Posts |
 Posted - 2003-11-12 : 10:05:05
|
| We are trying for the first time to install a clustered environment on Windows 2000 Sql Server 2000 Enterprise Edition. We have gone through the install and our two nodes in the cluster defined are attached to a SAN. In the install we set up the data files and program files to go to the SAN. Should we have installed on a local drive ?? We now can not start the services becasue is can't find the drive that we have set. Please help if you can. |
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2003-11-12 : 11:16:35
|
| Kdfarber, befor install sql-server you most configure the Microsoft Cluster with a Virtual Ip address, Virtual Name, and a disk device of your SAN Storage, too you must define a disk resource (small less than a 1Gb) to use like a Quorum disk (here the cluster info is storage)this resourse have to be too on the SAN storage, and testing this configure moving your resourse from node-A to node-B, after this test you can start the SQL install, If you are using Enterprise Version you only have to make tha install on one of your node's.RegardsGerardo G. |
 |
|
|
kdfarber
Starting Member
24 Posts |
Posted - 2003-11-12 : 12:02:01
|
| We configured the cluster the way you described. When we installed Sql we set the Microsoft Sql Server Datafiles to go to the San device but the MSSQL to the D drive (local). When we try to register the name it fails because it can not find the path to the Microsoft Sql Server Data files. Is there something else in the windows cluster admin we need to do ?? When we try to start the services under Sql Server Services we do not see the MSSQLServer or SqlServerAgent as services to start. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-12 : 12:22:26
|
| You do not start SQL Server using services when using clustering. You start them in the cluster administrator by bringing them online.What is the error message that you are getting when registering?In our clustering environment, we setup the data files to go to the SAN drives and the application files to go to the E drive which is a local drive. So a very similar environment.Can the server see the SAN drives in Windows Explorer?Tara |
|
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2003-11-12 : 12:26:19
|
| kdfarber, the installation of SQL is Satisfactory? give you some error?Did you chech your Client Network Utility configuration?you install SQL like a Administrator of the computer or domain? The SAN device must have the same letter on both node's, chech if the services MSSQLSERVER$<Instance name> exist or you use default instance name?I install SQL on cluster But I didn't use the Enterprise version, so I install on NODE-A SQL on C: and my Datafiles on my cluster SAN (called J:\), after I move the resources to NODE-B and Rename the SQL directory on the Cluster device (J:\) and made a new SQL install after that I move resources to node-A and the SQL start up. maybe this will help you. |
|
|
|
kdfarber
Starting Member
24 Posts |
Posted - 2003-11-12 : 13:20:53
|
| The error I get when trying to add the cluster to Enterprise Manager is SqlServer does not exist or access denied. I am loggin in as SA so It's not the access. I can ping the DNS name and it responds. Also I can see the SAN drives but I do not see the folder we created to hold the data files. I don't think we have something configured correctly in the cluster admin. We are working on that now. Any other inforamtion you can give to help in configuring the cluster is much appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-12 : 13:27:25
|
| Did you change the default port? Where are you trying to register the server? On the database server or on a client machine?Tara |
|
|
|
kdfarber
Starting Member
24 Posts |
Posted - 2003-11-12 : 13:34:42
|
| The default port has 1433 as the value. I have tried to register on the database server and also my client machine and recieve the same error. |
|
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2003-11-12 : 13:36:55
|
| Ok, Is weird that the datafiles folder doesn't exists and the installer tell you that it was Succeded.Ok, the Cluster Administrator created you 2 groups after you setup, you most install SQL on the disk assianted to your cluster group witch have the Name, Ip address resources, and before install SQL you most to check If your user have permissions to write on the disk, If you are working on a Terminal server session sometimes you need to logoff and logon to "see" the disk after you moved from node-a to node-b |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-12 : 18:24:13
|
quote:
Originally posted by kdfarber
When we try to start the services under Sql Server Services we do not see the MSSQLServer or SqlServerAgent as services to start.
This part means that SQL Server wasn't successfully installed. Even though you start SQL Server in Cluster Administrator, you should still see the services. This is why you are missing the files on the SAN. If you know that it installed successfully, then could it be that someone uninstalled it or maybe you only installed the Client Tools and not the database server portion.Tara |
|
|
|
|
Help on Installing SqlServer2000 Failover Cluster