How to figure out the Local Instance on Microssoft SQL Server Management Studio 2020

Question

How to figure out the Local Instance on Microssoft SQL Server Management Studio 2020

Shweta Jain 0

I am getting error when i try to login to local instance in MS SQL 2020

Olaf Helper 47,616 Reputation points

2024-10-07T13:09:13.5633333+00:00

And which exact + complete error message do you get?
Shweta Jain 0 Reputation points

2024-10-07T13:28:42.8933333+00:00
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator

2024-10-07T21:37:50.5833333+00:00

In addition to Olaf's post, you have installed SQL Server locally, haven't you?

Then again, there is SQL Server 2020... If you have only installed SSMS, you have only installed SSMS, and there is no SQL Server. You can still use SSMS to connect to SQL Server installed on other machines.
CathyJi-MSFT 22,426 Reputation points Microsoft External Staff

2024-10-10T02:42:20.54+00:00

Hi @Shweta Jain

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
CathyJi-MSFT 22,426 Reputation points Microsoft External Staff

2024-10-15T01:44:21.0633333+00:00

Hi @shweta jain

Have a good day! Did your issue is resolved? Could you kinldy let us a note of your issue status?

2 answers

Your answer

Olaf Helper 47,616 Reputation points

2024-10-07T13:09:13.5633333+00:00

And which exact + complete error message do you get?
Shweta Jain 0 Reputation points

2024-10-07T13:28:42.8933333+00:00
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator

2024-10-07T21:37:50.5833333+00:00

In addition to Olaf's post, you have installed SQL Server locally, haven't you?

Then again, there is SQL Server 2020... If you have only installed SSMS, you have only installed SSMS, and there is no SQL Server. You can still use SSMS to connect to SQL Server installed on other machines.
CathyJi-MSFT 22,426 Reputation points Microsoft External Staff

2024-10-10T02:42:20.54+00:00

Hi @Shweta Jain

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
CathyJi-MSFT 22,426 Reputation points Microsoft External Staff

2024-10-15T01:44:21.0633333+00:00

Hi @shweta jain

Have a good day! Did your issue is resolved? Could you kinldy let us a note of your issue status?

Answer 1

Hi @Shweta Jain

MS SQL 2020

There is no SQL server 2020. The latest version of SQL server is SQL server 2022, you can get it from here. Maybe you installed the latest version SSMS 20.2, a management tool for SQL server instance.

AS Erland mentioned, you need to install SQL server instance first, then use SSMS to connect to SQL server instance. If you still have some confuse, please start from this blog How to install SQL Server 2022 step by step. Then fill in the correct server name in SSMS box as Olaf mentioned.

If your SQL server instance is installed correct, you still cannot connect to SQL server instance successfully, please follow the steps from this MS document to troubleshoot connection issue.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Answer 2

Olaf Helper 47,616

The error message reports "MSSQLSERVER" as server name; I am sure it's not.

If it's a local default SQL Server enter a dot "." as server name or open the drop down => Browse.

0 comments

Share via

How to figure out the Local Instance on Microssoft SQL Server Management Studio 2020

2 answers

Your answer