FAQ Database Discussion Community


Missing Microsoft Excel as option in SQL Server data import tool

sql-server-2012,64bit,excel-2007,import-from-excel,windows-server-2012-r2
I'm running SQL Server 2012 on a 64bit Windows Server 2012 R2. I don't have MS Office installed. I now notice that when I start Start->Program Files->Microsoft SQL Server 2012->Import and Export Data (64-bit) the MS Excel file option is missing from the datasource dropdown. How can I get that...

Flask Hangs on request

python,flask,windows-server-2012-r2
Recently I'm developing a Flask website/api app to Windows Server and saw some weird issue going on. When someone make a request to a url, occasionally(like 3-4 out of 10 times) it will hang. All I need to do to make that request come through is going to the command...

Bonobo Git Server Configruation: HTTP Error 500.19 - Internal Server Error at line 71

iis,windows-server,windows-server-2012-r2,iis-8.5,bonobo
I have tried to configure Bonobo Git Server. I have followed the included instructions, and after trying to visit the server for the first time, I get the following error: There is a similar question; however, it gives an error at one line prior and the solution the author answered...

Pandas MemoryError on server with more Memory

python,memory,pandas,deep-copy,windows-server-2012-r2
I have a method working with dataframes on pandas that is behaving differently on 2 different systems. While trying to load and work with a particular source csv I am getting Memory errors on a Windows Server machine with 16gb of ram but not on my local computer with only...

Windows Server 2012 R2 - High CPU / Memory Usage Causes Task Scheduler to Not Run?

windows,scheduled-tasks,windows-server-2012,windows-server-2012-r2
I have a task that runs every minute on my Windows Server 2012 R2 machine. This task gathers the system usage stats for my machine and sends it to Amazon CloudWatch. I've noticed that during time periods of high CPU and memory usage, my stats aren't logged in Cloudwatch. I've...

LogParser SQL Server driver windows 2012 x64

sql-server,odbc,windows-server-2012-r2,logparser
I have a logparser one liner which outputs in a SQL Server database. I had a conversion problem between logparser timestamp and SQL Server date(7) types. I resolved this issue by specifying the driver -driver "sql server native client 10.0" Here is the whole oneliner : LogParser "select to_date(to_timestamp('2015-03-13','yyyy-MM-dd')) AS...

Network Load Balance

load-balancing,windows-server-2012-r2,nlb
I'm having an issue while accessing an NLB cluster from node that is part of the cluster. Here is the scenario. I have created a NLB clusters on IP 10.10.10.110\255.0.0.0 [Protocol: both with filtering Single Host] in unicast mode having three nodes 10.10.10.109\255.0.0.0 -> Priority 2 10.10.10.134\255.0.0.0 -> Priority 1...

HTTP Patch Verb not working on windows server 2012 r2

asp.net,asp.net-web-api,windows-server-2012-r2,iis-8.5,http-patch
I'm working on single page application which consumes WebApi for data manipulation. My site was hosted on Windows Server 2008 R2 (IIS 7.5.7600.16385) and working fine, however after migration to Windows Server 2012 R2 (IIS 8.5.9600.16384) HTTP PATCH VERBS are not working, api call returns with status code 400 "Bad...

How to access softwares installed by local user in domain user account

dns,active-directory,user-accounts,windows-server-2012-r2
I have installed a lot of application and utility software on my laptop using my local windows 8.1 account. recently i have joined a company where i got a domain account, when i joined the company domain and logged in using domain account i couldn't find most of my application...

Windows server 2012 sign out or disconnect?

windows-server-2012-r2
I am connected with RDP on a remote server. I just want to leave and I have two options: 1) Sign out 2) Disconnect What is the difference between these two?...

ASP.NET MVC Cache is clearing itself

c#,asp.net-mvc-4,caching,windows-server-2012-r2,iis-8.5
I have a ASP.NET MVC 4 application which is running on a Windows 2012 R2 with IIS 8.5 machine. There is a wierd behavior which I cannot figure it out. The cache seems is clearing itself. By cache, I mean MemoryCache.Default, HttpContext.Current.Cache, and also OutputCache. I'm googling the issue for...

for IIS, should i use Win7 or Server 2012r2?

windows-7,iis-7,iis-7.5,windows-server-2012-r2
Ill need to set up a test IIS. From a rapid research, ive found that Win7 and Server 2012r2 are pretty much offering the same (for IIS purposes). Major difference is supported RAM and parallel RDP sessions. Rather than that, relying on the fact i need IIS, which one is...

Embedded Browser Downloads on Local Machine but not on Windows Server c#

c#,winforms,webbrowser-control,quickbooks-online,windows-server-2012-r2
I'm trying to automate some functions on a web page (download an Excel document from QuickBooks online). I've got the script working fabulously on my local development machine (running Windows 8.1), but when I compiled it and ran it on our server (running Windows Server 2012 R2), it runs okay...

Sending messages to Service Bus for Windows Server via AMQP in a NLB cluster

amqp,servicebus,windows-server-2012-r2,nlb
When connecting to our load-balanced Service Bus instance via AMQP, we cannot send messages to a queue or topic. We have a Windows Server 2012 R2, running in a VM on Hyper-V. The server is part of a NLB cluster (which currently only contains this single host). On the server,...