'SQLCMD - ERROR: "Shared Memory Provider: No process is on the other end of the pipe."

I am trying to run a script via sqlcmd. I am using window authentication.

enter image description here

I tried the following:

  1. Open the SQL Server Configuration Manager on the SQL Server.
  2. Expand SQL Server Network Configuration > Protocols for [Instance name]
  3. Makes sure that Shared Memory, Named Pipes, and TCP/IP are enabled.
  4. If any of the above was disabled, enable them.
  5. Restart SQL Server Services to apply the changes.

I also tried to ensure that SQL Server security is set to both Windows and SQL Authentication. I am not sure what else to try. I am sure that the Windows user has permission for the database I am using.

I also tried creating a SQL User and set the Server security properties to 'Windows Authentication + SQL Authentication

Any suggestions?

sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions