creating a dba user problem

Murray Sobol 21 Reputation points
2022-11-20T14:57:34.057+00:00

I just installed SQL Server Management Studio V18.12.1 from this link: Free Download for SQL Server Management Studio (SSMS) 18.12.1

When I try to install Configuration Manager from this page:

						Which Configuration Manager do I use??  
						  
					  
				  
		  
	  
  
		  
  
  
  
  
  

  
  
   
  
  
  
			  
	  
		  
			  
					  
						Re: Which Configuration Manager do I use??  
						  
					  
				  
		  
	  
  
		  
  
  
  
  
  

there is NO entry for the version of SSMS that I am running.

Also, note that SSMS is loaded onto my laptop, it is NOT running off a network server.

When I try to connect I get this message: TITLE: Connect to Server ------------------------------ Cannot connect to MSI. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-2-database-engine-erro... ------------------------------ The system cannot find the file specified ------------------------------ BUTTONS: OK ------------------------------ That is why I think I need to run Configuration Manager.
Any assistance would be appreciated.

Murray

						Which Configuration Manager do I use??  
						  
					  
				  
		  
	  
  
		  
  
  
  
  
  

  
  
   
  
  
  
			  
	  
		  
			  
					  
						Re: Which Configuration Manager do I use??  
						  
					  
				  
		  
	  
  
		  
  
  
  
  
  

there is NO entry for the version of SSMS that I am running.

Also, note that SSMS is loaded onto my laptop, it is NOT running off a network server.

Any assistance would be appreciated.

Murray

						Which Configuration Manager do I use??  
						  
					  
				  
		  
	  
  
		  
  
  
  
  
  

  
  
   
  
  
  
			  
	  
		  
			  
					  
						Re: Which Configuration Manager do I use??  
						  
					  
				  
		  
	  
  
		  
  
  
  
  
  

there is NO entry for the version of SSMS that I am running.

Also, note that SSMS is loaded onto my laptop, it is NOT running off a network server.

Any assistance would be appreciated.

Murray

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

1 answer

Sort by: Most helpful
  1. YufeiShao-msft 7,081 Reputation points
    2022-11-21T02:27:50.947+00:00

    Hi @Murray Sobol ,

    try to install Configuration Manager from this page, note that SSMS is loaded onto my laptop, it is NOT running off a network server.

    Configuration Manager is installed with your SQL Server installation, if you have installed SQL Server, you can open it directly, SSMS only is a tool for managing SQL Server and Configuration manager is also a tool to manage the services associated with SQL Server

    Error 2

    SQL Server services may be disabled, please Windows+R to open Run, input "compmgmt.msc", make sure start the service

    262365-image.png

    Please enable TCP/IP for SQL Server
    262394-image.png

    Please make sure enable remote location

    -------------

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.