Database Connection SQL Server 2012

Posted on

Question :

My payroll application developed in ASP.net and C language not able to connect the database. Our Payroll is broadcast through IIS, after we change our router i can’t access this TimeCardUploader.
How can I Reconnect my Database?

enter image description here

Every time I re-start the application I see this error.

A Connection was successfully established with the server,.
but then an error occurred during the login process.
(provider: Shared Memory Provider, error:0-No process is on the other end of the pipe

And our biometric server is stopped.

Thank you.

Best Regard.

Answer :

First check if SQL Server is up and running on the database server.

If yes, then check if Shared memory/TCP-IP/Named pipes protocol is enabled on SQL Server. You can check that in SQL Server configuration manager. If it is not, then you have to enable it and then restart SQL Server service.

Also if you are using SQL login to connect to database, then you have to check if mixed mode authentication is enabled on SQL Server. To check that connect to SQL Server and right click on instance and go to properties -> security tab -> check if mixed mode authentication is enabled or not. This will again require SQL Server service restart to get the change reflected.

Check these 3 things first and let me know if it does not resolve your problem.

Please mark this solution as Solution, if it resolves your issue.

Leave a Reply

Your email address will not be published.