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
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
2
votes
2answers
2k views

Can't Start SQL Server 2005 Agent - Start/Stop Are Not Enabled

We have a brand new install of SQL Server 2005 on a Windows 2008 Server. When using the SQL Server Management Studio (2005 or 2008) from my Windows XP Professional workstation, if I right click on the ...
0
votes
2answers
101 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 ...
12
votes
3answers
3k views

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a ...
0
votes
4answers
288 views

SQL Database is in Suspected Mode

I found that database is in Suspected Mode ...... How Can I Recover it from this Mode.
0
votes
1answer
80 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 ...
1
vote
1answer
207 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
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
1k 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 ...
2
votes
2answers
11k views

MS SQL Server 2005: Fatal error 823

A MS SQL Server - Database that worked fine for the last weeks suddenly threw the following error: System.Data.SqlClient.SqlException: Warning: Fatal error 823 occurred at date / time Note the ...
1
vote
1answer
63 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
94 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
469 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
267 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
168 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
40 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
15k 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
69 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
24 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
627 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
152 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
106 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
134 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
6k 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
61 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
75 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
31 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
82 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
41 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
26 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
16k 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
73 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
6k 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
650 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
1k 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
25 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
698 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
831 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
48 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
45 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
447 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
666 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
130 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
100 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 ...