Home sql Error while authorizing SQL Server

Error while authorizing SQL Server

Author

Date

Category

What could be the problem?
Error text:

The connection to the server was successfully established, but then an error occurred while logging in. (provider: Shared Memory Provider, error: 0 – There are no processes at both ends of the channel.) (.Net SqlClient Data Provider)

I’m using SQL Server Management Studio 2014.
I enter the password correctly.


Answer 1, authority 100%

In the SQL Server settings under Network Connections there is a Named Pipes service, you need to enable it


Answer 2

There was a similar problem, it was solved by including in the server properties, on the security tabs, SQL Server authentication


Answer 3

If, however, the Application Event Log is Error 1032 for SQL Server:

sqlservr (xxxxx) Error -1032 (0xfffffbf8) when opening log file C: \ Windows \ system32 \ LogFiles \ Sum \ Api.log.

or

sqlservr (xxxxx) Failed to open file “C: \ Windows \ system32 \ LogFiles \ Sum \ Api.log” read-only, system error 5 (0x00000005): “Access is denied.” File open operation will fail, error: -1032 (0xfffffbf8).

Then you need to give access rights to the C: \ Windows \ system32 \ LogFiles \ Sum \ folder to the user under which SQL Server is running.

Details: https://support.microsoft.com/uk-ua/help/2811566/error-1032-messages-in-the-application-log-in-windows-server-2012

Previous articleHow to trim a line?
Next articleWhy use uint32_t?

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions