Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [configuration-manager]

SQL Server Configuration Manager

27 questions
12
votes
2 answers

SQL Server Network Configuration node missing from Configuration Manager after install

I have a server running Windows 2012 R2 Datacenter 64-bit. I was using SQL 2016 RC3 with no issues and I want to replace it with the RTM build we have from MSDN. After uninstalling RC3 and then installing RTM, I was unable to connect remotely to…
GregDBA
  • 303
  • 1
  • 4
  • 14
7
votes
3 answers

SQL Server Configuration Manager not display services

Config: Window Server 2008 R2 Enterprise SP1 / SQL Server 2008 R2 Enterprise (RTM) I have searched through Google using many different words and phrases. I know this was a common issue to occur with SQL 2005 and most mention doing a command line to…
user507
4
votes
1 answer

SQL Server Multi-Instance IP Configuration - Service Doesn't Start

I have run into an issue whilst configuring a multi-instance SQL Server when assigning a specific IP address to the fist instance. Dedicated IP Setup The steps I perform to configure a single instance to a dedicated IP address are: Open SQL Server…
John K. N.
  • 18,854
  • 14
  • 56
  • 117
3
votes
2 answers

SQL Server 2008r2 won't start after windows updates, error log & wmi provider errors

I have a SQL Server 2008 R2 instance on a Windows 2008 R2 box, and windows has not been updated for almost a year (I know), last night windows patches were applied (around a 100 that were pending), and this morning SQL Server will not start. The…
Ian_H
  • 1,674
  • 10
  • 17
3
votes
1 answer

Sql Server Configuration Manager

I have two SQL Server named instances, InstanceA and InstanceB on one computer, and they correctly show up under Sql Server Configuration Manager | SQL Server Network Configuration. However, when I try to configure SQL Native Client 11.0…
user99201
3
votes
1 answer

How to know who restarted and what caused SQL Server

I need to know Who restarted SQL Server or What caused automatically to restart SQL Server, I have searched Event viewer for events 17163, 6005, 6006 , 6008 and 6009, but unsuccessful it had returned null, i don't want information like last restart…
info.sqldba
  • 327
  • 4
  • 15
2
votes
1 answer

What is Accepted NTLM SPNs

In SQL Server Configuration Manager on the Advanced tab in TCP/IP Protocol properties box there is an option Accepted NTLM SPNs. What is the use of that option and how it can be used?
admin
  • 21
  • 1
  • 2
2
votes
1 answer

SQL Server Configuration Manager is not showing SQL Services

I have newly installed following things on my system - Microsoft SQL Server Management Studio 2014 - SQL Server 2017 - Visual Studio 2015 When I tried to open SSMS for the first time, it asked me for the "Server Name" when I surfed…
Maryam
  • 21
  • 1
  • 2
2
votes
2 answers

Does SQL Server Express 2016 come with SQL Server Configuration Manager?

Does SQL Server Express 2016 come with SQL Server Configuration Manager? If not, is there any licenced way to add SQL Server Configuration Manager to an existing installation of SQL Server Express 2016?
Allan Xu
  • 145
  • 4
2
votes
1 answer

Startup Parameters greyed out in SSCM for new instance

We do not appear to be able to change the startup parameters for a new SQL Server instance, using SQL Server Configuration Manager (see screenshot below). We are members of the sysadmin fixed server role, and are running SSCM version…
user3399498
  • 595
  • 2
  • 7
  • 16
2
votes
3 answers

Change SQL Server service account without restarting SQL Server

For security reasons, we want to change the password that starts the SQL Server service everyday. Is it possible to do this without restarting the service? If it is possible will the changes be immediately applied, or will I eventually need to…
Andres Arango
  • 195
  • 2
  • 9
2
votes
1 answer

I'm trying to enable SQL Filestream on Windows Server 2012 and SQL Server 2016 64 bit, Management Studio 2017

The machine config is Windows Server 2012, 64 Bit SQL Server 2016, and SQL Server Management Studio 2017. When I use SQL Server Configuration Manager to enable filestream, it gives me an error that I do not know how to get around. There was an…
sam
  • 141
  • 5
1
vote
1 answer

SQL Server 2019 setting Force Encryption with a script

I have to update 50+ servers to use encrypted connection strings. Is there a way to script setting Force Encryption and TrustServerCertificate (e.g Powershell, or ???) so that I don't have to open Configuration Manager and set on each box?
John Deupree
  • 13
  • 2
1
vote
1 answer

SQL Server Secure and Unsecure Traffic Configuration Help

I have a SQL Server 2017 instance that I have configured to listen on multiple ports 1433 and 1234. I would like to know if its possible to have one port (1234) accept only secure connections while the default port accept both? I have already set up…
deadLock
  • 390
  • 5
  • 15
1
vote
0 answers

Revert to using local account for SQL Server services

We have changed the login/startup account of our SQL Server service, to use a domain service account. However, we are experiencing issues with this account, and need to revert back to using the local NT Service\MSSQL$[namedinstance] account for now.…
user3399498
  • 595
  • 2
  • 7
  • 16
1
2