0
votes
1answer
4k views

“There are currently no logon servers available to service the logon request” when trying to remote desktop to a VM after a power failure

I have SQL Server 2008 R2 running on a virtual machine (vmware, Windows Server 2008 R2). I was connected to the SQL Server from another virtual machine via SQL Server Management Studio, then a power ...
0
votes
1answer
168 views

HA Options for Windows Servers

We are looking at different options to allow us to stay up and running when our primary datacenter (DC1) goes down for any reason. What is the main difference in having a offsite server updated all ...
3
votes
2answers
266 views

Windows Failover and Load Balancing confusion

In the next couple months we are looking to add Failover and Load Balancing to our environment. We will have 2 servers that are Hyper V Hosts. We are looking to have an IIS App server and SQL ...
1
vote
2answers
338 views

SQL + Hyper-V cluster on the same hardware

We have 5 new Windows (2008 R2) servers on our disposal. We plan to configure them this way: 3 web servers running IIS and DFS-replication (load balanced) 2 SQL servers running SQL server 2008 R2 in ...
1
vote
1answer
420 views

SQL Server VSS Writer, Hyper-V and SQL Server 2008 backups

I have a virtual server running SQL Server 2008 R2. On the server I have configured two maintenance plans, one that takes differential backups every day except Saturday and a job that takes full ...
2
votes
2answers
801 views

SQL Cluster install on Hyper V options

I've been reading up on running a SQL Cluster in a Hyper V environment and there seems to be a couple of options: Install guest cluster on 2 VMs that are themselves part of a fail over cluster. ...
3
votes
4answers
373 views

Running SQL 2008 on a VM

We are pondering trying to set up a SQL 2008 instance inside a VM for a production environment. All our SQL instances use iSCSI over gigabit ethernet to talk to a NAS, as would this new instance. ...
2
votes
3answers
624 views

Server Performance Issue - Server 2008, SQL 2008 and Hyper-V [screenshots]

Im getting nasty performance on my server. It happens radmonly while accessing a website, but more often, right on the first time I load it. The server/webapp are still in dev, so I'm the only one ...
0
votes
1answer
112 views

Hyper-V Root and SQL Server 2008

I have a Server 2008 R2 server. Is it a good idea to make this a Hyper-V root partition, and install SQL Server 2008? What issues might I run in to?
-1
votes
1answer
289 views

BizTalk Server 2009 highly available configuration

I am setting up a BizTalk 2009 Server production environment and I wonder if this tutorial: http://msdn.microsoft.com/en-us/library/cc558972(BTS.10).aspx is still fairly accurate for an installation ...
3
votes
2answers
355 views

Selecting a Disk Subsystem for SQL 2008 / Hyper-V

I currently have a medium-sized (4GB) SQL Server 2005 database running on a 3-year old Windows 2003 Server. [Xeon 2.8-2core, 2GB, 2x 73GB SCSI 10k - RAID 1]. This DB back ends an ASP.NET OLTP ...