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: