x

SQL Server 2005 cluster group not coming online

We are having 2 node (active-passive) SQL server 2005 cluster with SP2. From last some days we are facing issue that SQL server cluster group not coming online on passive node(sql server services & agent remain in stop state even after several retries.). All other resources other then SQL server are coming online sucessfully.

We are getting below error messages : -

1) SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: xx.xx.xx.xx]

2) The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15.

3) [sqsrvres] checkODBCConnectError: sqlstate = 08S01; native error = e9; message = [Microsoft][SQL Native Client]Named Pipes Provider: No process is on the other end of the pipe.

4) [sqsrvres] ODBC sqldriverconnect failed

5) [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 0; message = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

6) [sqsrvres] checkODBCConnectError: sqlstate = 08S01; native error = e9; message = [Microsoft][SQL Native Client]Communication link failure

7) EXCEPTION: Error 6144854: T8240 C6144854 The following SQL Server error or errors occurred: 18452,"28000",[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxxx'. The user is not associated with a trusted SQL Server connection.

Findings & Actions taken:-

1) Registry entries are already updated 2) Browser services are activated & started 3) upgarde SP3 on both nodes but issue not resolved 4) Window sevrer hardning done

more ▼

asked Apr 04, 2010 at 05:53 AM in Default

Rohit Garg gravatar image

Rohit Garg
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Your error 2 (0x2098) is that the SQL Server doesn't have sufficient rights to register the named pipe. The errors 3 and 6 are results of error 2.

I believe you need to assign the 'read service' and 'write service' rights to the domain account under which SQL Server is running in Active Directory. For more information, see Step 3 on this page.

more ▼

answered Apr 04, 2010 at 09:17 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

(comments are locked)
10|1200 characters needed characters left

I dont have any experience of clusters but this looks like a security issue. What machine is the IP that you have XX'd out in step 1? Is it using an account that doesnt have permission to connect? What does the error log contain? I would try to investigate the security issues mentioned in 1) and 7) combined.

more ▼

answered Apr 04, 2010 at 06:46 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x93

asked: Apr 04, 2010 at 05:53 AM

Seen: 29830 times

Last Updated: Apr 05, 2010 at 10:00 AM