Share via

SSMS SQL Server Management Studio 2017 /2018 error

Sebastian Ene 21 Reputation points
Aug 22, 2022, 9:29 PM

Hi,
I tried making a connection to server, but no avail. I had this error:
233757-image.png

As a consequence, I uninstalled SQL Server Management Studio 2018, installed it again and saw same error. Then I found out that I should have enabled some service in SQLServerManager1_.msc file, but for 2018 version it had none. So I uninstalled it again and installed 2017 instead, which had SQLServerManager14.msc file inside C:/SysWOW64 as shown on forums.
I ran it without and with administrator rights, and I got this error:
233729-image.png

In the Add/Remove programs, I saw that I have many versions of the SQL, could it be that they affect the installation of 2017/2018? The versions installed are shown in the figure below:
233770-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,279 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 22,341 Reputation points Microsoft Vendor
    Aug 23, 2022, 2:31 AM

    Hi @Sebastian Ene ,

    The error message that your offered is a common SQL server connection failed error. It is not related to SSMS. Please follow below steps to troubleshot this issue. From your screenshot, it seems you do not have a complete SQL server installation, you can get SQL 2019 setup file from here. You can follow the steps from this blog to install SQL server 2019.

    1. Make sure SQL Server Service is running 233818-capture7.png
    2. If a named instance, make sure SQL Server browser service is running. Make sure the instance name is spelled correct and there is actually such an instance on your target machine.
    3. Make sure SQL Server is configured to allow remote connections
    4. Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports
    5. Test server connectivity with PING from the client machine
    6. Test port connectivity using TELNET to the server and port (from step 4) from the client machine. For example
      TELNET <server-name> 1433
    7. Check firewall settings if step 5 or 6 connectivity test fails

    If you have some confuse about the steps, please refer to Resolving could not open a connection to SQL Server errors or Troubleshoot connecting to the SQL Server Database Engine to get more information.

    > could it be that they affect the installation of 2017/2018?

    No.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".


1 additional answer

Sort by: Most helpful
  1. Bjoern Peters 8,891 Reputation points
    Aug 23, 2022, 2:29 AM

    Hi,
    sorry to tell you but you are wrong...

    You have just a connection error as you tried to connect to your SQL server, read the message in your first screenshot carefully... it is just saying that there was a problem with establishing a connection.

    If there is a problem with a connection, an uninstall/re-install won't help ;-)

    You are writing only about installation of SQL Server Management Studio (SSMS)... this is just a Management Tool and not a database, it neither brings a database engine with it. So in order to have a SQL Server database you have to install another software... from your last screenshot I could see, that you already have installed SQL 2019 LocalDB... this is enough for developing and testing things locally

    So normally you open your SSMS, enter (localdb) in the servername field and enter your credentials (from the installation of LocalDB)
    More on LocalDB => https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15

    For more on how to connect to your LocalDB with SSMS (or any other tool) you might find it helpful to read at least this blog post
    https://stackoverflow.com/questions/12534454/how-to-connect-to-localdb

    Otherwise you can install the SQL Server 2019 Express Edition then you will have a little more than just a "database".


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.