Please make sure the Server type is "Database Engine", not "Reporting Services" on the SQL Server login window on SSMS.
Cannot connect to SQL Server
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:
- the installer account
- the service account used for SQL Server
- 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
2 answers
Sort by: Most helpful
-
-
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.
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.