Thursday, January 12, 2012

tcp provider error 0 no connection could be made because the target machine actively refused it miscosoft sql server, error: 10061 MS CRM 2011

some error has come while using MS CRM.
It was due to the SQL server not getting connected and it was not listeing from out side the server as well as from the same server.
the error was as "tcp provider error 0 no connection could be made because the target machine actively refused it miscosoft sql server, error: 10061"

I have checked the TCP and the pipeline are enabled and the services were running except the SQL Server(MSSQLSERVER) service.
when ever i was starting the service and refreshing the service was getting stopped again and again.
so only it was not working.

i have just added ;-T902 at the "Startup Parameters" of the properties of the "SQL Server" in advance tab as in the image.
then restaretd the services, then it has come upp....

thanks,
yes.sudhanshu

No comments:

Post a Comment