Tagged Questions

-1
votes
1answer
50 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 ...
0
votes
1answer
36 views

Take mirror copy of my server to another in scheduled manner as back up [closed]

I want to save a mirror copy of my Windows VPS on another server. With these capabilities: When I change anything on my real server the same change happens on my backup server (simultaneously or in ...
3
votes
3answers
216 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
74 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 ...
-1
votes
1answer
529 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, ...
0
votes
0answers
37 views

Cannot Establish Connection to Database Server from WSAT

I am unable to establish a connection using the WSAT when attempting to configure my ASP.NET 4 web forms application. My web.config contains the following connectionString: <connectionStrings> ...
3
votes
1answer
567 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
209 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
445 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
126 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
466 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
141 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
197 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
243 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
1k 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
108 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
317 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
428 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
1k 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
181 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
59 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 ...
1
vote
0answers
1k 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
1k 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
299 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
871 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
182 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
292 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
871 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
2k 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
181 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
44 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
194 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
550 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
51 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
207 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 ...
1
vote
3answers
307 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 ...