Questions tagged [configuration-manager]

SQL Server Configuration Manager

Filter by
Sorted by
Tagged with
1
vote
2answers
39 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
27 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
143 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 ...
1
vote
3answers
190 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 ...
0
votes
1answer
265 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
456 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: ...
0
votes
0answers
111 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
109 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
182 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
1k 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
50 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
147 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
618 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
906 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 "...
1
vote
0answers
900 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
583 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 ...
9
votes
2answers
10k 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
47k 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 ...