Questions tagged [windows-server]
All versions of Windows Server. Please also add a version-specific tag like windows-server-2012 if that is relevant to the question.
26
questions
5
votes
2
answers
6k
views
when applying a sql server cumulative update or service pack on a virtual machine - what could be a safe way of stopping VMWaretools?
While applying cumulative updates to sql server 2016 SP1, there are a bunch of services and applications that need to be stopped for the update to go on.
Among those is the very core of the virtual ...
- 15.8k
5
votes
1
answer
15k
views
How many users are supported on SQL Server 2012 Express?
I would like to say that i have gone through some of the sql blog and MSDN BOL, but still there is some confusion in mind like.
The limitation of SQL Server 2012 Express is 10 GB. It is the ...
- 6,387
12
votes
3
answers
56k
views
Moving SQL Server to different domain
What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain? What steps definitely/might need to be done for SQL Server before and ...
- 473
35
votes
4
answers
19k
views
Slower SQL Server performance after allocating more CPU and RAM
We have SQL Server 2008 R2 (10.50.1600) running on a virtual Windows 2008 R2 server. After upgrading the CPU from 1 core to 4 and the RAM from 4 gb to 10 gb, we've noticed the performance is worse.
...
- 505
13
votes
2
answers
9k
views
SQL Agent - PowerShell step "syntax error"
I have the following code setup in SQL Agent Job step that is not running. The message received is simply:
Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed.
...
user507
6
votes
2
answers
28k
views
SQL Server Service Account login or password is not valid error
I am trying to install SQL Server 2012 Express on a Windows 2012 Server for test purposes. This machine is part of our company domain.
During installation I am trying to use one of domain account ...
- 458
0
votes
2
answers
3k
views
how to run SSMS as a different user?
I am running SSMS as a different user from my local machine and it works fine.
When I try to do the same, even using my own credentials, on server01 I get the following error:
access is denied
I am ...
- 15.8k
-2
votes
1
answer
1k
views
What is the difference between CU-GDR and GDR?
There are 2 paths to patching SQL server. Either the SQL CU (cumulative) upgrade or GDR (critical) upgrade.
CU includes functionality fixes and security fixes (https://support.microsoft.com/en-us/...
- 1
10
votes
2
answers
26k
views
Changing Data Directory on MySQL DB Server
I have installed mysql server 5.6.24 on Windows Server 2012 R2.
I imported dump files and the data files are stored in C:\ProgramData\MySQL\MySQL Server 5.6\data
I want to change directory like D:\...
- 101
8
votes
3
answers
26k
views
Data warehouse server. How do you calculate RAM/CPU specifications?
I am trying to write a spec for a data warehouse server for our planned data warehouse upgrade.
As we run virtual servers on VMWare hosts we have the ability to add or remove resources as necessary. ...
- 3,203
7
votes
2
answers
5k
views
Is it safe to run a Windows Failover Cluster Public and Heartbeat on a Single NIC?
I have a 2-Node Windows Failover Cluster (Windows Server 2016, SQL Server 2017) with a Quorum Disk Witness on fibre-connected shared storage.
How important is it that the heartbeat is on its own ...
- 536
6
votes
1
answer
7k
views
SQL Server and SSPI handshake failed error
Recently I faced an issue where users from one domain were unable to login to SQL Server and getting this error:
Error: 17806, Severity: 20, State: 2.
SSPI handshake failed with error code ...
- 1,908
6
votes
1
answer
13k
views
Multiple IPs registered for listener when using AlwaysOn AGs w/ multi-subnet clustering
We are testing AlwaysOn Availability Groups on a WSFC multi-subnet cluster and using dynamic DNS registration. Our issue is that sometimes the IP for the Availability Group Listener (AGL) in the ...
- 61
6
votes
2
answers
1k
views
Intermittent SQL Delegated Authentication Errors
Here is an odd issue that is causing me to lose all my hair.
Every few days or so our delegated authentication from one SQL server to another fails with the error:
Login failed for user 'NT AUTHORITY\...
- 61
5
votes
2
answers
73k
views
Cluster network name resource 'Cluster Name' failed registration
I have a fail-over cluster set between two Windows Server 2016 machines, and I'm seeing errors regarding the DNS record, both for the cluster itself and for any listener I try to add in SQL high ...
- 51
4
votes
2
answers
41k
views
Oracle program "lsnrctl" is missing after the installation of 32bit Oracle client
I cleaned up my computer for all old Oracle stuff using Uninstall (OUI) and then later used regedit to delete all references to Oracle and then deleted all remains of Oracle directories.
I have HP ...
- 41
4
votes
2
answers
10k
views
Cannot install Sql Server 2019 on Windows Server 2022
On a brand new install of Windows Server 2022 standard, I am trying to install SQL Server 2019.
I downloaded the eval version, put my key in and proceeded to install the Database Engine. Default ...
- 41
3
votes
5
answers
12k
views
Windows Logs Application is full of "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]"
I have Windows Server 2016, with SQL Server 2017, and found Windows Log Application is full of Login failed messages (as follows) :
Login failed for user 'sa'. Reason: Password did not match that ...
- 185
3
votes
1
answer
7k
views
SQL Server 2008 R2 Express single CPU core usage and need of upgrade to SQL Server 2014 Express
In our office we are using SQL Server 2008R2 Express which is installed in Windows server 2012. The SQL Server database is accessed by more than 60 users in network simultaneously. In recent days we ...
- 3,131
3
votes
1
answer
30k
views
Does "use AWE to allocate memory" do anything on a SQL Server 2008 R2 64bit Windows 2003 system?
After checking the box I noticed that queries that would timeout after 30 seconds would complete execution.
The TechNet article says "AWE is not required and cannot be configured on 64-bit ...
- 33
2
votes
1
answer
6k
views
how to Enable these Windows Firewall rules using powershell?
I have a few servers where I see a blue question mark on the sql server service, as per the picture below.
This is the solution:
Enabling these Windows Firewall rules did the trick for me
Windows ...
- 15.8k
2
votes
1
answer
1k
views
Collation issue after update (KB3072779) of SQL Server 2012
If found the following error while starting my SQL Server 2012 instance, after the update KB3072779 performed by Windows Update (Windows Server 2012 Foundation).
Creating procedure ...
- 155
2
votes
1
answer
961
views
Why SQL Server Express 2012 take automatically backup in "Virtual Device" without virtual device configuration?
I have noticed that after migration of SQL Server 2012 Enterprise to SQL Server 2012 Express, every day it shows "spurious" virtual backup after taking manual backup of database.
When I execute this ...
- 6,387
2
votes
1
answer
7k
views
Stack Dumping and performance degradation of sql server process [closed]
I would like to say that today i got first time SQL Server log message in My SQL Server 2012 Database.
***Stack Dump being sent to D:\MSSQL11.MSSQLSERVER\MSSQL\LOG\SQLDump0012.txt
* *****************...
- 6,387
0
votes
2
answers
12k
views
pgAgent : how to configure pgpass.conf for a local connection on Windows Server 2008
I try to configure pgAgent on Windows server 2008 to make automatic backup on the database.
pgAgent is installed on the server and the service is running normally.
I use PgAdmin3 and PostgreSql 9.3
I ...
- 11
0
votes
1
answer
855
views
Automatic recovery on a 3 node AlwaysOn Multisite Cluster?
We are looking to build a 3-node AlwaysOn Windows 2012 R2 failover cluster with 2 nodes in our primary datacenter for HA, and a 3rd node replica in our DR datacenter for reporting.
Given this is a ...
- 111