SQL Server Error Log error: 17120, 17826,17182,26054

Hello All,

In our SQL server environment we have SQL Server 2008 R2 Enterprise edition installed in Windows Server 2008 R2 SP1 clustered environment. One of our vendor accidentally deleted the virtual server name of SQL server from cluster.

Now being a server admin and database admin i have to resolve this. I had to delete the Application and service and again add new "Other Server" instance from the same name as the previous virtual server name in the cluster.

I also added the SQL server and SQL server agent services to that services and application instance.

But when I am starting the SQL services I am getting errors 17120, 17826, 17182 and 26054 and error message in a popup "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for detail.

I have googled it and so many replies for each type of error but nothing worked. I also checked the registry settings and it looked fine to me.
I am attaching the snapshots of the errors and registry settings. Please help! SQL server is running on domain account and the user is domain admin.alt text
rohit chauhanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Why didn't you just recreate the virtual server name?
Now you went to the hardest path and maybe you'll need to reinstall SQL Server to have it fixed.
rohit chauhanAuthor Commented:
Is there any other way around??
SQL services are starting when I disabled the TCP/IP protocol.
rohit chauhanAuthor Commented:
The problem is resolved, thanks to the Microsoft document https://support.microsoft.com/en-in/help/883732/a-sql-server-cluster-resource-goes-to-a-failed-state-when-you-try-to-b
After deleting and recreating the Application and services group from the failover cluter, adding SQL server service to the other resource was a pain. Instance Name and Virtual server name was missing from the registry HKEY_LOCAL_MACHINE\Cluster\Resources\<GUID>\Parameters.
After assigning the registry and restarting server my SQL server services are now starting fine.
Thanks for your reply.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rohit chauhanAuthor Commented:
I didn't get the replies which resolved my problem, then I resolved the issue myself with the help of Microsoft document.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.