• Hi Todd and p.van.rixel,

    I am trying to move msdb and model datafiles to different locations on my sql server 2005(sp3) cluster per KB224071(sounds like what you were trying to do) and am having problems.

    This is what I am doing:

    1)pause the failover node

    2)change the startup parameters for the instance to use -m -c -T3608

    3)bring the sql server cluster group offline (to make the startup parameters take effect)

    4)bring the sql server cluster group online. all services start except for the sql server agent (this is by design i assume)

    5)then i try to connect to the instance from sql server management studio from a remote machine and get the "login faile for user 'sa'. Reason: server is in gingle user mode. Only one administrator can connect at this time. (Microsoft SQL Server, Error: 18461)" error message.

    It seems that this should work based on the info that you posted. Can you review the steps that I took above and let me know what I am doing wrong?

    I appreciate it!

    Thanks,

    John