rohit chauhan
asked on
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
4444-sql-server-error-log.jpg
4448-registry.jpg
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
4444-sql-server-error-log.jpg
4448-registry.jpg
ASKER
Is there any other way around??
SQL services are starting when I disabled the TCP/IP protocol.
SQL services are starting when I disabled the TCP/IP protocol.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I didn't get the replies which resolved my problem, then I resolved the issue myself with the help of Microsoft document.
Now you went to the hardest path and maybe you'll need to reinstall SQL Server to have it fixed.