1
vote
0answers
28 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
0
votes
0answers
22 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
1answer
80 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 ...
1
vote
1answer
72 views

Language issues with SQL Server in-place upgrade

I have an instance of SQL Server 2008 R2 which has been installed off localized (German) media. I need to run an in-place upgrade to SQL Server 2012, but get stuck in a chicken-and-egg problem: as ...
0
votes
1answer
59 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 ...
0
votes
1answer
666 views

Firewall configuration for SQL Server 2012 Express on Windows Server 2008 R2 for Workgroup

We are attempting to configure a server application to run on Windows Server 2008 R2 using SQL Server 2012 Express. With the server firewall turned off completely the application can communicate just ...
0
votes
1answer
53 views

Add Windows User Account to Ubuntu Server

I have a Ubuntu Server v. 13.04 that I am using as a file server (amongst it being a LAMP stack). I have a samba share let's call it /shares/SQLDatabases I have a Windows 2008 R2 Server in the same ...
-1
votes
1answer
601 views

Connect to SQL Server installed on vmware from outside

I have windows server 2008 r2 sp1 on my vmware, SQL Server 2012 Express installed there. I want to use Sql Server management studio to connect to the Sql Server from outside (host, and other machines ...
3
votes
3answers
500 views

What to check during a periodic system health check

I have been tasked with preparing a list of checks to do as a part of a weekly system health check routine which my team is supposed to do. The problem is neither I nor any of my colleagues have ever ...
0
votes
1answer
90 views

EC2 instance communication

I currently have one EC2 instance that is starting to send alerts for high CPU usage. I want to create another instance and use this instance for the database and keep my existing instance for the web ...
0
votes
1answer
2k views

SQL Server express service is not starting [closed]

I've bought my first VPS yesterday, and I have installed Microsoft SQL Server 2012 Express on it. Then I have restarted my VPS. But SQL Server Service didn't start. I've tried to start it manually, ...
3
votes
1answer
1k views

ASP.NET MVC incorrect connection string when connecting to mssql server

I built my website on ASP.NET MVC4 using mssql database, I deployed it on my local IIS 7 server and it works fine, but when I do to the exactly the same thing on virtual server hostgator.com it throws ...
1
vote
1answer
573 views

Sending email using msdb.dbo.sp_send_dbmail

I have two almost identical Windows Server 2008 R2 servers set up with Microsoft SQL Server 2012. One server has a hardware firewall with port 25 open in both directions (plus opening RDP to certain ...
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 ...
4
votes
1answer
167 views

How does a SQL Server Availability Group decide on which secondary will become the new primary when an automatic failover is triggered?

How does a SQL Server Availability Group with multiple synchronous-commit secondary replicas decide on which secondary replica will become the new primary when an automatic failover is triggered? ...
3
votes
1answer
953 views

How do I network this Windows Failover Cluster and MongoDB Replica Set? (diagram inside)

As you can see, my two Windows Server Failover Cluster (WSFC) nodes have three network interfaces each, which connects them to three different networks : A public network A private network ...
0
votes
1answer
247 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 ...
2
votes
2answers
272 views

Creating database backups using SQL Server 2012 Tools that can be imported by SQL Server 2008 R2

Basically I was learning the Ms stack of software and working on an application that used an *.mdf file mounted to the local ./SQLEXPRESS instance. I then upgraded all software on the machine to ...
0
votes
4answers
297 views

Cannot login by using Server Name but together with instance

My problem is totally opposite with this member. For my case, I cannot login to mssql 2008 without specify the instance name. I am thinking how to connect to mssql by just having the server name. This ...
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 ...
0
votes
1answer
122 views

Win Server 2008 R2 with Hyper-V and SQL Server

I'm putting together a new server which will be running a couple of light weight web applications and a fairly lightly used SQL Server 2008 database. I've specified a machine that is significantly ...
0
votes
2answers
643 views

MSSQL Server Express: How to reclaim unused space

At our company we are using a proprietary third party custom application that uses SQL Server Express as its backend. As you are aware SQL Server Express 2008 has a hard 10GB limit. For the “old” data ...
1
vote
2answers
663 views

Connection String for MS SQL Server 2008 using Windows Authentication

MS SQL Server and the web application are both on the same machine. In web.config, I have: connectionString=" Server=COMPUTER_NAME\MSSQLSERVER; Database=MyDatabase; Integrated ...
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?
4
votes
2answers
187 views

Opinion about server slowness?

We have 2 servers for IIS with Load Balancer and 2 clustered MS SQL servers. Each servers has aprrox. 262GB RAM, 64 core processor(not all physical cores), etc. I mean servers are really powerful. The ...
0
votes
1answer
72 views

mssql replication storage

I have 2 boxes. One is dell (4x146GB 15k 3.5'' SAS in raid 10). this is primary sql server (runs only mssql). dell has 8gb ram and mssql is running fine. Dell has windows 2008 R2 x64 second is hp ...
2
votes
0answers
2k views

Why can't I connect on port 445?

I need to collect baseline performance data on a SQL Server running on Windows Server 2008 R2. When I open perfmon on my computer running Windows 7 and try to add counters from the remote server, I ...
2
votes
4answers
2k views

Can I install non English version of MS SQL Server 2008 to English version MS Windows Server 2008 R2?

My friend accidently bought Japanese MS SQL Server 2008 R2 instead of the English version. However, we currently have English Windows Server 2008 R2. Can we install it anyways? I don't have a test ...
3
votes
3answers
371 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 ...
1
vote
1answer
1k views

Windows Server 2008 - How to lock down Firewall Advanced?

I'm having problems with simultanous brute force attempts on my Windows Server 2008 R2 and the MS-SQL Server which is on it. I have renamed the Windows Administrator account (Administrator) I have ...
3
votes
4answers
244 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 ...
1
vote
2answers
432 views

Best practice for instaling multiple instances of MS SQL 2008r2 on Windows server 2008r2 (running on esxi)

I wann't to move my sql server onto virtualized platform (Vsphere, esxi 4.1). Here is my plan on how would I install it: Vm with 3 disk's. C: for windows and sql binaries, D: for sql data, E: for ...
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 ...
9
votes
2answers
3k views

How to Protect Sensitive (HIPAA) SQL Server Standard Data and Log Files

I am dealing with electronic protected health information (ePHI or PHI) and HIPAA regulations require that only authorized users can access ePHI. Column-level encryption may be of value for some of ...
5
votes
1answer
205 views

Specific site unable to connect to MSSQL server after reboot

I have a very annoying problem on my Windows 2008 R2 server. Each time it's restarted, either planned or unplanned, one specific site is not able to connect to the database server, a MSSQL Server 2008 ...
0
votes
0answers
47 views

Will this increase my Virtual private Server failing rate?

Will this increase my Virtual private Server failing rate if i :- install Microsoft Window Server 2008 Enterprise install SQL server enterprise 2008 install IIS 7.5 install ASP.Net Mvc 2 install ...
0
votes
1answer
305 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: ...
0
votes
4answers
2k views

Slowness on SQL Server 2008 with Windows Server 2008 R2

I am facing a performance problem on our server. The main reason seems the versions of OS and SQL Server. Once I install the SQL Server 2008 on Windows Server 2008 R2, the response time of my web site ...
6
votes
1answer
622 views

How to upgrade MS SQL Server from 32bit to 64bit

I have a production server, that is used for MS SQL Server Databases. The machine specs are: - Intel Xeon E5410 CPU with (EM64T) - 4 GB RAM - SCSI HDDs in RAID mode It currently has: - Windows ...
0
votes
1answer
56 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?
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 ...
2
votes
1answer
11k views

SQL Server setup media does not support the language

I'm getting the following error when i try and install MSSQL 2008 on Windows Server Standard 2008 R2:
1
vote
3answers
356 views

On a VPS that runs DB and IIS, should I limit the RAM used by SQL Server?

I have a Windows 2008 R2 VPS with 1 GB of RAM. I'm using the VPS to run SQL Server 2008 Express and IIS 7.5. I've noticed that SQL Server tends to use as much memory as it can, to the detriment of ...