SQLServerManager

Question

Hello I uninstalled SQL server management studio and installed it again so I need to configure the server and when I launch the SQL management studio and it picked up the last credentials but it won't connect so I went searching for the SQLServermanager.nn.mcs and it's not there or inside the system files any help, please

Answer 1

Hi @sufian hamdan ,

Did you mean SQL server configuration manager or SQL server management studio?

SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. SQL Server Configuration Manager is installed with your SQL Server installation. Refer to MS document SQL Server Configuration Manager. We can find the SQL server instances that you installed in your server as below screenshot .

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. We need to download and install SSMS separately since SQL server 2016. Refer to MS document Download SQL Server Management Studio (SSMS). Suggest you using the latest version SSMS 18.9.2.

For connecting to SQL server instance, please follow below steps.

Choose the SQL server instance that you want to connect.

Choose the SQL server authentication, Windows authentication or SQL server authentication.

By the way, if the SQL server connection failed, please follow below MS document to resolve the issue.

Troubleshoot connecting to the SQL Server Database Engine

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

Answer 2

Good day sufian hamdan < @sufian hamdan >

The title of your question is SQLServerManager and the tag which you select to use is sql-server-general but according to the content of your question you speak about SQL Server Management Studio (SSMS) which is totally different application. Therefore, I will need to assume that the question is regarding using SSMS and connecting from SSMS to SQL Server

SSMS as mentioned is not related to SQL Server. It is a client application which works like any client application that you can develop. It uses connection string like any other application in order to connect the server. In fact Microsoft has another such application that can be used to manage SQL Server and it named Azure Data Studio (free, open source, withy version to be used in any common operating system).

SSMS can be installed in the same machine as the SQL Server but more common is to install SSMS on remote machine like laptop or working client machine and connect the server.

As much as I understand the issue is that you used to have SSMS -> you uninstalled it -> you installed SSMS again -> and you now need to connect SQL Server

Now when you try to connect any SQL Server which in the same machine or in different machine. You need the details to fill in the connection windows and you do not have these. so we need to find the information for the connection

find the information in order to connect the SQL Server

Connect the machine where your server is installed

To find the SQL Server Instance name: Option (1) in the command line or using cmd execute the command: services.msc -> this will open the list of services -> Search for a service with the name SQL Server. The name of the instance will appear in the brackets. Option (2) Open the SQL Server Configuration Manager and under the SQL Server Services you can fins the instance name

Please try to find the missing information as explain above and inform us if this worked or if you need another parameter in order to connect the server

Note! using the above information you can also confirm that the SQL Server instance is actually installed and running. Many people confuse between SSMS and SQL Server and after they install SSMS they think that they installed SQL Server and obviously they cannot connect it since it is not installed. If the server is not installed then you will not find the services of the server.