How to bring MSSQL server online.

SQL 2008 R2: HRESULT: 0×80071736 SQL Server could not be brought online

Connect to SQL server (2005, 2008, 2008R2) Instance

Check In to particular server, check for properties.

Select cluster (Domain Instance), give all permission.

1.       Make sure that you know the name of the cluster and the name that the clustered service or application will have.

2.       On a domain controller, click Start, click Administrative Tools, and then click Active Directory Users and Computers. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.

3.       In the console tree, right-click Computers or the default container in which computer accounts are created in your domain. Computers are located in Active Directory Users and Computers/domain node/Computers.

4.       Click New and then click Computer.

5.       Type the name that you will use for the clustered service or application, and then click OK.

6.       On the View menu, make sure that Advanced Features is selected.

When Advanced Features is selected, you can see the Security tab in the properties of accounts (objects) in Active Directory Users and Computers.

7.       Right-click the computer account you just created, and then click Properties.

8.       On the Security tab, click Add.

9.       Click Object Types and make sure that Computers is selected, and then click OK. Then, under Enter the object name to select, type the cluster name account, and then click OK. If a message appears, saying that you are about to add a disabled object, click OK.

10.   Make sure that the cluster name account is selected, and then, next to Full Control, select the Allow check box.

  

Please find the below Screen shots.