I have a sql server 2005 64 bit 2 node cluster. I tried to move master following actually a page that you reference and all works until I attempt to move the resource database. I stop sql server service from configuration manager and then run:
D:\>NET START MSSQLSERVER /f /T3608
The SQL Server (MSSQLSERVER) service is starting.
The SQL Server (MSSQLSERVER) service was started successfully.
Next I try to log in using sqlcmd I get this:
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.
Now I have done used the instructions on moving sql server user and system databases on a non-clustered environment to test without this issue. I am thinking that I need to start sql server in a cluster differently but how do I get these recommended flags as part of the service startup? Using net start seems to have an issue when in a cluster.