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)

6
votes
0answers
434 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
4
votes
0answers
395 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 ...
3
votes
0answers
34 views

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version ...
3
votes
0answers
5k views

Error connecting to MS SQL from one server but not the other

We got a MS SQL server and two web site servers. I'm in the process of moving all the sites from one of the web site servers to the new one. My asp.net sites are not able to connect to the external ...
3
votes
0answers
1k views

SQL Server 2012 Connection Timeout Expired

I am running MS-SQL Server on Windows Server 2012. From time to time I get this Exception: Server Exception : System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The ...
3
votes
0answers
560 views

Glassfish connection pool don't work after restart server

I have a connection pool in Glassfish 3.1 to connect to SqlServer 2008 Express, this pool works fine, but when Glassfish is restarted, the connection pool can't ping and stops working. To work again, ...
2
votes
0answers
8 views

Reclaiming free space in filegroup with single chronological partition

-moved here from SO (no coments there) Question: what is a proper way of reclaiming space in big (hundreds of GBs) filegroup with single partition of table that is chronologically ordered and has no ...
2
votes
0answers
1k views

Intermittent Error SQL Server Error 67 and 17

We are running Windows SQL Server 2012 Standard on Windows Server 2012. There is a SQL Database with an Access Front End which we migrated from older versions of Access and SQL. The Access front end ...
2
votes
0answers
24 views

SQL Upgrade Adviser for win2k

I'm trying to upgrade a SQL Server 2000 instance to SQL Server 2008 R2. SQL Server 2000 resides on an old win2k box, and the new SQL instance is being run on a Server 2008 R2 platform. I am attempting ...
2
votes
0answers
97 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 ...
2
votes
0answers
55 views

SQL Failover Cluster IP Migration

I have a four node cluster setup which I need to migrate from subnet A to subnet B. The cluster has roughly 12 instances running on it. I've found articles to update the SQL Cluster IP, but I've got ...
2
votes
0answers
28 views

SQL Server 2012 database availability design?

Can anyone please suggest me what is the best practice for me to follow when consolidating multiple stand alone DB from SQL Server 2005 - 2008 boxes into just 2x SQL Server 2012 Enterprise nodes in ...
2
votes
0answers
374 views

.NET + Connection to SQL Server 2008 R2

Recently, our developers have increased the Pool size in all connection strings to 8000. They are using VS 2010 Framework 4.0. In the DB side I am monitoring that up to 4000 connections is opening. ...
2
votes
0answers
142 views

Full Text Search query elapsed time varying wildly

Database Version: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 ...
2
votes
0answers
1k views

Weird bug when copying from sql server management studio to excel in windows 7

I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel. The result: two specific records are put together on one row in ...
2
votes
0answers
813 views

Visual Studio giving Microsoft SQL Server Compact 4.0 error when trying to perform any database operation

"An unexpected error occurred in the .NET Framework Data Provider for Microsoft SQL Server Compact 4.0. Please contact the provider vendor to resolve this problem." is the actual error message. I am ...
2
votes
0answers
126 views

Can encryption be disabled for the login handshake in SQL Server 2005 or 2008

When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message. For testing purposes I would like to have the login credentials ...
2
votes
0answers
917 views

SQL job cannot access Microsoft Excel DCOM application. Permissions are set. What gives?

I have a SQL job that runs a VB script that uses an object provided by the Microsoft Excel DCOM application. Excel 2003 is installed and working. Both SQL Server and SQL agent run under ...
2
votes
0answers
572 views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
1
vote
0answers
17 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
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 ...
1
vote
0answers
11 views

Should I back up full-text catalogs?

I am developing a small app for SQL Server database backup (version > 2005). I intend to use VSS snapshots (component based) to back it up and supported modes are Full & differential. Is it ...
1
vote
0answers
37 views

SSL certificate for sql-server on ec2

I have an ec2 node provisioned to host mssql server. I'm trying to request and install an ssl certificate for this node so I can securely connect to it but I can't get the certificate to appear in the ...
1
vote
0answers
93 views

How many MSDTC clustered services (if any) are needed for a multiple-instance SQL Server 2012 cluster?

I'm creating a new SQL Server 2012 cluster, running on 2 physical nodes (the O.S. is Windows Server 2012 R2); the cluster will host multiple SQL Server instances; the exact number is yet to be ...
1
vote
0answers
55 views

Why does ADFS have too many SQL connections open?

I'm running ADFS 2.0 in Windows 2008r2, connected to a SQL Server 2005 database server. Right now the ADFS server has 5623 TCP connections open to the SQL server (checked via netstat - counted with ...
1
vote
0answers
530 views

Kerberos Configuration Manager for SQL Server error “unable to access user principal information from the system”

When I launch the Kerberos Configuration Manager for SQL Server and try to connect to the local machine it's on, I am getting the error "Kerberos Configuration Manager for SQL Server error "unable to ...
1
vote
0answers
128 views

SQL Server Background Task Running?

I am developing a web application, which consists of a .NET application, using Entity Framework, and MS SQL 2012 back end. Every now and then we experience a slowdown in the system, which causes ...
1
vote
0answers
200 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
1
vote
0answers
55 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 ...
1
vote
0answers
271 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 ...
1
vote
0answers
64 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 ...
1
vote
0answers
86 views

SQL 2012 SQL server Agent Jobs

I am trying to figure out how to troubleshoot a situation with SQL Server Agent (2012). A job that has been running nightly (user SQL Server Agent as its scheduler) for over a year in 2 to 4 seconds ...
1
vote
0answers
1k views

Connecting to MSSQL server using sqlcmd and odbc driver on RHEL 6 fails

I spent the last hour trying to connect to a mssql server using sqlcmd through odbc driver. I was talking to the db guy but he doesn't seem to have a clue what is going on.. Maybe you can help me out ...
1
vote
0answers
45 views

Server network communication stalls

I'm running SBS 2008 as a file server, SQL server, IIS7 Server, and Exchange server, and very recently I am getting some very confusing stalls on it. During these "stalls," file services will cause ...
1
vote
0answers
38 views

Why is $job.LastRunOutCome always “Failed”?

I am using sqlps to run a backup job "Backup Something". Set-Location "SQLSERVER:\sql\$hostname\default\jobserver\jobs" $job = Get-ChildItem | Where-Object {$_.Name -eq "Backup Something"} ...
1
vote
0answers
164 views

SSRS reachable by FQDN on local computer, but not from a different computer

I am having trouble getting my SSRS server to successfully cohabitate with IIS, after having to move the server to a different subnet. I have 2 static IPs for that server: .242 is defined explicitly ...
1
vote
0answers
118 views

SSAS Cube load job get stuck, 32 GB RAM is fully used

System: Microsoft BI System with MSSql Server 2008 10.50.1600.1 with SSAS, SSIS and SSRS on virtual VM Server Windows Server 2008 Standard x64 with 32 GB RAM Hello, our BI System gets sometimes ...
1
vote
0answers
1k views

Configuring IIS application pool to access SQL Filestream with ApplicationPoolIdentity

I have an IIS 7.5 server with a number of applications in a single Application Pool. Some of these applications access a SQL Server 2008 R2 Filestream on a remote machine, on the same domain. The ...
1
vote
0answers
87 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
1
vote
0answers
251 views

How to index document files in NAS storage?

I'm currently developing an application that have to index document files (.pdf and .doc) which are in NAS storage. After that I want to query them over the application. My customer does not want to ...
1
vote
0answers
1k views

SQL Server Replication Requires the actual server name

How Hard can it be? Ive spent the last 4 hours googling just to find either nothing works, or people randomly posting information that 'sounds good' My setup: Two SQL2012 Servers, in two different ...
1
vote
0answers
516 views

SSMS stuck scripting database objects

SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database. i scripted all the objects in an SQL Server 2008 database from ...
1
vote
0answers
141 views

Recreate Dynamcis CRM “Filtered Views” for use on SQL server replicated by Scribe RS

I'm considering moving from CRM 2011 on premise to CRM Online. The major concern for me is the lack of SQL access, but I understand Scribe RS has a replication solution that will keep a copy of the ...
1
vote
0answers
503 views

ASP.NET + MVC 4 + IIS 7 + MSSQL slow response

I have recently deployed an ASP.NET MVC4 application to a IIS 7 server, but something is not quite right. I have a log-in action that access the user credentials stored in a MSSQL 2008 R2 server, and ...
1
vote
0answers
605 views

SQL Reporting Services Report Manager cannot be accessed by IP on the local computer

I have set up SQL Express 2012 with Advanced Services on a test machine. The requirements are that ReportServer should run on a dedicated IP address and port. So I went to Reporting Services ...
1
vote
0answers
32 views

SQL Server Logs: missing date ranges

I need to be able to export SQL Server logs into CSV files, which I can easily do with the export function. However in doing so I've noticed there's a range of dates missing from the SQL Server logs ...
1
vote
0answers
293 views

SQL Server Keeps Logging/Writing to 'Setup Bootstrap' folder

I recently got a message from windows that my system was running out of disk space. After a quick search across the file system, I found out the SQL Server had logged 10GB of info in the folder ...
1
vote
0answers
245 views

Can I tune my Debian KVM server to benefit my Windows guest?

Debian Squeeze KVM server with Win2k8 server guest. The server has 16GBs of RAM and the guest only runs MS SQL, with a 15GB database on it. I am wondering if there is anything I can tune from the ...
1
vote
0answers
395 views

Dynamically Insert single record into MS access from SQL server

I have two databases(SQlserver and MS Access) with same schemas (same tables). SQL server database has data but Access has no data (blank database). My goal : when user enters a ClientId and click ...
1
vote
0answers
565 views

Compressed network file copy

I have 200 GB of SQL Server files I need to copy over a 100 Mbit connection. Assuming maximum throughput that will take five hours. SQL Server files compress very well, generally in the 80 - 90% ...