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)

4
votes
3answers
2k views

Tracking SQL Server 2008 Timeout Errors

we got some connections timeouts running a stored procedure in a SQL Server 2008 instance. after a while, the DB started to work as usual, and there weren't any additional timeout errors. So I'm ...
1
vote
2answers
2k views

Some rows giving “String or binary data would be truncated” error when editing in Management Studio

When trying to add data to a newly created column using SQL Server Management Studio (edit rows), I am getting the following error: No row was updated. The data in row 1 was not committed. ...
2
votes
3answers
2k views

How to diagnose repeated “Starting up database '<dbname>'”

I have a SQL 2008 server which is predominantly used as a development server, in the last two weeks it has been having occasional "fits", I have isolated the cause of these fits as CHECKDB being run ...
1
vote
1answer
129 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 ...
0
votes
0answers
203 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) ...
2
votes
2answers
723 views

SQL Server remote backup query fails “cannot open the backup device”

I am trying to configure my scheduled backups of a MSSQL database to a mapped network drive, which is on a fileserver running Server 2003 Standard. Query reads like this: BACKUP DATABASE XXXX TO ...
3
votes
1answer
271 views

Getting data out of a Suspect database

We had a power outage and one of our SQL 2000 databases is marked as suspect. We have a backup, but it's more than a day old (power outage happened just before the backup was scheduled) and we'd ...
1
vote
1answer
329 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
49 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 ...
4
votes
12answers
16k views

SQL Server database on an external hard disk drive

Due to some security problems, My boss has asked me to store all sensitive data in external/removable storages like USB stick or external HDD and this specially includes the MDF/NDF/LDF files of SQL ...
0
votes
1answer
108 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 ...
0
votes
0answers
35 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 ...
0
votes
0answers
735 views

sql script not running from task scheduler

I'm trying to run a MS SQL Server backup from the Task Scheduler (Windows Vista, MS SQL Server Express 2005) If I run the script manually (open the cmd and execute the script) it works. If I add the ...
3
votes
1answer
267 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 ...
2
votes
1answer
144 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
345 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 ...
3
votes
4answers
7k views

MSSQL error: consistency-based I/O error - can it be caused by an MSSQL or OS problem?

This is what I saw in the windows error log: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x19fedd20; actual: 0x19fed5e3). It occurred during a ...
0
votes
2answers
58 views

Resources for SQL Server programming?

I have tried to search from the web resources for SQL Server programming. Basically I'm trying to search good tutorial for programming SQL Server (creating procedures, triggers, cursors etc.). Can you ...
1
vote
2answers
84 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
104 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
43 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 ...
1
vote
1answer
125 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 ...
0
votes
1answer
77 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 ...
2
votes
0answers
71 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 ...
9
votes
1answer
17k views

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
1
vote
2answers
1k views

What information about errors can MSSQL profiler report on?

I have a feeling a SQL client application is timing out, but because of how the application is coded, there's no way of telling. So I was hoping that running MSSQL profiler on the server would ...
1
vote
1answer
185 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 ...
1
vote
3answers
7k views

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of ...
0
votes
1answer
679 views

SQL Server 2008 installation (not working)

I'm trying to install SQL Server 2008, but have been unable to do so. I've tried uninstalling and even manual un-installation. I've tried following this guide ...
3
votes
2answers
2k views

SQL Server running under a domain account cannot register its SPN

I am trying to configure a fresh install of SQL Server to run under a domain account. However, I get intermittent errors when trying to connect to the server using another domain account, and I still ...
1
vote
3answers
4k views

MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out

The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains ...
0
votes
1answer
27 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
2answers
780 views

SQL Maintenance Cleanup Task Working but Not Deleting

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 days. When I run the job, it gives me a success message but older .bak files are still ...
0
votes
2answers
882 views

Where are the SQLServer jobs stored?

I'd like to know what is the process a SqlServer job is executing, but I only can find that it calls DTSRun with an encrypted string. After decoding the string, it results is just the name of the job ...
0
votes
1answer
87 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
71 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 ...
1
vote
4answers
482 views

TCPing reports 20ms latency between Web Farm and DB

We have a IIS web farm sitting in a DMZ connecting to a MSSQL DB(Windows Cluster). After troubleshooting some performance problems we stumbled upon strange network behavior. We wanted to test network ...
3
votes
2answers
2k views

Can't connect remotely to SQLServer Express 2008 on AWS EC2 instance using SSMS

Every time I try and connect to a remote SQLServer Express instance on my AWS server I get a network or instance specific error. What I have tried so far: I ensured that the Security Group applied ...
0
votes
1answer
2k views

SQL Server 2008 R2 Transactional replication ports

http://technet.microsoft.com/en-us/library/cc646023.aspx states Replication connections to SQL Server use the typical regular Database Engine ports (TCP port 1433 for the default instance, etc.) ...
7
votes
1answer
1k 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
256 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
167 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
206 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
200 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.
2
votes
3answers
999 views

SQl Server - Which Inventory Tool ( Free )

I would like to get an inventory of all SQL Servers in my office and pertinent meta information about them. Need things like Version#, Instances, isClustered etc... I prefer to automate this and ...
1
vote
2answers
769 views

Weird behavior using Active Directory group mapped to SQL Server user/login

I've run across a very odd behavior on SQL Server 2008R2. I have a third-party application which acts as a SQL Server client. I have a subset of my users who should have access to this application. ...
0
votes
4answers
992 views

SET RECOVERY Model Using sp_msforeachdb

I wanted to build a script that sets the RECOVERY MODE for each user database to SIMPLE and put it into an agent job for my dev servers. It seemed simple (sorry for the pun): EXEC sp_msforeachdb ...
0
votes
1answer
1k views

SQL Server Issue: Could not allocate space for object … primary filegroup is full

Trying to figure out a problem at an office that has SQL Server 2005 installed on Windows SBS Server 2008. Here's the setup: It's an office, and the person who set this all up is nowhere to be ...
0
votes
1answer
45 views

Amazon EC2 Windows with Sql Server Web, changed to an instance with just Windows no SQL Server?

If I start a windows AMI with Sql Server Web, this will include a licensed Sql Server Web installation. What will happen if I then create a Windows only AMI instance and connect the volume with Sql ...
0
votes
0answers
107 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 ...