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.

106 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
54 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 ...
3
votes
0answers
71 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 ...
3
votes
0answers
6k 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 ...
3
votes
0answers
481 views

Error: “Computer X is Joined to a cluster” when creating a new cluster

I am trying to create a New Cluster for Always On Availability Groups. On Failover Cluster Manager when I try to add the cluster nodes I get the following error: Computer X is joined to a cluster. ...
3
votes
0answers
58 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 ...
3
votes
0answers
584 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 ...
3
votes
0answers
122 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 ...
3
votes
1answer
405 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 , ...
3
votes
2answers
74 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 ...
2
votes
0answers
57 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: ...
2
votes
0answers
111 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-...
2
votes
0answers
84 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 ...
2
votes
0answers
14 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 ...
2
votes
1answer
276 views

GSSAPI on MariaDB

I'm using Maria 10.2.13 on Windows Server 2012 and I want to use GSSAPI authentication with it so that we can continue using windows auth. I have followed this tutorial: https://mariadb.com/kb/en/...
2
votes
1answer
261 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 ...
2
votes
0answers
39 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 ...
2
votes
0answers
726 views

SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?

We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description: We have SQL Server 2014 (and 2016) ...
2
votes
0answers
514 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:...
2
votes
0answers
391 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 ...
2
votes
0answers
508 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 ...
2
votes
1answer
3k views

SQL Server 2012 Installation Error on Windows 2008 Server

I am facing an error while trying to install SQL Server 2012 EXPRESS ADVANCED EDITION(32bit) on Windows Server 2008 Enterprise(64bit). After passing Rule Check, at install updates section, error ...
2
votes
1answer
258 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 ...
2
votes
0answers
124 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 ...
1
vote
0answers
38 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 ...
1
vote
0answers
322 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, ...
1
vote
0answers
181 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
vote
0answers
160 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
1answer
43 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 ...
1
vote
0answers
152 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 ...
1
vote
0answers
133 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
vote
0answers
29 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 ...
1
vote
0answers
582 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
0answers
70 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
0answers
395 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
vote
0answers
31 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
0answers
870 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 ...
1
vote
0answers
222 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?
1
vote
0answers
406 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 ...
1
vote
1answer
458 views

MariaDB on Windows Server 2012 R2 - out of memory

I have two servers, one with Windows Small Business Server 2008 and the other runs Windows Server 2012 R2. The servers have running multi master replication. Both uses MariaDB 10.2.6. On the old 2008 ...
1
vote
0answers
21 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 ...
1
vote
0answers
865 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
vote
0answers
2k 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 ...
1
vote
2answers
5k views

frm-92100:your connection to the server was interrupted

frm-92100: error I use my using internet explorer & JInitiator 1.3.1.13 using oracle 11g and dev9i windows server 2008 R2. The app was running fine for last 2 years but suddenly this happen. I ...
1
vote
0answers
1k 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 ...
1
vote
0answers
147 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)...
1
vote
1answer
36 views

Move database from windows server 2003 to windows 7/8?

I am working with this company currently running their SQL Express database in a virtualized Windows Server 2003. What would you experts say about replacing that for a virtualized slimmed-down ...
1
vote
0answers
72 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 ...
1
vote
0answers
100 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 ...
1
vote
0answers
567 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" ...
1
vote
0answers
125 views

mirroring on sql server 2012 on different windows server 2012

I have 2 servers *.203 and *.205 I have sql server 2012 on each of them I tried to make mirroring between them every thing goes successfuly but when I tried to start mirroring it gives me ...