0
votes
0answers
23 views

Amazon EC2 SQL Server Connection Timeouts

I am currently having a problem with SQL server timeouts. I am running Windows Server 2008 R2 w/IIS and SQL 2008 R2 (Express) on an m1.small instance in EC2. We have custom services that monitor the ...
0
votes
0answers
39 views

Is there a log showing why a Windows server did not restart SQL Server after a reboot?

Our server was rebooted after a Windows Update scheduled for 1am, but after the restart SQL Server did not start up, so our websites were unable to display. Usually this process happens with no manual ...
0
votes
1answer
162 views

In-Place Upgrade from Windows Server 2008 R2 to 2012

I realize that this might not be the best place to ask this question but I'm not sure which one of the StackExchange websites this question belongs to except for ServerFault. I currently have a ...
0
votes
0answers
21 views

SQL server listening on 2 ports but 1 of them encrypted

First thing, please forgive me for my english, it isn't perfect i know :) I have server called "TEST" (running Windows Server 2008 R2) with SQL Server 2008 R2 instaled on it. I have configured SQL ...
1
vote
0answers
25 views

Should SQL Server backups be scheduled in SQL Server Agent or as a Scheduled Task?

I have inherited a system where a system where our database is backed up by identical scripts, one set up in SQL Server Agent and one set up as a Scheduled Task. Both are running at the same time, so ...
0
votes
1answer
171 views

Error after moving WSUS DB from one server to another

I have a WSUS 3.2 Installed on a Windows Server 2003 R2. SQL Server 2005. I want to move the WSUS DB from this server, to our new SQL Server 2008 R2 on a new Windows Server 2008 R2 Machine. After ...
2
votes
1answer
104 views

SQL Server 2008 R2 Failover Clusters behaviour on multiple failures

I'm testing the resilience of one of our test systems. We have 2 x DB (SQL 2008 R2 on Server 2008 R2, running in ESXi VMs) arranged in a Failover Cluster. Shutting down the Active SQL Server service ...
2
votes
1answer
169 views

SCCM 2007 SP2 - Could not connect or execute sql query

I've run into SQL database connection issues while trying to install SCCM 2007 SP2. I have a VM setup that hosts SQL Server 2008 R2 SP2 installed using default settings and setting the services to ...
1
vote
1answer
278 views

Troubleshooting I/O latency possibly caused by file system driver

I have a SQL Server instance (SQL Server 2008 R2, Windows 2008 R2) that complains, for very short, random periods of about 15-20 seconds, that some of its I/O requests are taking longer than 15 ...
2
votes
2answers
170 views

Moving SQL Server between domains

If a Windows Server machine hosting SQL Server 2008 R2 is changed to another domain, what steps definitely and might need to be done for SQL Server before and after the new domain is joined?
0
votes
0answers
51 views

Installing active SQL server instance on passive node, no network settings field

I'm installing an active-active MSSQL server 2008r2 instance. While trying to install the second active node on the first passive node, I get to the network configuration page and there are no ...
0
votes
1answer
243 views

SQL Server extension fails with PHP, IIS

I am having difficulties getting the SQL Server extension to work with PHP on Windows Server. The installation went fine and I'm able to load phpinfo through the browser. However, when I enable ...
0
votes
2answers
1k views

Looking for robocopy ipg number

I have a robocopy job that creates a problem every time it runs. It saturates the bandwidth in such a way that no other traffic can get through. I read about the /IPG flag but am going in circles ...
1
vote
2answers
2k views

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

in the Console , SQL Server Configuration Manager I get error 10048 when start sql service and this in event history: The SQL server service terminated with server-specific error. Only one usage ...
0
votes
1answer
250 views

Sql Server database logs “missing”

Here's the problem we're having: In the applications that are using the databases we get errors like: The log for database 'redactedDatabaseName' is not available. Check the event log for related ...
1
vote
2answers
429 views

Cannot install SQL Server 2008 R2 on Windows Server 2008 R2

We are attempting to install SQL Server 2008 R2 on a Windows 2008 R2 SP1 box. We keep running into errors at the end of the install - "the service did not respond to the start or control in a timely ...
1
vote
1answer
339 views

Clustering MSDTC on windows Server 2008 R2 returns “No storage Available”

I've set up a failover cluster, with SQL Server 2008r2, and it is running fine. I want to cluster MSDTC as well, but when I go through the high availability wizard, it tells me that there is no ...
2
votes
1answer
182 views

Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory

We have built a new 2 CPU, 6 core server, with 96GB of RAM. SQL server Enterprise Edition was configured with a maximum memory setting of 92GB. A few days after adding into the load balancer I have ...
0
votes
2answers
183 views

OLTP Sql Server RAID configuration with 10 disks, allocation Unit and disk stripe size

On a new db server I only have 10 disks to play with, The usage is about a booking every 3-5 seconds, so not high volume, I know compromises have to be made, but my initial thoughts are - DISK 1 ...
1
vote
1answer
2k views

Quorum Disk size for Windows 2008R2 failover

I am setting up a two node failover cluster for SQL Server 2008 R2 on Windows Server 2008 R2. Microsoft recommends minimum 512MB size LUN for the quorum disk and don't have a recommendation for the ...
1
vote
1answer
1k views

Do I need Windows CALs for a dedicated SQL Server database server? [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? This would seem an easy enough question, but I wasn't able to find any definite answer anywhere. If I'm running SQL ...
3
votes
3answers
2k views

How do I encrypt SQL Server traffic with IPSEC?

I've found all sorts of documentation on what IPSEC is and how to (in very non-specific ways) configure it, but I can't seem to configure a Windows Firewall With Advanced Security rule that both A) ...
0
votes
2answers
109 views

Backup for SQL & Server 2008 R2?

What's the best/easiest backup solution for my use case? Windows Server 2008 R2 Has a finance program called The Financial Edge (Blackbaud) that uses SQL Server 2008 R2 to keep its database Stores ...
2
votes
0answers
332 views

SQL Server 2008 R2 mirroring failing

I have two Windows 2008 R2 (Amazon EC2) instances running SQL Server 2008 R2. I use 9TB striped disks (9x1TB EBS volumes) for storage. One server is running as principal and second one as mirror. Both ...
0
votes
1answer
103 views

Cannot resolve cluster resources on EC2?

I have created this cluster on Amazon's EC2 service. I can connect to the sql instance from the first node (there is only one node in the cluster at this time) using the cluster name, so I know that ...
2
votes
1answer
619 views

How can I assign more than 2GB memory to my SQL Server 2008 R2 Web Instance?

I have a Windows 2008R2 Web server running SQL 2008R2 Web 64-bit. The server has 8GB of memory installed. See this from SSMS: In the SSMS management interface, I am unable to configure the server ...
0
votes
0answers
82 views

MSSQL 2008 R2 Restore VSS

We have a Windows 2008 R2 server which has 2 disks of which one is used as a backup disk for Windows Backup with VSS enabled. We also have MSSQL 2008 R2 running on this server. If I want to restore a ...
0
votes
3answers
958 views

Interpreting SQLIO test results

I've been running a series of load tests on a dedicated DB SAN from a pre-production cluster (Dell R710 connecting to a dedicated RAID10 SAN over 2 gigabit ethernet connections), and I'm not sure if ...
1
vote
3answers
2k views

SQL Server 2008 R2 Clustering inside VMware

I am working on a new Windows 2008 R2 / SQL Server R2 HA cluster and we are planning on running this inside of VMware ESX 5. I have read and heard differing views on using SQL clustering inside of ...
-1
votes
2answers
119 views

How to Redirect and do not Display the real source url address

How can I use host http://192.168.2.27 but my back end will display http://192.168.2.21? Sample: When i type www.google.comin my browser, I want it to go to wwww.yahoo.com but the url address will ...
1
vote
2answers
84 views

Sql Server 2008 R2 connection error

I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client. But it shows the following error: cannot connect to SMSERVER\SMTECH How ...
3
votes
4answers
249 views

Implications of having IIS on SQL Server 2008 R2 machine

an application needs to have IIS on the same box of Reporting Services. Today SSRS and SQL stay on the same clustered box. I need to evaluate the options which for me are: Installing IIS on both ...
0
votes
1answer
3k views

how remotely connect to sql server 2008-r2 installed on vps(virtual private network)? (firewall and sql server 2008 configs)

i have sql server 2008 r2 installed on a virtual private network (vps) with one ip valid ... my sql server instance info for connect on server(vps) is like below : server type: database engine server ...
1
vote
2answers
76 views

Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?

I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. ...
2
votes
1answer
188 views

SSIS 2008 R2 performance and Windows 2008 R2 clustering question

I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a ...
0
votes
1answer
144 views

MS SQL Server wont start when listening for VPN IP

I've just configured SQL Server 2008 R2 Express on Server 2008 R2, with the idea to administrate it remotely via the Routing and Remote Access VPN. Everything is fine via the VPN and the connection ...
0
votes
2answers
2k views

SQL Server 2008 R2 Enterprise won't install on Windows 2008 R2 Enterprise

I've been trying to install SQL Server on a new Windows Server 2008. I have tried everything but I haven't been able to narrow down the problem. When the installation fails I get " Exit code ...
0
votes
2answers
1k views

Clustered MSDTC - No transaction is active

Hi I Currently have two clusters (W2K8R2) with SQL 2K8R2, both with MSDTC cluster service enabled. I've configured the MSDTC with all checkboxes, and Incoming Caller Authentication Required and NT ...
0
votes
1answer
551 views

Error installing SQL Server 2008 r2 on Windows Server 2008 R2 Sp1

I am managing my dedicated server, here's what I did: Made a fresh install of Windows server 2008 R2 SP1 from the MSDN install ISO. Then added the web server role that turns on IIS. DONE! Then I ...
0
votes
1answer
312 views

SQL Server not starting after hard reset

A server (Windows Server 2008 R2) in our office got hard reset and now SQL Server (2008 R2) is not starting. The Event log shows this error: Faulting application name: sqlservr.exe, version: ...
1
vote
2answers
230 views

Is this server core intallation possible: DC + SQL + Sharepoint 2010?

I would like to setup a test staging virtual server. If at all possible I'd like to use just one virtual machine. These are the software requirements: Windows Server 2008 R2 Domain controller Web ...
0
votes
2answers
483 views

Moving SQL Server 2008 R2 Databases to Different SAN location

I have a sql instance up and running with the data files located on a SAN drive. I need to move this instance to a different SAN. I have server/instance on san drive p:\ in rack 1. I have a new ...
2
votes
1answer
2k views

SQL Server 2008 R2 error “The program or feature cannot start or run due to incompatibity with 64-bit versions of Windows.”

I'm installing SQL Server 2008 R2 using a DVD that says 32/64onto a Windows Server 2008 R2 server. I want to install the 64-bit version of SQL Server 2008 R2. I am installing SQL Server with the ...
1
vote
1answer
2k views

SQL Server 2008 R2 - Cannot create database snapshot

Server: Windows Server 2008 R2 X64 Enterprise SQL: SQL Server 2008 R2 Enterprise X64 I have a default SQL Server instance, the SQL Server service account is running as a domain user. I am trying ...
6
votes
6answers
26k 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 ...
1
vote
1answer
300 views

SQL Server 2008 R2 install fails with a type load error

I've got a VMWare virtual machine running Windows Server 2008 R2. I've installed the latest updates and the Windows SDK, and I'm in the process of installing SQL Server 2008 R2. I'm not getting very ...