Hi,

I have PMP in our environment and am trying to determine the best way to configure MS SQL Resources.  Currently I have some Windows 2003 servers with MS SQL installed and at the moment the resource is listed as a Windows resource with a local admin account defined as one of the user accounts within the resource.  However I would like to enter in database accounts within this resource and potentionally configure the ability to perform a remote password reset.  Do I change the resource type as a MS SQL resource and configure the remote password reset for both the Windows and MS SQL?  Do I create 2 resources 1 as Windows Server and 1 for MS SQL?  What is the recommended way that this is configured?

Any guidence you could provide would be great.

Thanks