question

Rahulshilps-9102 avatar image
0 Votes"
Rahulshilps-9102 asked Criszhan-msft edited

New Login crated. Failing to Log in.

I wanted to create a new Login and a new user. I successfully made a new Login by query -

create login samplelogin with password='Login@123'

I can see the Login is created in Server -> Security -> Logins

But, When I actually try to login with another interface. I saw the following message -


TITLE: Connect to Server



Cannot connect to ADMINRG-R9LIQGS.


ADDITIONAL INFORMATION:

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.) (Microsoft SQL Server, Error: 233)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-233-database-engine-error



No process is on the other end of the pipe


BUTTONS:

OK





sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

In which Authentication mode is the SQL Server running; in mixed mode or Windows only, the last one is the default?
If the SQL Server is running in "Windows only", then you can create SQL logins, but can't use it to log on.

You have to change to mixed mode, see Change server authentication mode . Note: That change requieres as SQL Server restart.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I would check the SQL Server errorlog for error message related to the log failures. As Olaf says, SQL Server needs to be enabled to accept SQL logins. But that is not the normal error message for a login failure due to Windows auth only being permitted.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft edited

Hi,

This should not be a regular error when mixed mode is disabled. I cannot reproduce this error (in the case of disabling mixed authentication mode and logging in with SQL account, you can see a very clear error in the errorlog), but i found multiple threads are pointing this solution (ie turn on the mixed mode). Still please check if you enable the mix authentication mode(SQL Server and Windows authentication mode).
https://docs.microsoft.com/en-us/answers/questions/69846/fixing-error-0-no-process-is-on-the-other-end-of-t.html
https://stackoverflow.com/questions/27267658/no-process-is-on-the-other-end-of-the-pipe-sql-server-2012

Also Please check the following settings:

  1. Max allowed connections. When I modified the Max number of concurrent connections for the instance and set a very small value, I did reproduce the problem.

  2. Check the Shared memory, TCP/IP, Named Pipes in SQL Server Configuration Manager, enable Named Pipes protocol


Here also is a good article about error 233.
https://www.databasefilerecovery.com/blog/fix-sql-server-error-233.html


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.