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.
113
questions with no upvoted or accepted answers
4
votes
0
answers
7k
views
Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave
I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file.
master-info-repository=table
relay-log-info-repository=table
These ...
- 441
3
votes
0
answers
137
views
Moving from dynamic disk allocation to direct space disk via storage pool in SQL server
Pardon me if I am not clear in asking the question since I have very less understanding from storage terms used or how it's used with Sql server.
Currently our storage team is testing to move disk ...
- 2,169
3
votes
0
answers
78
views
database restore with filestream on Windows Server 2016 renames data file
I have a database in SQL Server 2008 R2 sp2 that has filestream enabled. Restore of the database on a Win10 machine works as it should.
However, on Windows Server 2016, the data directory (file) for ...
- 31
3
votes
0
answers
67
views
How can I attach the SSL authenticated certificate for my SQL Server 2014 if it is not on domain controller
We have Microsoft Azure with Windows Server 2012 R2 in Cloud Computer and window Server is Standalone it is not come under domain controller. We want to add SSL authentication.
SQL Server is not ...
- 31
3
votes
0
answers
1k
views
Move SQL Server cluster from one location to other
I am looking for ideas on how to move SQL Server 2012(standard) two node cluster installed on Windows server 2012 standard to other location which is far away from current location. The two locations ...
- 18.9k
3
votes
0
answers
195
views
SQL Server 2012 certificate encrypt connection
I'm not a DBA by trade. My organization doesn't have a dedicated DBA, we have to just figure things out. I have a SQL Server 2012 Enterprise installed on a Sever 2012 R2 OS. It is a not in a SQL ...
- 31
3
votes
1
answer
473
views
MySQL Create Table with Partition Very Slow on server machine
Following create table statement with Partition
runs in 10 Second on My Development Machine windows 7, i5 , 8GBRam, single disk
runs in 16 Second on Virtual Machine windows server 2012 , xeon 2GHz , ...
- 51
3
votes
2
answers
100
views
Concerns regarding changing virtual NIC on SQL Server 2008 R2 / Windows Server 2008 R2
I have SQL Server 2008 R2 running on Windows Server 2008 R2 in a virtual environment (ESXI 5.5). Client has been advised to switch the existing E1000 adapter with a VMXNET 3 adapter because they were ...
- 35
2
votes
0
answers
513
views
SQL Browser Service Stops After One Minute
I am encountering an issue with the SQL Browser service where the service will start, run for around 60-90 seconds and then stop. No error is logged, the event logs show three informational entries:
...
- 9,842
2
votes
0
answers
667
views
ODBC Driver Manager Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303) - Windows Server 2012 R2
I have a problem with adding MySQL server via linked server to my SQL Server Database
Following this instruction unfortunately just does not work out for me.
I added four data sources, 2 using 64-...
- 21
2
votes
0
answers
379
views
How to Configure SSRS Web Service Port via Command Line
It is straightforward to change the TCP port of SSRS using the GUI (Reporting Services Configuration Manager) but I am trying to fully script the installation and config of our SSRS servers.
Is it ...
- 397
2
votes
0
answers
18
views
Where should I put my system databases in WindowsCore container
We're looking into migrating our SQL Server environment to use containers.
I've successfully built a WindowsCore image with SQL Server installed. The instance is accessible with the data files using ...
- 441
2
votes
1
answer
397
views
Cosmos DB ODBC driver installation problem
We are trying to install Cosmos DB ODBC Driver following the instructions provided in this Microsoft Azure resource and are running into the following error:
The setup routines for Microsoft ...
- 21
2
votes
0
answers
42
views
Capture SQL 2014 installation errors
Right now when I install SQL 2014 (via a PowerShell script) it automatically sends errors to:
c:\Program Files\Microsoft SQL Server\120\Setup
Bootstrap\Log\blahblahlog.txt
I'm hoping to capture ...
- 197
2
votes
0
answers
686
views
SSIS 14 - Buffer Memory - Good practices
I've a some packages in SSIS 14 in order to extract the data from a lot of operational databases and load into my Data Warehouse.
I've the following virtual machine:
Windows Server R2 Standard
RAM:...
- 123
2
votes
0
answers
551
views
Slow SSMS connecting to AWS EC2 instance
I have an AlwaysOn availability group in AWS EC2. 2 nodes, multisubnet, with 1 DC in one subnet, the other DC in a separate (3rd) subnet. All in the same VPC.
When anyone connects to either of the ...
- 1,490
2
votes
0
answers
806
views
DBCC failure due to sparse files on Windows Cluster
We have a SQL Server 2014 SP1 cluster on Windows Server 2012 R2, and came across a problem with DBCC jobs failing and issuing the following messages:
Msg 1823, Level 16, State 2, Line 3
A ...
- 51
2
votes
1
answer
278
views
SSRS ReportServer_XXX.log is giving incorrect CPU count
I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
- 121
2
votes
0
answers
129
views
Attaching Existing Oracle Home to fresh Windows Install
I have a client who recently was forced to reformat and reinstall Windows Server 2008 R2. Their ORACLE_HOME (Oracle 11g) and all of the data was located on a D: drive that was not reformatted. Can I ...
- 217
1
vote
0
answers
64
views
BCP to SQL Server DB seeing excessive waits
I have a process I built in Powershell which has been working flawlessly for years on a couple servers, but when I migrate it to new servers I see a lot of waits (ASYNC_NETWORK_IO) during BCP step ...
- 11
1
vote
0
answers
110
views
User Permissions for WAL files
I'm setting up replication on Postgres. (expect more questions later :-)
I'm putting the WAL files on the NAS so that both servers have access to the files.
The Postgres service is running as "...
- 111
1
vote
0
answers
234
views
Windows Suspending PostgreSQL Process
Scenario:
Customer’s system
VM running Windows Server Standard 2019, 16GB RAM, Intel Xeon Gold 5122 @ 3.6GHz (2 processors 4 virtual processors)
PostgreSQL starts and runs fine for 5 minutes - 2 ...
- 121
1
vote
1
answer
772
views
SQL Server 2017 AlwaysOn Failover Cluster issue
I have 2 Windows 2012R2 VM's running on Vmware ESXi 7 with VMDK's as the SQL disks.
I have a SQL 2017 AlwaysOn Cluster running on Server 2012R2.
there is no any running backup (SNAPSHOT)
PROD : 10....
- 1,078
1
vote
0
answers
74
views
Testing SQL connections with UDL file
I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
- 75
1
vote
1
answer
372
views
DBCC Check DB fails due to operating system error 665
We have a SQL Server 2017 Standard version where recently the CHECKDB is failing with the operating system error 665.
The fragmentation level of the disk drive is 0% as it is automatically ...
- 1,021
1
vote
0
answers
369
views
What are the available automatic failover solutions for MariaDB Master-Slave replication on Windows Server?
I am setting up a Master-Slave or Master-Master setup in MariaDB on two seperate servers running Windows Server. I also need to configure an automatic failover solution where client read requests gets ...
- 11
1
vote
0
answers
5k
views
"The client and server cannot communicate, because they do not possess a common algorithm" error
The full error message is:
System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: ...
- 427
1
vote
0
answers
861
views
SQL server availability group cannot access database after disabling sql service
I've completed this setup:
OS: Windows server 2016
Database: SQL Server 2017
2 node availability group configured with automatic failover on both nodes. Fileshare witness configured, both nodes ...
- 11
1
vote
0
answers
3k
views
What are the risks if you rename a server that hosts a named instance of SQL Server (2005) and skip updating the system metadata?
My apologies as this is the last SQL 2005 instance we have and it's pretty urgent or I wouldn't go through all this trouble asking.
Questions
What is the risk to leave things as they currently are, ...
- 41
1
vote
0
answers
836
views
Is it possible to reset SA password without stopping SQL Server Service?
I lost a password for sa account. Now I want to reset SA password and at the same time not to restart SQL Server Service or going into single-user mode. I would like to mention that I am windows ...
- 1,243
1
vote
0
answers
875
views
Win 2019 + SQL Server 2014 slowly locks up the server
We have a 2019 + 2014 sql server box that was running fine for a few days after we first stood it up on Ec2.
After a week I removed a temp drive (EBS) that we had initially used to load up the ...
1
vote
1
answer
65
views
One instance, four clients, one is slow
We have a small office setup with one Windows Server 2012 running SQL Server 2016 Express. The database is hosting files for our accountant software. This is a multi module software that runs ...
- 11
1
vote
0
answers
180
views
Domain Independent Cluster on AWS
I am trying to work out whether it's possible to create a Domain Independent Workgroup Cluster in AWS (on Windows Server 2016 for use with SQL 2017 Availability Groups). This environment also has no ...
- 53
1
vote
0
answers
272
views
Waiting Tasks on Mirror
I just migrated my primary's synchronous mirror to a new server and I've noticed that there are 150 to 230 waiting tasks on the mirrored instance (based on the activity monitor.) I don't recall if ...
- 1,761
1
vote
0
answers
38
views
Can I remove some of our disk allocation?
I've started work for a new company who are using Azure for their SQL Databases.
As one of my first tasks, they've asked me if they have too much storage (expensive storage), and would like to remove ...
- 71
1
vote
0
answers
1k
views
clussvc.exe consuming high cpu
We have a 4 node cluster running 2 SQL Failover Instances.
Windows 2012 Standard & SQL 2014
Microsoft Failover Cluster Service has been consitently between 25 - 30 % CPU. This is happening on 2 ...
1
vote
0
answers
78
views
How to set processes parameter in oracle 11g Windows in accordance with RAM in the server
Could anyone explain me whether there is any limitation in setting processes parameter in Oracle 11gr2 and how to set sga_target according to this.
Right now I have set the processes to 4000 and I ...
1
vote
0
answers
879
views
Why is SQL Server unable to access partitions stored on UNC paths?
I have a database with its primary file and log file stored locally. One table is split into 101 partitions which are stored on a Windows share on another server accessed by a UNC path. Each partition ...
- 1,134
1
vote
0
answers
32
views
How to handle large sized oracle databases in a windows server
My Production database is having 188 GB size. The server handling the db is having C Drive with a space of 250 GB.
My database is growing rapidly.I don't think this database is having much size ...
1
vote
0
answers
2k
views
Primary Server is "Resolving state" & Quorum node is in "failed" state
I would like to say that in my environment I have a 2 node in WSFC with the nodes
SQLServer-01 (Primary Server)
SQLServer-02 (Secondary Server)
And for third vote in cluster also One (File share ...
- 6,357
1
vote
0
answers
262
views
Can Oracle Database run on Microsoft Nano Server?
Microsoft Nano Server is attractive alternative to a heavier installation of Microsoft Windows Server 2016. Can Oracle Database be prepared to run this way?
- 615
1
vote
0
answers
657
views
Unable to start the Integration services for SQL server 2012
Suddenly we are facing some errors in starting up the integration services.
From event viewer and ssms when we tried connecting we get below error message
The SQL Server Integration Services 11.0 ...
- 2,169
1
vote
0
answers
27
views
Database service likely hang at some moments
Our team adopted MariaDB to replace SQL Server 2008 last year end. There is no issue for DB service hanging, and last week and yesterday I met 2 services hang issues. The following are configurations ...
- 61
1
vote
0
answers
2k
views
SQL Server not Using Allocated Memory
I have a weird problem I am struggling to troubleshoot.
I have a development server with 18GB RAM and two SQL Server 2012 SP3 instances with @@version output:
Microsoft SQL Server 2012 (SP3) (...
- 1,774
1
vote
0
answers
3k
views
Running Oracle DataPatch after OPatch
After patching an Oracle 12c database (Windows environment, container DB and 3 PDBs), is there any way to predict or estimate how long it will take to run DataPatch utility? Or to see how far along it ...
- 2,183
1
vote
0
answers
2k
views
Can I use Foreign Data Wrapper for SQL Server in Windows Server 2012?
I use PostgreSQL and SQL Server. I want to get SQL Server data in PostgreSQL.
I found PostgreSQL Foreign Data Wrapper. There are installation packs for CentOS and Ubuntu. However, I want to use FDW ...
- 11
1
vote
0
answers
159
views
Replicate existing database live
New to db admin here and I have a question. My setup is Windows Server 2012 R2, MySQL, using MySQL Workbench.
I have Database A on Server A, how can I make an exact clone of this database (Database B)...
- 231
1
vote
0
answers
100
views
How can I prevent SMB digital signing from killing SSIS performance?
My company recently turned on SMB digital signing on the Windows 2012 r2 server that runs SSIS. This has had a severe impact on data transfer performance. The security team did this and I can't get ...
- 529
1
vote
0
answers
205
views
What is the best way to clear couple of tables each night at specific hour in Postgres SQL?
I need to clear couple of tables every night on my db so in the morning they will be empty and ready to use for the end users.
I already wrote the query to truncate them but I'm not sure what is the ...
- 121
1
vote
0
answers
622
views
How to check particular SQL UserID windows permissions in MS SQL SERVER 2012?
I would like to say as per my network system administrative security of windows Server 2012 R2. I am unable to start SQL Server agent. As per in MS SQL Server 2012 , i have "sysadmin" & "public" ...
- 6,357