Stack Overflow
Stack Overflow

Questions tagged [sql-server-config-manager]

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 a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. Microsoft Management Console (mmc.exe) uses the SQLServerManager10.msc file in the Windows System32 folder to open SQL Server Configuration Manager.

SQL Server Configuration Manager and SQL Server Management Studio use Window Management Instrumentation (WMI) to view and change some server settings. WMI provides a unified way for interfacing with the API calls that manage the registry operations requested by the SQL Server tools and to provide enhanced control and manipulation over the selected SQL services of the SQL Server Configuration Manager snap-in component.

For more info, see:

SQL Server Configuration Manager

23 questions
262
votes
13 answers

SQL Server Configuration Manager cannot be found

After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start / SQL Server 2008 / Configuration Tools menu. What should I do to install this tool?
Jin Ho
  • 3,565
  • 5
  • 23
  • 25
12
votes
2 answers

SQL Server Error "Named Pipes Provider: Could not open a connection to SQL Server [53]"

I used to have a desktop application pointing to a Sybase database through an .ini file that had this connection string: CONNECTION_NAME = "DSN="Dna_Name";UID="User";PWD="Password"" It worked perfectly. A few days ago the database has been…
G21
  • 1,297
  • 2
  • 18
  • 39
4
votes
2 answers

How to configure ngrok for SQL Server access

I would like to test a website in development hosted in a remote location against a sql server instance on my local machine. I was thinking I could run ngrok locally and update the connection string on the remote website appropriately, but I'm not…
BVernon
  • 3,205
  • 5
  • 28
  • 64
2
votes
1 answer

Services not visible in SQL Server Configuration Manager

I have installed SQL Server 2008 Management Studio Express 32 bit. I have installed it successfully but when I try connect with SQL Server I am getting an error Then I thought to turn the services ON from SQL Server Configuration Manager but I am…
Garvit Gupta
  • 189
  • 1
  • 5
  • 15
1
vote
0 answers

How do you configure the SQL Server Network Configuration protocols in a MSSQL Express Docker container on a Linux server?

The gist of the issue is that I am trying to connect to a MSSQL Express Docker container, living on a RHEL 7 server from my local Windows 10 machine using Microsoft SQL Server Management Studio. It is successfully connecting to the RHEL 7 server IP…
Marvin
  • 23
  • 1
  • 9
1
vote
1 answer

SQL server services not getting started

I am getting below two errors when I try to start SQL server from services. This issue started since I messed up something with SQL server configuration manager in order to add an alias so I can login with localhost name. Can anyone please help…
Rush.2707
  • 685
  • 10
  • 29
1
vote
1 answer

SQL Server 2014 Configuration Manager - Cannot disable Protocol in TCP/IP

I do have a problem with my SQL Server 2014 Configuration Manager. All of my Yes/No answered option is not appearing. Is there any way to configure using command prompt? In Protocol tab, and IP Addresses tab, I cannot change all Yes/No options.…
pemaustria
  • 167
  • 1
  • 2
  • 15
1
vote
1 answer

MMC could not create the snap-in. SQL Server configuration manager error

When i tried to connect to sql server configuration manager in sql server 2008. It shows error MMC could not create the snap-in. It was working perfectly till last night. What can be the reason, how can i solve it. I can not post image of error…
Bhanwar Lal Saini
  • 11
  • 1
  • 2
1
vote
1 answer

Cannot connect to wmi provider sql server 2012

The following error dialog pops up when I tried connecting to SQL Server Configuration Manager on my SQL Server 2012 production server: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only…
Bibios
  • 11
  • 2
0
votes
0 answers

How to properly add an alias in SQL Server Configuration Manager for Local Server

The application in the configuration has the given name (localdb)/MyProj. I do not want to change the application code to connect to the server, so for this purpose I wanted to use the aliasing functionality available in SQL Server Configuration…
A510
  • 298
  • 1
  • 4
  • 9
0
votes
0 answers

SQL Server Configuration manager not found anywhere on the drive

I want to enable TCP/IP on my SQL Server Express 2016 but I cannot find SQL Server Configuration Manager. I am using windows 10 and I couldn't find it in the start menu and I can't find it by searching for SQLServerManager13.msc in this pc. I tried…
Jurij15
  • 11
  • 1
0
votes
2 answers

Having difficulty with nested select statements in SQL

I'm trying to create a ConfigMgr report that will display 3 registry key values for each laptop in our environment. My query looks like this: Select distinct SYS.Netbios_Name0, (Select REG.Value0 where…
cottageDog
  • 33
  • 1
  • 4
0
votes
0 answers

How to resolve "Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'TestTable1'"?

I'm developing a VB.NET windows service which connects with some SQL databases. When I try to start the windows service it throws me these errors in the windows event viewer. ERROR 1 Service cannot be started. System.Data.SqlClient.SqlException…
Ashan Glenn
  • 27
  • 10
0
votes
3 answers

I want to create a shared database c# windows form application?

This application that i am trying to create, whose "instances/copies" will be installed on multiple PCs of the client and are able to access the same database from another PC of the same client that has SQL server running all the time through the…
Alex Davidson
  • 21
  • 3
0
votes
0 answers

How to allow ODBC with VS 2017 MSSQL Express instance

So.. I have an SSDT project where I test deployments against an instance of MSSQL Express 2017 that comes standard with VS 2017. Now I want to use the same instance to test my python ETL scripts and so i'm trying to set up an ODBC…
Jamie Marshall
  • 1,885
  • 3
  • 27
  • 50
1
2