Questions tagged [configuration-manager]

SQL Server Configuration Manager

Filter by
Sorted by
Tagged with
4
votes
1answer
109 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 ...
0
votes
1answer
51 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 ...
0
votes
1answer
24 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?
1
vote
1answer
78 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 ...
1
vote
1answer
30 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 ...
0
votes
1answer
581 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 ...
1
vote
1answer
611 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?
2
votes
1answer
863 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 ...
2
votes
2answers
71 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 ...
0
votes
1answer
33 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 ...
2
votes
1answer
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 ...
2
votes
3answers
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 ...
2
votes
1answer
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 ...
0
votes
1answer
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: ...
1
vote
0answers
564 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 ...
0
votes
1answer
937 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 ...
1
vote
1answer
509 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 ...
3
votes
2answers
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), ...
0
votes
1answer
1k 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 ...
0
votes
1answer
240 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 ...
0
votes
0answers
262 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 ...
3
votes
1answer
848 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 ...
1
vote
1answer
1k 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 "...
2
votes
2answers
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 ...
3
votes
1answer
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 ...
11
votes
2answers
18k 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 ...
0
votes
0answers
62 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 ...
7
votes
3answers
51k 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 ...