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)

20
votes
3answers
62k views

“The wait operation timed out” when running SQL Server in Hyper-V

I'm running SQL Server (2012) on a Hyper-V instance. It has plenty of resources and 25% reserved of the total resources, the VHD is placed on a very fast SSD drive for quick response times. Every now ...
3
votes
0answers
61 views

MSSQL Server 2012 (not R2) maxing out CPU (98-100%) with svchost (wuaueng.dll)

Spent a fair bit of yesterday trying to find a solution for this, but this issue appears to only affect Server 2008...well, I beg to differ! MSSQL, hosted on Server 2012. Updated via WSUS. Enabled ...
0
votes
1answer
14 views

How to use MSSQL, rebuild all indexes on all tables? MSSQL Server 2008

I have a mssql database, we'll call it: mssqlDB01. I've been tasked with performing defragmentation on all of the tables. This database has a few hundred tables and each table has a range of 1 to 15 ...
3
votes
4answers
7k views

Unable to back up SQL Server databases using a maintenance plan

I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select ...
0
votes
0answers
11 views

MSSQL configuration by PowerShell - What am I missing?

I want to configure certain MSSQL server settings using PowerShell scripts. (OS is Windows Server 2012 R2, MSSQL is 2014. PowerShell was invoked as sqlps.) For instance, I want to enable/disable a ...
0
votes
1answer
1k views

Why is PHP -> MSSQL very slow when the DB is not on the same machine as the PHP code

In the course of trying to move our website to Azure, we've found a problem with our PHP code talking to MSSQL. On the current dedicated host (hosting both the PHP and the DB), going to a page ...
0
votes
1answer
2k 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 ...
-1
votes
0answers
14 views

MSSQL Authentication Against Remote Server

I want to use MSSQL authentication for a database I'm creating for a corporation. The problem is, due to corporate politics, the IT department will not allocate any virtual server space to us. It ...
0
votes
1answer
110 views

What format does commvault restore to for SQL server backups?

I have a pretty challenging task that I need to figure out. I have 6TB of data in New Hampshire that I need to move to Texas. It is all SQL Server data. The data is backed up to tape via Commvault as ...
0
votes
1answer
17 views

MSSQL - show columns in specific table and database

Not quite getting how to enumerate the columns within a specific database and table. I can list all the databases using: SELECT name from master..sysdatabases go I can show all the tables for a ...
1
vote
2answers
4k 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 ...
0
votes
2answers
4k 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 load....
-1
votes
0answers
12 views

SQL Witness size

I've been unable to find any reference from Microsoft's TechNet nor MSDN site outlining the size requirements for a SQL witness instance. I recall from a Windows Server witness setup, it's barely a ...
0
votes
0answers
7 views

Generating a hash over MS SQL database scheme?

I have a database in MS SQL 2012/2014 with a "status quo" structure of tables. This database scheme is likely to be updated. Is there a possibility to generate something like a unique hash over this ...
0
votes
1answer
70 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
0
votes
2answers
720 views

SQL Transactional Replication snapshot not applying

I'm using SQL Transactional Replication with pull subscriptions to replicate databases (hosting their own distribution database) from several servers across a VPN to a central server. I've got the ...
0
votes
1answer
24 views

Login failed for user 'sc' even after creating user

I am trying to run a web application but I just cannot login with a user account (sc). I keep getting Login failed for user 'sc'. Description: An unhandled exception occurred during the ...
-1
votes
0answers
5 views

Inset/Update when using UserDefinedTypes and sqltranstion in .Net

I have userdefinedtypes which i use in stored procedure to perform transaction. and trying to insert/update set of users into db. i am using sqltransaction in .net while executing the database call. ...
0
votes
0answers
41 views

Cannot install php5-mssql or php5-sybase

our server is running with Ubuntu 16 and PHP5.6 . We've tried to install PHP5 Ms SQL Server package, however it returns unable to locate package error. Most likely the PHP5 packages are no longer ...
2
votes
1answer
2k 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 ...
0
votes
1answer
1k views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
0
votes
2answers
2k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
1answer
2k views

Powershell execution policy within SQL Server

Can anyone help? Firstly I apologise if this is the wrong forum and for the amount of text you have to read. I'm not allowed to post images yet and a picture is worth a thousand words..... When ...
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 ...
4
votes
3answers
3k 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 ...
8
votes
1answer
1k views

SQL Server Installer Update Cache management

Is it safe to delete the old cumulative update directories from the %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Update Cache folders? At least this MSDN blog post tells to leave anything ...
0
votes
1answer
2k 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 ...
0
votes
3answers
83 views

SQL Server Named Pipe Error

I have been trying to install SQL Server Express for a few days now. I tried 2008, 2012, and now 2014 all with the same result. I cannot connect to the database remotely, even if I turn the firewall ...
2
votes
6answers
5k views

Why am I getting this 500 error from IIS?

I'm running PHP 5.3.1 on IIS 7.5 on Windows 7 Ultimate x64. I've been trying to make PHP connect to my local installation of SQL Server 2008 Express over ODBC using ADODB. At first I had trouble ...
0
votes
1answer
4k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
4
votes
3answers
2k views

SSMS: Where does SQL Server store its server names?

I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio: Where ...
1
vote
0answers
11 views

PHP on IIS7 can't enable MSSQL

I have an installation of PHP 5.3.6 on my IIS 7 server. I did not install this and am only beginning to manage it. It has Wordpress 3.2.1 on it. It has these values; from phpinfo(): Configure ...
1
vote
1answer
2k 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 ...
1
vote
1answer
1k 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 ...
0
votes
1answer
3k views

Easy way to alias the default SQL Server instance to a named instance?

I have SQL Server Express installed on my machine as the default instance. "server=.;database=...." I'm now working with a new client where their config files are all checked into the repository. They ...
0
votes
1answer
2k 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
3k views

SQL 2008 R2 automated install w/ configuration file - The credentials you provided for the SQL Server Agent service are invalid

I am doing an automated installation of SQL Server 2008 R2. I have a new VMware guest with Windows 2008 R2 and ran the SQL Server 2008 R2 setup to create a configuration file. I am only installing the ...
0
votes
1answer
4k 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
0answers
17 views

How to fix “freetds-0.95.81-1.el7.x86_64 has missing requires of libodbc.so.2()(64bit)” in docker container

I want a centos-based container that provides SQL drivers for both FreeTDS and Microsoft's SQL Driver, ver 13. The MSSQL driver requires unixODBC to be compiled with specific flags: ./configure --...
0
votes
1answer
18 views

How Does SQL Server Management Server Authenticate

When using SQL Server Management Studio and logging in as a Windows User, does the Studio authenticate against AD again, or will it use the Windows information? The reason why I ask is if a user logs ...
0
votes
1answer
550 views

[S1090][unixODBC][Driver Manager]Invalid string or buffer length

I'm getting the error above when issuing isql 'odbc:Driver={ODBC Driver 11 for SQL Server};SERVER=<redacted>;DATABASE=<redacted>;' username password -v as root on my Linux CentOS 6.7. ...
4
votes
1answer
2k views

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

I've tried reinstalling 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 ...
3
votes
2answers
3k 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 ...
4
votes
2answers
4k views

IIS 7.5 web application failing with NT Authority\Anonymous Logon

I am finding various google results, but none seem to fix my problem. I am setting up a new WINDOWS 2008 R2 box at work that is to communicate with an existing SQL 2012 box via web tools running in ...
3
votes
1answer
5k 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 ...
3
votes
1answer
1k views

SQL Server Debugging: “Unable to Step. Invalid operation”

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid ...
0
votes
0answers
18 views

Restricting SQL Server Management Studio using LogMeIn Hamachi

I have a SQL Server 2016 instance on Windows Service 2012 VM running in Azure. Currently the network security group/firewall allows for port 1433/TCP traffic so I can connect from my PC using SQL ...
2
votes
1answer
1k 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. ...
-3
votes
0answers
24 views

HA CloudStack with storage on 2 'micro cloud' chassis

I have 2x Supermicro 5038ML-H8TRF micro clouds's (8 independent hot swappable servers in a 3u chassis). I want to setup a HA private cloud. Basically each chassis will have 1 Management & 3 VM ...
3
votes
2answers
5k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...