Questions tagged [windows-server-2008-r2]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
23 views

MySQL 8.0 Replication filters lost between restarts

I don't know if I fell on a bug or a feature, I read the documentation several times but haven't found the information. I have two MySQL servers, both on 8.0.15 and hosted on a Windows Server (x64). ...
0
votes
1answer
133 views

How to find how many number of transactions are happening in SQL Server/SQL Server database in a day?

I have to migrate my SQL Server on a particular public cloud, which is charging/licensing on the basis of number of transactions happening on the SQL Server. I am aware of the Performance Counters ...
0
votes
1answer
52 views

error writing input to commandERROR: Invalid username and/or password

This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted. ~~~End Step Output/Error Log~~~ Error Log:...
0
votes
0answers
99 views

postgresql 11 & windows server 2008

I plan to upgrade a PostgreSQL/PostGIS server from 9.6 to 11. The server is running on windows server 2008 R2 64. According to the doc, PostgreSQL 11 and Windows Server 2008 has not be tested. So ...
3
votes
2answers
333 views

SQL Server Agent Services not Coming Up

After the Windows Server 2008R2 was restarted after some planned downtime, the SQL Server Agent Service is not getting started. There are multiple SQL Server named instances and Agent Services of non ...
0
votes
1answer
55 views

Copying Oracle datafiles to a system clone

We have an Oracle 11G R2 on Windows 2008 R2. One night, a windows update package caused our Oracle Instance to be down (no way to connect using sqlplus. we believe it's a network, NIC issue.). We ...
3
votes
2answers
1k views

Why should I install both 32 and 64 bits Oracle provider for the same machine?

I needed to read an Oracle DB from SQL Server, so I had to install the Oracle provider (ORAOLEDB.Oracle). My machine: System: Windows Server R2 2008 Enterprise, 64 bits (SP1). RDMS: Microsoft SQL ...
33
votes
4answers
9k 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. ...
2
votes
1answer
2k views

How can I troubleshoot issues with dynamic registration?

For testing I have been trying to install Oracle 11g on a test system with a single database several times with the aid of snapshots. This most recent iteration I have been having issues getting the ...
0
votes
1answer
98 views

EMCA insists that it cannot connect to the service

Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first ...
0
votes
1answer
282 views

Known Good SQL Logins Failing (Error 18456) Accompanied by “Unable to Reuse a Session” (Error 18056)

I am losing my patience with this problem. I did see a couple of other questions here that are similar, but I've already looked at the fix actions that resolved their issues and they did not apply ...
7
votes
1answer
9k views

'The computer must be trusted for delegation and the current user account must…' error when trying to connect to sql server 2008

Our admin set up a brand new Windows 2012 R2 server with Visual Studio 2015. When I try to connect to an existing sql server 2008 database (running on a windows 2008 r2 server) from Visual Studio, ...
2
votes
1answer
843 views

SSIS data flow task failed for no reason [closed]

An SSIS package keeps failing for no reason. There are only three lookup transform components in the package (besides the source and output component), two running in partial cache mode and the other ...
0
votes
1answer
10k views

Microsoft SQL Server, Error: 10054

The SQL Server Management Studio is working just fine when we RDP into the server and try to perform any sa privileges.However, when we use it from our local machines it is throwing the errors ...
0
votes
1answer
2k views

Cannot Generate SSPI Context when connecting to the remote Computer

I am connecting to Windows Server 2008 R2 which has SQL server 2005 installed via ODBC from a client machine. Recently I started getting this error Cannot generate SSPI Context. I have gone ...
0
votes
1answer
3k views

SQL Server 2012 Support on Windows Server 2008 R2

Is it possible to install Microsoft SQL Server 2012 on Windows Server 2008 R2 Datacenter? On the Windows Server 2008 R2 Datacenter - I have .Net Framework 3.5.1 Features(.Net Framework 3.5.1) and I ...
0
votes
1answer
20 views

Which full backup will be differential one based on?

I wanted to perform a differential backup of a DB in SQL Server 2008. I currently have a .bak file with a full backup and I want to add this new one in it. Will be the differential backup based on ...
3
votes
2answers
4k views

MySql service on Windows won't start after changing datadir

Tried to change the data directory for a default Windows installation of MySQL. Here's the steps I've taken. Stopped the MySql service. Located the data directory of MySql and moved it to another ...
0
votes
0answers
41 views

Memory Consumption [duplicate]

In one of our PROD Servers... The Total Physical RAM is 128GB The Total RAM I assigned for SQL Server is 122GB. When I checked the SQL Server there were no Open Transactions, No Blockings....But ...
2
votes
1answer
1k views

Sql Server Brute Force Attack [closed]

I am running MS Sql Server 2008 on a Windows Server 2008 box. I noticed a slow down and random moments where my Sql instance failed to connect, and looking at the event log showed repeated (1-2 times ...
3
votes
1answer
218 views

db_owner does not have access to Windows folders [duplicate]

This is MSSQL Server 2008 R2 running on Windows Server 2008 Enterprise. Service Instance is running as 'Network Service'. I have two logins, UserA and UserB. UserA is a sysadmin. UserB is a db_owner ...
0
votes
1answer
830 views

Oracle patch conflict [closed]

I'm attempting to apply patch 23530402 to Oracle 11.2.0.4 with OPatch 11.2.0.3.15 on a 64-bit Windows 2008 server. Our Tenable security software indicates this is one of two patches that must be ...
4
votes
2answers
617 views

Why is the processor % different in Activity Monitor vs Resource Monitor?

I'm tracking a significant difference between the processor % reported in the Activity Monitor for SQL Server vs the total processor % used in the Resource Monitor. I'm seeing about a 50% difference ...
0
votes
1answer
947 views

What is the language of my SQL Server setup files?

Im trying to install SQL Server in my Windows Server in english . But got this error. I look for a solution and say I have to change the setting on Control Panel to match my media. The problem is ...
0
votes
1answer
3k views

Missing options in Feature Selection when installing SQL Server 2016 on existing server

I have a Windows 2008R2 64-bits server that already has 2 instances of SQL Server 2008R2 installed, and working fine. I want to add a new instance, but for SQL Server 2016, while keeping the existing ...
0
votes
1answer
497 views

How to create a Windows user suitable for installing db2 server with extended security?

I'm trying to install db2 10.5 on Windows Server 2008 not as built-in "Administrator", but as another local user, but it fails to create instance with the symptoms similar to http://www-01.ibm.com/...
0
votes
1answer
38 views

I created an index approx 5gb in size but the file system doesn't show any difference in free space

On a table with many millions of rows and two existing indexes (one clustered and one non-clustered primary key index) I created a third non-clustered non-unique index. Before creating this index, ...
0
votes
1answer
2k views

How to enable TLS1.2 for port 1433

I have received vulnerability on Microsoft SQL server 2008 (RTM) [high] [1433/tcp/mssql] TLS Version 1.2 Protocol Not Enabled TLS v1.2 is not enabled on this port. Already enabled TLS 1.2 on OS ...
0
votes
1answer
987 views

SQL Server 2012 on a Windows 2008 R2 cluster, would like to upgrade Windows to 2012 R2

I need someone to help validate a strategy. I have a pair of Windows 2008 R2 server in a active/passive failover cluster with SQL Server 2012 installed. I would like to upgrade the Windows OS to ...
2
votes
1answer
1k views

Auto start pgAgent

When my windows server 2008 start, both services postgres and pgAgent start because they are automatic. But if my db is frozen and I need to restart the postgres service, the pgAgent is also stoped, ...
3
votes
1answer
10k views

Can't install Microsoft SQL Server 2016 Release Candidate 3 (RC3) on Windows Server 2008 R2

I am attempting to install Microsoft SQL Server 2016 Release Candidate 3 (RC3) on Windows Server 2008 R2. I have removed all other versions of SQL Server, and removed VS 2015 Community and all it's ...
0
votes
1answer
645 views

SQL 2012 Availability Group issue - The core cluster resources do not move when we initiate AG fail-over

I have a Windows 2012R2 cluster with two nodes and a File Share quorum. I am running SQL 2012 SP2 and I have configured a test AG with a dummy database. When I fail-over the AG, the Availability ...
8
votes
1answer
3k views

Should I disable HyperThreading

BACKGROUND I've recently been looking into some fairly high CXPacket wait times recently which has had me using SQL Sentry to monitor processor activity pretty closely. One thing that I've noticed as ...
1
vote
1answer
725 views

Issues installing patches on SQLserver 2008

There are multiple issues with a server I manage, we cannot start management studio on it and when we try to install patches to SQL Server the setup never shows up. I run the patch as an ...
2
votes
1answer
4k views

Much slower SQL application performance after upgrading from Windows Server 2008 R2 to Windows Server 2012 R2

Has anyone seen much slower SQL Server application performance when upgrading from Windows Server 2008 R2 to Windows Server 2012 R2? We recently did a side-by-side upgrade of an important server ...
2
votes
1answer
480 views

DB2 doesn't start after change db2 hostname

After changing the hostname of my db2 server, the db2 services won't start anymore. After reading the notes on how to rename the db2 hostname I understand what went wrong, some things should have ...
2
votes
0answers
2k 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
2answers
2k views

Failed to update SQL Server 2008 R2 RTM to SP3

I'm trying to update SQL Server 2008 R2 RTM to SP3 by running SQLServer2008R2SP3-KB2979597-x64-ENU.exe, on Windowns Server 2008 R2 SP1. It failed with the following error in the log, 2015-11-26 10:...
0
votes
1answer
780 views

Where to look for clues as to why SQL Server become unresponsive/crashed?

Recently an SQLExpress instance suddenly become unresponsive/crashed whilst I was mid-dialog (SSMS transaction log backup), which froze with an hourglass and the dialog was unusable. No other ...
0
votes
1answer
2k views

SQL Server does not failback to the primary node

We are running SQL Server 2008 R2 on a Windows Server 2008 R2 two-node cluster. My choice of machine is primary, and the secondary is just a low-end machine for contingency planing. We had a ...
2
votes
2answers
43 views

Replication fails exactly after a week

We are application developers trying to decode why replication is failing. It fails every week on the same day pretty much same time. This has been happening for about a month now and our vendors ...
3
votes
2answers
70 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
2answers
894 views

Installing SQL Server Integration Services on Server Core

I have Windows Server 2008 R2 Core on virtual machine and want to install SQL Server Integration Services. On the D:/ drive SQL Server 2014 Enterprise .iso is mount. I am reading a book where it is ...
0
votes
1answer
313 views

How to Set up SSRS Web Services to run under another port than 80?

What steps do I have to pace to run Web Service URL and, Report Manager URL, under another port rather than 80? (DBMS is SQL Server 2008R2 and OS is WIn Server 2008R2).
0
votes
2answers
140 views

Identical SQL Server databases hosted in the same physical DB server

We have hosted similar SQL Server 2014 databases TestDB and TESTDB_Copy on the same physical server. The two databases are almost the same and there may be minor differences in the number of records (...
5
votes
2answers
173 views

Virtualized SQL Server Memory Oddity

I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager*, sqlserver.exe is ...
0
votes
2answers
1k views

How to add deleted user in sql server? [duplicate]

I have set up sql server 2008 in windows server 2008 r2 and it works fine. However, I have deleted the my user from logins in the sql server accidentally and now I cannot find a way to log in to the ...
2
votes
1answer
281 views

postgresql on windows won't install with data and executables on different disks

I am trying to install postgresql 9.4.4 on a windows 2008 rc2 machine that has 2 HDs. The first HD is, in theory, used only for executables/code/etc while the second one, being faster, should be used ...
7
votes
1answer
206 views

Failover timeout problem

I'm looking for an additional bit of help with regard to some problems I'm looking at for one of my company's clients. Basically I have two related problems with regard to a 2-node active/active ...
1
vote
1answer
73 views

Quorum disk conundrum

I'm having a problem with a 2-node active-active cluster which has been failing over lately but not bringing resources back online. We've had a Microsoft engineer look at it and, among other things, ...