Cannot connect to SQL Server

Dominique DUCHEMIN 831 Reputation points
2020-09-04T16:47:20.143+00:00

Hello,

I installed SQL Server 2016 Standard.
I was able to connect to SSMS...

Then I installed SQL Server Reporting Services and now I cannot get in SSMS even with the Built-In account.
I tried several Local Administrators:

  1. the installer account
  2. the service account used for SQL Server
  3. the service account used for SQL Server Agent

All these accounts failed after the Reporting Service was installed!!

Any idea?
Thanks,
Dom

SQL Server Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Guoxiong 8,206 Reputation points
    2020-09-04T19:40:24.34+00:00

    Please make sure the Server type is "Database Engine", not "Reporting Services" on the SQL Server login window on SSMS.

    0 comments No comments

  2. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2020-09-07T01:31:34.257+00:00

    Hi Dom,

    Please make sure you choose ‘Database Engine’ option when you connect to SQL server instance as below screenshot.
    22740-annotation-2020-09-07-092933.jpg

    If this is not work, please share us the detail error message when your connection failed.

    Best regards,
    Cathy

    ===============================================

    If the response helped, do "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.