Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

learn more… | top users | synonyms (3)

0
votes
1answer
2k 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 ...
3
votes
1answer
85 views

High Available SQL Server without SAN by using AlwaysOn feature

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced. AlwaysOn is a new feature in SQL Server 2012 that is ...
2
votes
3answers
2k views

Can’t connect to SQL Server 2008 - looks like Shared Memory problem

I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio. I believe the problem is related to a change I made to the connection protocols. Before the ...
4
votes
2answers
7k views

How to temporarily stop time syncing with domain controller?

I wish to do some testing on my local machine which requires me to put the date forward a year. So I can test some stuff in SQL Server (i've found it not possible to override the sql server time). ...
0
votes
0answers
23 views

Server high memory and cpu - no leads

I've been asked to troubleshoot a server hosting our application at a client's facility. The client has complained to us on two separate occasions in the last week - week and a half. In one instance ...
0
votes
0answers
47 views

Best practice to connect web services to database (mssql, oracle)

Our scenario: thin client (.net desktop application), which connects to our web services, web services with business logic and data access layer, running on IIS, authentication through ...
1
vote
1answer
64 views
+50

Change SSL Protocol in MSSQL 2012

Is there a way to change the SSL Protocol support in MSSQL express 2012 on windows 2008R2 ? I want to change the protocol from SSL3 to TLS (1.0,1.1,1.2), after hours of looking I cant find ...
0
votes
1answer
2k views

MSSQL 2008 is claiming the firewall is blocking ports even from local machine

I was just hoping to step through a couple queries to see how the temp tables are interacting and I'm getting this message. The windows firewall on this machine is currently blocking remote ...
0
votes
1answer
20 views

SQL Server Management Studio 2012 - password lag and failure

In a new installation of SQL Server 2012 Standard, we have mixed-mode authentication enabled. Using Windows authentication, I can authenticate and use SQL Management Studio as expected. Using SQL ...
0
votes
1answer
32 views

MSSQL 2008 r2 Express: there is insufficient system memory in resource pool 'internal' to run this query

I'm experiencing this error during the lifecycle of my DotNetNuke Installation. I've change the hosting server and now I've got a Windows Server 2012 with IIS 8 an SQL server 2008 r2 Express running ...
5
votes
4answers
6k views

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 ...
0
votes
0answers
64 views

Setting BIG-IP LTM Virtual Server for two SQL Servers nodes

I've created BIG-IP Virtual Edition instance in Amazon EC2 using this tutorial. I've followed this tutorial to configure BIG-IP System as an MS SQL Database Proxy. There were couple things that I ...
1
vote
0answers
17 views

SQL Server Differential Backup Bloat [migrated]

I perform daily full backups of all databases. Differential backups are performed every hour. The issue I am having is that around the same time each morning, a few hours after the full backup, the ...
0
votes
1answer
37 views

Windows Server 2012 R2 Virtual Switch

We have an Dell R510 that has Windows Server 2012 R2 Core installed. We are having a problem where the guest VMs are losing their network connections but will come back after a couple of minutes. The ...
0
votes
3answers
85 views

Running IIS and Virtualized SQL Server on same machine

I work for a small organization within the government. We maintain our own Windows Server 2003 web server on the the govt. DMZ. We have to migrate to Windows Server 2008 or 2012 by July. ...
2
votes
2answers
1k views

how to include error messages into backup reports for SQL Server 2008 R2?

Right now I have daily (differential) and weekly (full) backups set on my SQL Server 2008 R2 as jobs for SQL Server Agent with email notifications if job fails. I do get emails like this: JOB RUN: ...
1
vote
2answers
2k views

How to set up Zabbix to monitor SQL Server Failover Active-Passive Cluster?

It should be simple, so it is just most likely my approach being totally off and someone will hopefully prod me into the right direction. We have a Zabbix 2.0.3 server instance set up monitoring a ...
0
votes
1answer
834 views

long access times and errors in iis application

I am having an issue with an IIS application (details of environment at the end of the message). The web site works great most of the time and I cannot reproduce any error in our test system. On the ...
-1
votes
0answers
10 views

How to plan ASP.NET app for highload? [closed]

So I'm going to build an application on ASP.NET MVC 5, MSSQL server, using WebAPI, SignalR and scheduler like Quartz.NET. I'm looking for best practices of planning good architecture for such project, ...
1
vote
0answers
19 views

What are the network prerequisites for Windows Azure Pack

I have followed many articles to install and config windows azure pack distributed, But every time I finish configuring everything, the azure pack is not working and give me different errors, seams to ...
0
votes
1answer
1k views

Performance Issue Between SQL and IIS on Seperate Machines

First time OP on serverfault, but an avid user of stackoverflow. We have two high-specification boxes, both running Windows Server 2008 R2 Standard. On one we have IIS 7.5, the other SQL Server 2008 ...
0
votes
2answers
27 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
15
votes
2answers
8k views

Windows LocalSystem vs. System

http://stackoverflow.com/questions/510170/the-difference-between-the-local-system-account-and-the-network-service-accou tells: Local System : Completely trusted account, moreso than the ...
0
votes
1answer
865 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
2
votes
1answer
3k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
-1
votes
1answer
22 views

Windows update 2919355 causes our SQL based app perf to drop to 1/6 of previous perf

We have a VB6 app calling out to a local SQL2008R2 instance. We have had complaints about it's performance dropping considerably. After a lot of experimental research, we have determined at least 1 ...
2
votes
1answer
1k views

WSS Search fills 10 GB limit on SBS server 2011

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most. I've just started getting the following ...
1
vote
1answer
852 views

Setup ejabberd with SQL Server 2008

Here's what I have got so far. Windows 2008 Server 64 bit. Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe. The windows service starts up fine but seems ineffective. ...
1
vote
1answer
2k views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...
1
vote
2answers
727 views

How to remove dead SQL Server registrations from SQL Server 2000 Enterprise Manager?

We had some databases decommissioned recently, and my SQL Server 2000 Enterprise Manager still shows the server group I originally created containing those servers. I tried deleting the entire server ...
1
vote
4answers
4k views

DSN, ODBC: How to create DSN using different windows account

Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create ...
0
votes
1answer
1k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
0
votes
1answer
24 views

Upgrading SBS 2003 Premium (with SQL server) to Essentials 2012 R2

As support (and running on old hardware) is fading out for SBS 2003, we are considering upgrading to essentials R2, as suggested by microsoft. The exchange environment will be migrated to Office365, ...
4
votes
6answers
32k views

SQL - an error occurred during the pre-login handshake

Until yesterday evening, I was able to connect to my server from my local machine. Now, I get the following error: A connection was successfully established with the server, but then an error ...
1
vote
1answer
1k views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...
4
votes
2answers
1k views

March 10th Patch Tuesday appears to cause SQL Server client connection problems

Since applying the full set of patches on a Win 7.1 Pro desktop and a Windows 2012 R2 Datacenter Azure server running SQL 2014, SQL Management Studio (2008 and 2014 versions) won't connect to the SQL ...
1
vote
1answer
726 views

Unexplained CPU and Disk activity spikes in SQL Server 2005

Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows ...
0
votes
1answer
39 views

Automatic log truncation when scripting from SQL 2008 to 2005

I have to convert a sql server 2008 database to a sql server 2005 database. As far as I understand it, the only reliable way to do this is by scripting the database to an earlier server version. Now, ...
3
votes
3answers
1k views

SQL Server Windows Authentication fails after tonight's security updates: The login is from an untrusted domain

We have the following setup: One Domain Controller (DC, Server 2003 R2 Standard x64) One SQL Server (SQL, Server 2008 R2 Standard x64) some clients. All machines are in the same domain. All user ...
7
votes
2answers
892 views

Should I encrypt OS disk with BitLocker for HIPAA compliance

I am looking into hosting a HIPAA compliant web application on Azure VM's. For the database, right now I am leaning towards using a VM with SQL 2014 Standard Edition. Since TDE is not available with ...
0
votes
1answer
799 views

SQL Server Timeout issues at random times causing performance degradation

I am having random timeout during a brief period of time on certain days. My CPU, Memory looks fine. So I ran Performance Monitor during these spikes and found my average disk sec/read was 5.8 ...
2
votes
5answers
553 views

Load estimation for an ASP.Net / SQL Server application

Are there any heuristics to define server requirements for typical applications? Coming from internal development to a handful of users, this is our first deployment of a internet application. ...
3
votes
4answers
225 views

“Catch All” Server-Side Load Profiling

If I have an infrastructure with some Web Servers (Windows 2003 and IIS) and a Database (SQL Server 2005) and ASP.net, I wonder if there is a catch-all tool that simply allows me to say "Ok, I now ...
1
vote
1answer
1k views

SharePoint 2010 Server Configuration Error -> “Cannot connect to database master”

I recieve the following error when I try to configure SharePoint 2010 Server: "Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current ...
2
votes
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
0
votes
1answer
947 views

SQL server corrupt page

i am getting the following error when i try to select data from a table. SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:6380; actual 0:0). It ...
2
votes
1answer
1k views

Why are SQL Server pages 8 KB?

According to Mark Russinovich's Windows Internals 5th Edition, Windows uses (small) page sizes of 4 KB on both x86 and x64 architectures to manage memory. Even though I can't find a reason for this, ...
2
votes
1answer
85 views

Are there any other causes of this error that are NOT related to initial setup?

I'm trying to diagnose an issue at a customer site. They are receiving the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server ...
0
votes
2answers
31 views

What the permission required to view all the permissions on a given database?

What permission can grant the right to view all the permissions on a given database? In my current context, the support team of a piece of software need to be able to investigate the cause of ...
1
vote
1answer
851 views

Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps'

I've tried re-installing SQL Server 2014 and I'm still getting the following error message when trying to import-module sqlps. The same registry key exists but is appended with 120. I'm able to use ...