Forum Discussion

MurraySobol985's avatar
MurraySobol985
Brass Contributor
Apr 11, 2024

Connection problem

Environment: Windows 11 64-bit Professional

I downloaded and install SQL Server Management Studio 20 (my sign-in account has administrator privileges).

I also applied yesterday/today's security patches:

Security Update for SQL Server 2022 RTM GDR (KB5035432) -> Installed ok

Security Update for Microsoft OLE DB Driver 19 for SQL Server (KB5037573) -> Installed ok

When I try to connect I get this message:

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

 

If I try to connect a second time I get this message:

Login failed for user 'dba'. (Microsoft SQL Server, Error: 18456)

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

 

I used SQL Server  Configuration Manager to verify my services and I think that they are ok.

 

I also checked my IP addresses:

IPv6 Address. . . . . . . . . . . : 2001:db8::1(Preferred)

IPv4 Address. . . . . . . . . . . : 10.252.1.28(Preferred)

BTW: this install is on my local laptop, not connected to any network.

 

It appears to me that it is not recognizing my account having administrator privileges, how can I resolve this?

 

Thanks

 

 

5 Replies

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 12, 2024

     

    I downloaded and install SQL Server Management Studio 20

    MurraySobol985 , SSMS = "SQL Server Management Studio" is just a tool, not the database engine.

    Have you installed SQL Server database engine at all and is it running?

    • MurraySobol985's avatar
      MurraySobol985
      Brass Contributor
      Apr 12, 2024

      olafhelper 

      Sorry about that, yes, the database engine is installed.

      I BELIEVE that it is running since I see the following services;

       

      • SivertSolem's avatar
        SivertSolem
        Iron Contributor
        Apr 12, 2024
        Your first error could be due to the "delayed start". I suspect the SQL Server services weren't yet running.
        For your second error, it appears you're attempting to use an SQL authenticated user "dba".
        Did you allow for mixed authentication when you installed SQL Server?
        Likewise, did you add your Windows user to SQL Server during installation?
        A local admin account does not automatically have access to the SQL Server instance on the machine.

        By default, SQL Server installs in Windows auth only mode (integrated security).

        The SQL Server errorlog also logs failed login attempts automatically, and the errorlog is a text file located on your installation path.
        Default ERRORLOG path for SQL Server 2022:
        C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log\ERRORLOG

        The errorlog file has no extension and can be opened in Notepad.

        Assuming you are slightly comfortable with command line, I suggest dbatools' Reset-DbaAdmin to regain control of your instance. dbatools is a community powershell module.
        https://docs.dbatools.io/Reset-DbaAdmin.html

        Alternatively you could follow the more manual procedure documented by Microsoft.
        https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?view=sql-server-ver16

Resources