1
vote
0answers
33 views

Why does RDP freeze on Windows Server 2008 R2 in a virtual machine during high load?

We have noticed a problem where remote desktop sessions to a server will freeze when the server has high CPU load. Environment: VMWare ESX 4.0u1. Guest OS is Windows Server 2008 R2 (this is the ...
0
votes
1answer
531 views

How can I get SeSecurityPrivilege enabled?

I'm trying to install a hotfix for SQL Server 2008 and failing on the Rule Check with "Setup account privileges" failed. I am running SQL Server 2008 Standard on Windows Server 2008 R2. Searching on ...
3
votes
1answer
951 views

Windows 2008 R2 services not working

EDIT I spawned the Windows events logging service won't start issue to a separate question here I have a strange problem: SQLAGENT won't start Windows events logging service won't start Today I ...
2
votes
2answers
852 views

Windows Server 2003 r2 vs 2008 r2 - Performance for SQL Server [closed]

First off, I'm not a sys admin, just a programmer frustrated by poor server performance… We’re currently running a VM (I believe the host is Win Server 2008) on a newer E5-2650 CPU, 24 GB RAM, at ...
0
votes
1answer
114 views

How to resolve SSPI context error without changing Service Account from MSSQL

There is a issue while connecting from new Windows 8.1 Clients to SQL Server 2008 running on Windows Server 2008 R2. The SQL Service running under account Domain\mssqlservice on a machine thats works ...
1
vote
3answers
60 views

Restore MS SQL 2008 Database from files

is it possible to restore a MSSQL server by copying its directory/data files? I have a damaged hard disk and was able to salvage the C:\Program Files (x86)\SQL Server 2008\MSSQL\MSSQL10.MYDATABASE ...
0
votes
0answers
76 views

SRSS Client Print Module must be downloaded every use

I am currently having an issue with SQL Server Reporting Services. Everytime a user clicks the print button for the report, the user must install the ActiveX client print module. The issue is that our ...
0
votes
1answer
110 views

SQL Port 1433 needed in SQL Server2008 IP Field for remote connection

I just installed SQL Server 2008 on my server. I do it often enough to forget what to do so I read through a couple of MS installation instructions. I installed with no issues. I tried to remote ...
1
vote
0answers
44 views

Failover cluster wouldn't fail over

I have an active-passive failover cluster on 2008r2 with SQL server 2008 clustered on it. I go to fail it over for maintenance and the resource failed to come online on either node. Once I rebooted ...
0
votes
1answer
137 views

Best Practices Analyzer for Microsoft Dynamics AX 2009

We recently uncovered a potential issue with our Dynamics AX setup whereby Receive Side Scaling (RSS) was not enabled on our AOS servers, which we believe is limiting their performance (currently ...
0
votes
1answer
150 views

opening firewall 1433 port to IP address that require a direct connection

We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2. New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be ...
1
vote
0answers
284 views

MS SQL 2008 R2 64bit will not use more than 1.5GB in task manager

I have the latest MS SQL 2008 R2 installed on Windows Server 2008 R2 64-bit. The SQL server process never surpasses 1.5GB in the task manager resulting in heavy disk usage. I have solve this problem ...
0
votes
1answer
53 views

What are the things to look out for when adding other domain user to your IIS?

I have a Windows Server 2008 R2 called Jack11 that joined a domain called Watson.org. It has IIS 7 installed. From my understanding, we need to add the following into the web.config file ...
0
votes
1answer
29 views

Login Failure issue - SQL Server 2008 SETUP on Windows Server 2008

Hi I am trying to upgrade Edition on SQL server 2008 on Windows Server 2008 and while the Setup it checks all the system requirements and When in the end i click Upgrade It gives me error that ...
0
votes
0answers
396 views

SQL 2008 Standard R2 - MSA vs Virtual Accounts vs Domain Accounts?

Just wondering if someone could point me to the right direction. Im about to implement an SQL server on the DC machine. I know that it is not recommended to run the SQL server on the DC but that is ...
0
votes
1answer
182 views

Is it possible to batch restore backups and remove users from databases in MSSQL 2008?

We're having to do an emergency migration of all of our MSSQL databases from a dying box to a new shiny instance of SQL2008. Unfortunately, we're having to do it by restoring from nightly backups ...
0
votes
1answer
262 views

Problems Installing SQL Server 2008 on Windows Server 2008 R2 Standard SP1

I'm attempting to install SQL Server 2008 on Windows Server 2008 R2 Standard with SP1, and am failing the "Operating system supported for edition" operation in the Installation Rules portion of the ...
2
votes
1answer
968 views

What the best way to achieve RPO of zero and lowest possible RTO (less than 15 minutes) with SQL 2008 R2?

We are running a payments (EFT transaction processing) application which is processing high volumes of transactions 24/7 and are currently investigating a better way of doing DB replication to our ...
0
votes
1answer
112 views

Data transfer between servers extremely slow

I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same ...
2
votes
1answer
1k views

Being Flooded with Security Event ID 4793 - Windows 2008 R2

I have a SQL server that is a domain member running Windows 2008 R2. It is a cluster node in a failover cluster. The security event log is getting flooded with these: Log Name: Security ...
1
vote
2answers
1k views

How can I determine what is sending so much data from my Windows Server running SQL Server?

I have a SQL Server that is continuously sending data out the network interface. The data that is being sent is too high; about 7MB per second. I have scanned the server with anti-virus but haven't ...
0
votes
2answers
134 views

New server: use for SQL Server or Windows (Web)? [closed]

I picked up a new Dell R410 2.8 Ghz 12M cache 32 GB Ram RAID-1/RAID-1 for a good year-end deal. It was purchased mainly to replace my Dell PowerEdge 2850 which is my main WEB server. I run Windows ...
0
votes
4answers
2k views

Does sql server standard come packaged with windows server 2008 r2?

Does sql server standard come packaged with windows server 2008 r2?
2
votes
1answer
66 views

Database unusable whist doing a database restore (SQL Server 2008 R2)

I was asked to create a database from a backup for reporting and whilst transferring the file from backup to a disk on the server the database became unusable. Then again whist running the restore ...
3
votes
3answers
390 views

SQL Server 2008 Workgroup Edition on virtual server with no swapping

I have rented a virtual server with 4 GB memory from Hosteurope, including a license for SQL Server 2008 Workgroup Edition. It works alright and is plenty fast, but whenever I put some load on it, it ...
2
votes
1answer
83 views

Install Different SharePoint Servers using Single Database Server

I have a database server in my network running SQL 2008 R2. I have SharePoint 2010 installed on a separate server and using the above server for database storage. I want to install a new Project ...
0
votes
4answers
501 views

Windows Server 2008 R2 secure enough for internet without 3rd party (hardware) firewall

I need to setup a Windows2008 Server R2 incl. SQL Server and IIS. The server is as far as I know directly connected to the internet. My question is, is Windows 2008 R2 Server secure enough for this ...
0
votes
1answer
75 views

Remote connect to SQL Server 2008

I have a problem connecting with a remote Microsoft SQL Server 2008 I have tried this: How to enable remote connections for SQL Server 2008? so the remote connection checkbox is checked at the ...
1
vote
2answers
165 views

Xen virtualized Server 2K8R2 w/ SQL 2K8 becomming unresponsive

About a year ago, we virtualized most of our small business Windows and Linux infrastructure, which included starting a fresh (not P2V) Server 2008 R2 VM. This performed acceptably until a few weeks ...
2
votes
1answer
4k views

SQL2K8 Backups over an NFS mounted SAN

We have a SQL2K8 server with a 100GB+ database that mostly stores image BLOBS and it fails to backup to our SAN that is connected over NFS. The SQL2K8 server runs off our VMWare Host and it losses ...
1
vote
1answer
1k views

SQL Server 2008 second instance times out when logging in — but only the first time?

This is a strange one that has plagued me for a while now. When logging in to the second instance of SQL Server 2008 on one of our database servers, we get a timeout error: Cannot connect to ...
1
vote
0answers
1k views

Unable to authenticate proxy when starting SQL snapshot agent

I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied, I have restored a database from an old image (SQL 2005) and am trying to get web-sync ...
1
vote
1answer
208 views

Unable to Install SQL Server 2008 on Win Server 2008 R2 Datacenter

I have been trying for the past three days to install SQL Server 2008 with SharePoint integrated mode in VMware Player, however I keep getting the following error: Reporting Services in SharePoint ...
4
votes
3answers
741 views

Max and Min Memory Setting

One failover cluster has 2 nodes with 64GB RAM each: - Node A and Node B. Node A run 2 SQL instances (SQL1 and SQL2). Node B runs 1 SQL instance (SQL3). SQL1 has a max server setting of 30,720MB ...
1
vote
4answers
2k views

SQL Server pegging CPU but only using 2GB Ram?

I know nothing about SQL I'm going to put that out there. Our dev people have said this is an OS problem. Can you help me figure out where to start to determine if this is an OS issue? SQL isn't ...
3
votes
2answers
2k views

Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?

Related Perfmon: which counter identifies that threads are waiting? but sadly abandoned by the asker Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and ...
2
votes
1answer
186 views

What's the best use of 4 nics for Hyper-V?

I'm running several Dell R710's, each of which is outfitted with 4 x Broadcom BCM5709C nics. Two of these R710's are running Hyper-V and a third is running SQL Server 2008, each running Windows ...
0
votes
2answers
269 views

MVC2 Application Performance on Windows Server 2008 R2 with IIS7.5

I originally posted this on StackOverflow but I feel as though the problem lies with the hardware / OS configuration. I'm hoping that someone here has had a similar experience and can offer some ...
0
votes
1answer
136 views

How much and why may a windows domain controller affect performance of sql-server?

Excuse me by asking somehow vague. Please let me be more precise: can anybody please explain me the networktraffic between sql-server and domain-controller on a installation following microsoft ...
0
votes
1answer
138 views

How much and why may a windows domain controller affect performance of sql-server? [closed]

I assume a state-of-the-art installation therefore nothing weird like DC and SQL-Server on the same machine. Think about an installation following the commendations of microsft and all the recommended ...
1
vote
1answer
2k views

SQL Server 2008 R2 Quiet Installation Failure

I've downloaded the SQL Server 2008 R2 software from Microsoft and am working on scripting a silent installation. I'm getting the following errors (and the duplicate paste job is not an accident, ...
3
votes
2answers
230 views

Does anyone know where I can find “proof” that SQL's Fiber mode is barely faster than regular thread mode on Win 2008 R2

I remember seeing a PDC presentation on the Windows Kernel regarding Threads vs Fibers and in it Mark R. mentioned that this caused SQL's Thread mode to run almost as fast as Fiber mode, but with ...
0
votes
1answer
58 views

is it possible to run a different version of sql server trial once you've already run one?

e.g. Have already installed trial version of SQL Server Enterprise Edition 2008 R2, is it now possible to switch to a trial version of the Developer edition?
6
votes
6answers
27k views

Can't connect to SQL Server 2008R2 on Windows Server 2008R2

I reinstall a server Windows Server 2008 R2, I installed SQL Server 2008 R2 no problem during installation. When I try to connect with "Microsoft SQL Management Studio" via sa account or Windows ...
3
votes
2answers
216 views

Should SQL Server 2008 only be run on Server 2008 R2 (64 bit)?

Today I was told that SQL Server 2008 is supposed to be run on Server 2008 R2 (64 bit). Is this true? And if so, can anyone explain why? Our development instances are running on 32-bit systems. I ...
0
votes
1answer
564 views

Raid Caching configuration suggestions

I'm wondering if there's the optimal Cache setting for the following Raid controllers and raid setups. (OS: windows 2008 R2, App: II7, DB: SQL Server 2008 R2 Enterprise) PERC 6/i: (The default ...
0
votes
1answer
591 views

Error Configuring Reporting Services on Windows Server 2008 R2

I'm installing a TFS2010 with Reporting Services (SQL Server 2008) but I'm getting an error, below are the details and steps I did: I'm installing with a domain account who is also a local ...
3
votes
6answers
1k views

SQL Clustering on Hyper V - is a cluster within a cluster a benefit

This is a re-hash of a question I asked a while back - after a consultant has come in firing ideas in to other teams in the department the whole issue has been raised again hence I'm looking for more ...
0
votes
1answer
427 views

SQL 2008 SP1 crashing almost daily

almost every day our new DB crashes. It is virtual server residing on same hardware as 5 other servers, two of them beeing identical MS SQL2008sp1 and two Oracle 11g's so I can pretty much rule out ...
1
vote
2answers
2k views

Intermittent timeout when connecting to Sql Server, what do I look for?

Sql Server 2008 Standard 64bit on Windows Server 2008 R2 virtual machine hosted on a Hyper-V server. I'm getting intermittent timeouts when connecting to the server. This happens for both windows ...