Questions tagged [configuration-manager]

SQL Server Configuration Manager

Filter by
Sorted by
Tagged with
4 votes
1 answer
270 views

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 ...
user avatar
0 votes
1 answer
102 views

Supported RSA Key Lengths for Encrypted SQL Connections

I'm having trouble finding any documentations regarding supported key lengths for RSA certs to encrypt SQL connections. Our internal CA is issuing certs with a 4096 key length and that seems to work ...
user avatar
0 votes
1 answer
38 views

Why does sql configuration manager show 32 and 64 bit options when only 64 bit version is installed?

I have installed sql server 64 bit. Why does sql configuration manager show 32 and 64 bit options when only 64 bit version is installed?
user avatar
  • 2,371
1 vote
1 answer
116 views

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 ...
user avatar
1 vote
1 answer
42 views

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 ...
user avatar
  • 388
0 votes
1 answer
823 views

SQL Server Alias won't work for my database instance

I have setup a SQL Server 2019 instance on my machine which has a computer name in a format like this: AB-ABC1234ABAB My SQL instance is named 'SQL2019', therefore I connect to my local SQL instance ...
user avatar
1 vote
1 answer
786 views

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?
user avatar
  • 11
2 votes
1 answer
1k views

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 ...
user avatar
  • 21
2 votes
2 answers
81 views

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 ...
user avatar
  • 145
0 votes
1 answer
39 views

when is it necessary to create aliases in the SQL Configuration Manager?

I am having a problem with connectivity in one of my transactional replications and when checking the situation with the SQL Server configuration manager I see there are aliases. I was wonder why ...
user avatar
2 votes
1 answer
1k views

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 ...
user avatar
  • 535
2 votes
3 answers
2k views

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 ...
user avatar
2 votes
1 answer
1k views

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 ...
user avatar
  • 41
0 votes
1 answer
2k views

Access SQL Server Configuration Manager on a remote server

I am trying to add a traceflag as a startup parameter to a distant SQL Server 2016, installed on a Windows 2016 core server and I am following these instructions At this point in the document: ...
user avatar
  • 9,478
1 vote
0 answers
668 views

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 ...
user avatar
  • 535
0 votes
1 answer
1k views

Difference between an endpoint and a port in SQL Server

While I know why are ports used in SQL Server, I wonder what is the difference between an endpoint and a port. Ports can be managed using Configuration Manager, is it also possible to manage endpoints ...
user avatar
  • 2,006
1 vote
1 answer
543 views

How can I configure SQL Server Aliases on a SQL Server Client Machine

Even after installing SSMS on a SQL Server Client machine, I found that SQL Server Configuration Manager would not run. Manually loading the mof file via Microsoft's Instructions was sufficient to ...
user avatar
  • 185
3 votes
2 answers
3k views

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), ...
user avatar
  • 1,521
0 votes
1 answer
2k views

Linked Server - Double Hop - Kerberos - TCP

I am having trouble with a Linked Server. I would typically not use a linked server, but legacy issues are forcing my hand. I am attempting to set up a linked server between two new production SQL ...
user avatar
0 votes
1 answer
292 views

ssrs how to make the report available to my local machine

I have been struggling in Configuring Report Server URLs for a certain reporting services server. when I am in the server itself, the url works fine as you can see on the picture below. but trying ...
user avatar
0 votes
0 answers
269 views

How to enable the NoDelay parameter for SQL Server?

We have a recommendation from performance audit to "enable the "NoDelay" parameter on our database". I searched through Microsoft documentation and found that this parameter is configurable with SQL ...
user avatar
  • 283
3 votes
1 answer
862 views

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 ...
user avatar
1 vote
1 answer
2k views

sql server configuration manager says it is on a 32 bit machine and it is not. Should we change that?

when running the following script for Determining 32/64 bit in Powershell cls if ((gwmi win32_operatingsystem | select osarchitecture).osarchitecture -eq "64-bit") { #64 bit logic here Write "...
user avatar
2 votes
2 answers
2k views

SQL Server 2016 - Configuration Manager WMI Problem

Background: Windows Server 2016 Core SQL Server 2016 Enterprise (obviously 64-bit) Windows Failover Cluster SQL Failover Cluster I am attempting to connect to SQL Server Configuration Manager via my ...
user avatar
  • 91
3 votes
1 answer
1k views

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 ...
user avatar
12 votes
2 answers
19k views

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 ...
user avatar
  • 293
0 votes
0 answers
63 views

SQL Server Configuration Manger not applying permissions

I am trying to change the service account of a SQL Server 2014 instance to use an MSA. The MSA has already been created and installed to this server. I have changed it to a domain account previously ...
user avatar
  • 534
7 votes
3 answers
52k views

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 ...
user avatar