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 (4)

1
vote
1answer
20 views

SQL Server 2012 Backups Not Compressing

We recently upgraded from SQL Server 2008R2 to SQL Server 2012 Enterprise. After doing this I noticed that our DB backups were barely compressing at all. Our 22gb DB was compressing down to about 4gb ...
0
votes
1answer
138 views

Can Ping but Cannot Telnet directly to SQL Server 2012 Cluster Nodes

We have a monitoring tool (Solarwinds Orion) that needs to connect to a 2-node failover SQL Server Cluster. For reasons outside of our control -- we cannot monitor the CLUSTER IP directly at this ...
-2
votes
1answer
370 views

Is Dell Poweredge 2950 faster than Dell Poweredge R820? [closed]

I have a 10 year old Dell Poweredge 2950 that will be replaced with a Dell Poweredge R820. Both of these machines are set up as a Virtual Machine Host Running Hyper-V. Both Operating Systems are ...
1
vote
0answers
31 views

Issue while setting up a DSN while creating a linked server

I am trying to set up a linked server to my sql from sql server. However I am encountering problems while setting up the dsn. Reffering this link for help. My MySQL database resides on Amazon ec2 ...
0
votes
1answer
62 views

Determining Azure SQL Database requirements

I'm looking into moving an SQL Server database project to the cloud using Azure SQL Database. I'm just wondering what metrics I can use from SQL Server to help determine what my needs will be on ...
1
vote
3answers
218 views

Vmware cpu allocation for a spiking database server

I have a database server with many poorly written queries that causes the sql server to spike then drop constantly ( a massive start from scratch is happening). I need to know if the cpu allocation on ...
0
votes
2answers
866 views

SQL Server Agent was not running on Server Dynamics CRM 2013

I'm trying to install Dynamics CRM 2013 on a server. This server is on a VM. There are several other VMs, an ADDS & DNS, a MSSQL and a WebServer VM. Each server is a Windows Server 2012 R2. The ...
0
votes
1answer
28 views

Hide a SQL server table partition

Is it possible on SQL Server Enterprise to hide a specific table partition from users including admins? encrypting the data is not an option for us.
0
votes
1answer
65 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
0
votes
0answers
59 views

Intermittent telnet connection issues on 1433

I have several windows server boxes running on the same subnet at a co-lo. I have a few sql servers instances running and some of the machines can talk to it just fine, but at least two of my web ...
0
votes
0answers
83 views

Cannot access Cluster Shares via Cluster Name

I got a serious problem here (thinking like so), the problem is I have a Windows 2012 R2 Cluster and I have the Disks shared to cluster nodes via Share the VHD option that is available in 2012 R2 ...
0
votes
0answers
51 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
2answers
131 views

Add an Excel file as a linked server in SQL 2012

I'm trying to add a linked server to an Excel 2010 file from SQL Server 2012. Every reference I've found online for doing this is using older versions of SQL Server, and the driver that they tell you ...
2
votes
0answers
54 views

Failover_Partner connection in file DSN not working

I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding ...
1
vote
1answer
1k views

can't connect to Sql Sever Management Express 2012

i installed Sql Sever Management Express 2012 , but when i try to connect in Sql management studio enviroment , i have this error . > TITLE: Connect to Server Cannot connect to .. ADDITIONAL ...
1
vote
0answers
116 views

Make other VMs show in Network on windows server in Azure

I'm deploying a desktop app that connects to a remote database. standard 2-tier setup, but it's not a web app. People will log in via RemoteApp. But I'm having trouble getting the app instances in ...
0
votes
2answers
1k views

Why is my DB read-only when attached to SQL Express, but not with SQL Web?

I have an .mdf/.ldf pair, originally created in 2008 R2 Standard, and well under 10GB, with ACLs: d:\db snapshot\DB_NAME.mdf SERVERNAME\SQLServerMSSQLUser$ACCOUNT$MSSQLSERVER:F OWNER RIGHTS:F ...
0
votes
1answer
55 views

Upgrade from SQL 2008 to SQL 2012: do we need to change connection string?

We are seeing some terrible performance degradation having just upgraded our MVC4 application from SQL 2008 to SQL 2012. Queries run directly in management studio on the database server run somewhat ...
0
votes
1answer
694 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 ...
0
votes
0answers
339 views

MySQL Workbench Could not connect to Source DBMS

I have a server which has a MSSQL database and i trying to data migrate from MSSQL to MySQL, in the first stop after i choose database --> data migrate --> i choose data system (Microsoft SQL server) ...
1
vote
1answer
293 views

deploy ssis 2012 packages on 2008r2 server

We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this. Is this even possible and ...
1
vote
1answer
515 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 ...
0
votes
1answer
75 views

Scheduled copy of production database into test database

My question is similar to this one. I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and ...
0
votes
0answers
45 views

Push an MS SQLServer database table to SharePoint 2010

I have a database table on my local MSSQL Server that I need to give my remote customers read only access to. They run SharePoint 2010 and would like to access the table using this, I have a login to ...
2
votes
1answer
184 views

What to store on ephemeral drive? (windows ec2 + sql)

I have an EBS-backed Windows EC2 server with an additional ephemeral drive (aka "instance store") which is really fast (SSD). The instance runs an IIS website + SQL Server What can I move to the ...
2
votes
1answer
714 views

Why is MS SQL Server Using NTLM Authentication?

Windows Server 2008 R2. SQL Server 2008 R2 installed. MSSQL Service runs as Local System. Server FQDN is SQL01.domain.com. SQL01 is joined to an Active Directory domain named domain.com. The ...
1
vote
2answers
109 views

SQL Server 2008 constantly reads MDF file, performance terrible [closed]

We have an app that runs SQL Server 2008 R2 Express on the back end on a Windows 2008 R2 virtual server running on VMWare ESXi. Users complain that the app is very slow. I see very high disk IO that ...
0
votes
0answers
125 views

Powershell Get-Counter not returning values for SQL counters

This is a cross-post from dba.stackexchange.com: http://dba.stackexchange.com/questions/64898/powershell-get-counter-not-returning-values-for-sql-counters I am attempting to use PowerShell to get ...
0
votes
1answer
61 views

Moving a MSSQL and IIS server to AWS - Web Applications that use Integrated Authentication

I have been tasked with migrating a solution that contains a few WCF services and a ASP.Net v4.0 website from individual MSSQL and IIS servers to the Amazon Web Services infrastructure. Whilst I have ...
0
votes
1answer
138 views

SQL Server Management Tools available on SQL Server 2012 express?

My goal is to access a server with some cube data and query it. If I understand correctly I need Analysis Services in order to accomplish this. My Current install of SQL Server Management Studio ...
1
vote
1answer
195 views

PHP 5.3 mssql support on Linux

I have a RHEL 5 box with php 5.3 that I am tasked with installing mssql support on. I installed php53-mssql and reloaded apache. It seems that modules were installed to /usr/lib/php/modules but my ...
1
vote
1answer
689 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 ...
3
votes
0answers
279 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 ...
1
vote
1answer
415 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 ...
3
votes
1answer
446 views

Cannot connect to SQL Server 2012 Express instance outside a VM

I'm trying to connect to a SqlServer instance - located in my host machine - from my VM, using Sql Server Management Studio. From my host I can connect to both SQL instances using SSMS, but when I ...
0
votes
1answer
30 views

SQL Server 2014 Data Collection and Exception

I am trying to create a data collection in SQL Server 2014 but when I try to run one against the disk summary it throws the following error: Exception has been thrown by the target of an invocation ...
0
votes
1answer
151 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 ...
0
votes
0answers
111 views

Diagnose dump file which causes SQL Server timeouts randomly

My SQL Server gets random timeouts some days causing the server to slow down, sites not to load, and no data coming back from SQL Server. I have this dump file below, and I am having a hard time ...
0
votes
1answer
176 views

Database Copy Fails, but nothing fishy in the logs

I am attempting to copy a database from a remote server (sql server 2008) to my local machine (running sql server express 2014). Everything looks great, right up until the job fails at "Execute SQL ...
7
votes
1answer
2k views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
0
votes
1answer
506 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
1answer
283 views

Team Foundation Server 2013 and Large SQL Tables

I have a Windows 2008 R2 virtual machine running Team Foundation Server 2013 and MS SQL Server Express. We are a small (<10 programmers) development shop and have 3-4 collections in TFS. We stood ...
0
votes
1answer
419 views

SQL Server Virtual Network Name Change Error

I am in the process of configuring a two-node failover cluster for a migration project. We are transitioning a stand-alone SQL Server to a cluster. Environment: 2x nodes with Windows Server 2012 R2 ...
0
votes
1answer
356 views

Uninstall Older Sql Server After Upgrade

Is it ok to uninstall older versions of SQL Server after an upgrade? I have 2008/2008 R2 installed, but using 2014 since it was just upgraded.
0
votes
0answers
198 views

How do you RESET the SQL Server 2008 TCP/IP Protocol settings back to default?

We have a SQL Server with multiple interfaces and a previous admin wanted to enable TCP/IP protocol to listen on a specific port. I believe that wherever he saw a specific IP address, he replaced it ...
0
votes
1answer
69 views

Is there DDL viewer role in SQL Server?

I have a user that have db_datareader role in SQL Server 2008 I need this user to be able to see Stored Procedures, functions, table scripts, etc. What role is that? I don't want user to RUN DDL ...
0
votes
1answer
1k views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
1
vote
0answers
50 views

SQL 2014 Install failed to install Data Services and SSAS, rest is installed, how to fix without uninstall?

I just installed SQL 2014 trial version, but it failed to install SQL Data Services and SSAS Services due to space issues, which have been resolved. How can I re-install only those services without ...
0
votes
0answers
81 views

SQL Server 2008 - how to set automatic ANSI to OEM conversion option

I have a product I am installing where the pre-requisite is SQL Server. The product documentation (which is quite old) talks about SQL Server 2000. However I am installing SQL Server 2008. The ...
0
votes
2answers
52 views

Configure MSSQL 2008 to use kerberos authentication

I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment . The windows station is in a workgroup and I would like to avoid ...