SQL Fixes - Login Error No process is on the other end of the pipe

Опубликовано: 02 Ноябрь 2018
на канале: BeardedDev

44,454

476

Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.

You can now support me on patreon - / beardeddev

T-SQL Querying
https://www.amazon.com/gp/product/073...

T-SQL Fundamentals
https://www.amazon.com/gp/product/150...

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
https://www.amazon.com/gp/product/073...

In this video we take a look at a login error when trying to connect to SQL Server Management Studio (SSMS) - No process is on the other end of the pipe. I have seen recommendations on forums that when you see this error SQL Server must be reinstalled but that is a last resort.

No process is on the other end of the pipe is not very descriptive and it means that we are unable to access SQL Server using SQL Server Authentication. In this video we talk about how we can resolve this issue.

We login as sysadmin and look at the properties of the server under the security page, we notice that the server is set up for Windows Authentication even though we have the option of selecting SQL Server Authentication when connecting. We change this setting and restart the services and have resolved the problem.

It is worth mentioning that I believe that the authentication method is set to Windows Authentication when installing SQL Server so be careful if you will be setting up SQL Server users.

Let me know if this resolved the issue.