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
0answers
24 views

Using a Load Balancer in front of SQL Server

We are setting up SQL Server 2014 AG with multiple secondary readonly instances since we have some significant queries that are killing our primary. What we would like to do is put a Load Balancer in ...
0
votes
1answer
2k views

Active Directory SQL Server Random Handshake Timeouts

We've installed active directory on a new server and joined our database server and web servers to this new domain. However, randomly, we'll get the following error. What would be the cause of the ...
0
votes
1answer
45 views

AD mapping error with VMware

I'm trying to setup a VMware Data Center with Win Server 2008 R2 and SQL 2012. I have a VM that hosts DHCP and DNS services and created an account called "SQLAdmin" that is a local admin to a SQL VM ...
-1
votes
0answers
16 views

Could not find prepared statement with handle -1 SQL Server Profiler [migrated]

So I have this issue where I'm running Sql Server Profiler and I'm getting hundreds(at least) of Could not find prepared statement with handle -1.(error 8179) per second. I can't seem to really ...
-1
votes
1answer
20 views

Need help importing data to new SQL server from MySQL folder

My hard drive crashed, and can no longer write, but it can still read. Because of this, I was unable to export my SQL database to an .sql file for later importing. I can still access the drive, and ...
1
vote
1answer
1k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
0
votes
2answers
356 views

Can not connect to SQL server with SQL Authentication. But can using Windows Authentication

The server authentication is set to: SQL Server and Windows Authentication mode I can connect using Window authentication but not SQL authentication. Login failed for user 'sa'. (Microsoft SQL ...
4
votes
3answers
215 views

vSphere Datastore for specific datatypes: NFS or iSCSI

I am looking into improving performance in my vSphere environment. We are using a NetApp appliance with all VMs stored in Datastores that are mounted via NFS. It was suggested to me that, for some ...
0
votes
1answer
20 views

Installation of MS Host Integration Server 2006

We are in the process of upgrading from Windows 2003 R2 servers to Windows 2008 Standard Edition Service Pack 2 32 bit. We need to install Host Integration Server on this server, and it mentions ...
1
vote
2answers
3k views

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed ...
2
votes
1answer
3k views

How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

I am in serious trouble and I am seeking professional advices here. We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
0
votes
1answer
2k views

Change server on sap client

I have a SAP business one 8.0 installed on my Windows server 2003. It uses sql-server express 2005 for the database. Then I installed the client on another PC. How do I configure the client so it can ...
0
votes
1answer
2k views

SQL Server replication pending transactions

I'm having a problem with a transactional replication. I have the publisher in my server and there is a subscriber in another server. In my server, if I go to the details of the subscription I can ...
2
votes
3answers
2k views

MS Access gets Disconnected

I have MS Access 2003 application connected to SQL Server 2005 with linked tables. Starting from yesterday when I open a linked tabled and leave it open for a while (5~10 minutes) then the database ...
0
votes
1answer
20 views

SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in Management Studio

I have a SP, which calls xp_cmdshell in it. This SP is being used in a MessageQueue. The SQL server and Agent services are configured using a Domain service account, and this service account has a ...
4
votes
1answer
3k views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
0
votes
3answers
3k views

How to move SQL Server 2005 Instance “root directory” without re-installing the instance?

Does anyone know a way to change the SQL Server 2005 default instance "Root directory" without re-installing the instance? I just installed a RAID5 SAN drive and I want the backups of the SQL ...
0
votes
1answer
3k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
1answer
246 views

How to rebuild MS Agent Jobs from MSDB table?

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the ...
2
votes
1answer
333 views

Index reorganizing slow after index rebuild with MS SQL

Why does index reorganizing take 3 times longer after I make an index rebuild? I wasn't sure if this happens every time, so I made a test for the last month. I configured SSMS to execute Index ...
0
votes
1answer
2k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
1
vote
1answer
1k views

Can't rebuild master DB on MS SQL Server 2005 Express after power failure

There has been a power loss on our server and I cannot start the SQL service because the master DB is corrupted (as the log states). I found many articles recommending running the setup.exe with ...
1
vote
0answers
19 views

SQL Server Connection Issue with New Router But Works With Old Router

I have an issue that really has me stumped. I have a router that is overheating and needs to be upgraded. When I connect the new router and configure it with the same DHCP settings and IP ranges as ...
1
vote
1answer
1k views

SQL Server ODBC Connection via Command Line

I need to create a number of ODBC connections to a MS SQL Server, the clients are mainly XP machines. The connection has to use SQL server authentication - is there a way to do this remotely via ...
9
votes
1answer
63k views

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. ...
-1
votes
2answers
106 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 ...
2
votes
1answer
441 views

Define priority of database access into SQL Server 2008

We're using a SQL Server 2008 database. This database provides data for two main applications: A website to display a Viewer. A routing application that needs to be highly responsive ! Is it ...
3
votes
1answer
86 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 ...
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
51 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 ...
2
votes
1answer
105 views

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
37 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 ...
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
1answer
47 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
111 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: ...
0
votes
1answer
841 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
vote
0answers
25 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
2answers
33 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 ...
-1
votes
1answer
29 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 ...
1
vote
2answers
738 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
42 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
34k 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
751 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
40 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
2k 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 ...
8
votes
2answers
1k 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 ...
2
votes
5answers
559 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. ...