I saw this article thinking that it would help or have a hint on how to get my situation to work. I commented here, because this script would not work for me if I used it. I understand what needs to take place with the resource database for 2005. Whether or not Vince's script works was never my question.
I again have gotten the web page to work which this script is based on if you look at it! Now, if you look at the document on web page:
ALL, steps work for ALL databases, at least for me, when you are performing this on a NON-clustered Sql Server 2005 server. The web page nor this chain never mention any difference for whether or not this can be performed on a cluster.
Now, for me, this step fails when performed on a Sql Server 2005 64-bit Enterprise Edition SP3 Cluster:
7.) Start the instance of SQL Server in master-only recovery mode by entering one of the following commands at the command prompt. The parameters specified in these commands are case sensitive. The commands fail when the parameters are not specified as shown.
* For the default (MSSQLSERVER) instance, run the following command.
NET START MSSQLSERVER /f /T3608
8.) Using sqlcmd commands or SQL Server Management Studio, run the following statements. Change the FILENAME path to match the new location of the master data file. Do not change the name of the database or the file names.
I use this statement for step 8:
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server .
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I have started a chain in the administration forum. I post it as a question more than a comment. If you have a solution to how to get this to work on a cluster, then please comment there. To this point no one has commented to that post.