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)

5
votes
0answers
269 views

Database Backup and Full-Text Search

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

Mirrored local accounts to connect to database on different server and domain

My database client and database server are on different machines and are not connected to the same domain (this is not supported with my web host). I'm not keen to send username/password details via a ...
2
votes
0answers
133 views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
2
votes
0answers
35 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
22 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
292 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 ...
2
votes
0answers
124 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
2k views

Why can't I connect on port 445?

I need to collect baseline performance data on a SQL Server running on Windows Server 2008 R2. When I open perfmon on my computer running Windows 7 and try to add counters from the remote server, I ...
2
votes
0answers
635 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
749 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
419 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
19 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
31 views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
1
vote
0answers
24 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
25 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
55 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
360 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
79 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
125 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. ...
1
vote
0answers
113 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
306 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
173 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
88 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
303 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
294 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
30 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
163 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
183 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
251 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% ...
1
vote
0answers
199 views

SQL Server 2008 R2 cluster on Windows Server 20008 R2 issue

I have a SQL Server 2008 R2 cluster on Windows Server 20008 R2. There are 2 nodes node1 and node2 in the cluster. When I start node1 and node2, I get the following statue information from them: From ...
1
vote
0answers
63 views

SQL Server related perfmon counter porting 0 on remote machine

I'm trying to monitor a remote SQL Server via perfmon but all SQL related counters are reading 0. What works: On the target Windows Server 2008 running Microsoft SQL Server 2008 R2, reading both ...
1
vote
0answers
134 views

Amazon Cloud Services for Disaster Recovery

To simplify our environment, at it's most atomic level, we have a .NET website running on IIS 6 on one server and the website depends on data from a MS SQL 2005 database on another server. We have ...
1
vote
0answers
276 views

Installing SQL Server Compact 3.5 SP2 *after* installing SQL 2012 RC0 - machine.config path include double slashes?

I'm trying to install SQL Compact 3.5 SP2 after I've installed SQL 2012 RC0, on a x64 Windows 7. The x86 installer goes through fine. The x64 installer fails, with the error: "Error ...
1
vote
0answers
1k views

“Operating system error 1394” - How can I prevent it?

I get occasional and random failures of my SQL Server backups with the error message Operating system error 1394 Does anyone know why this error occurs and how I can prevent it? A little Googling ...
1
vote
0answers
446 views

SQLServerAgent could not be started (reason: Unable to connect to server ) Error 103?

Does anyone know how to make the second SQL instance Agent working on the same MSCS SQL Server 2008 R2 cluster? In the clustered SQL Server service instance2 i have assigned the same service account ...
1
vote
0answers
136 views

Trying to connect to sql server on ec2

I moved from my home office to an office in midtown. I can't figure out how to connect to my sql server hosted on Amazon. I'm using the exact same VmWare image just on a machine in the office. I can ...
1
vote
0answers
46 views

Possible to view/edit SQLServer Merge replication queue?

we're experiencing a problem that seems to be blocking the merge process. An old Stored Proc (that has since been removed from the publisher) is trying to run on a subscriber. We've tried ...
1
vote
0answers
1k views

Unable to authenticate proxy when starting SQL snapshot agent

I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied, I have restored a database from an old image (SQL 2005) and am trying to get web-sync ...
1
vote
0answers
111 views

SQL Server logs empty?

In the SQL Server Management Studio in Management I can view the SQL Server Logs. I "inherited" a server where this Log is always empty. I'd guess my predecessor somehow disabled the SQL Server Log. ...
1
vote
0answers
133 views

Identity Range Management problem

Recently upgraded from SQL Server 2000 to 2008. When we recreated the Merge Replication we decided to use Automatic Identity Range Management (since it is now the default in 2008). The problem is ...
1
vote
0answers
80 views

SQL Server 2008 R2 installation error

when I install SQL Server 2008 R2, I get this error. Why? http://i52.tinypic.com/2ik4c47.jpg
1
vote
0answers
282 views

SSIS on W2K8 R2, SQL Server 2008 SP2 and Oracle

I'm in the process of migrating an old SQL Server 2000 SP4 on Windows 2000 to a new SQL Server 2008 SP2 on Windows 2008. In the old server we have a DTS that does some simple tasks against an Oracle ...
1
vote
0answers
540 views

TFS Reporting Services Configuration Error - The RPC Server is Unavailable

I'm trying to configure Team Foundation Reporting but without any success. The App Tier and the Data Tier are in separate servers. I guess it's not a port/firewall problem, because I opened port ...
1
vote
0answers
273 views

asp.net mvc - membership provider

For my ASP.NET MVC app, I just find dealing with unique-identifiers harder, so I have added my own field to ASPNET_USERS table - UserIdInt (which is actually a bigint!) So most of user operations use ...
1
vote
0answers
117 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 ...
1
vote
0answers
220 views

Error upgrading fromSQL Server 2008 to R2

Im trying to upgrade to SQL Server 2008 R2 from SQL Server 2008 on Windows Server 2008, but when the wizard is installing the Setup Support Files I alway get the next error: "An error occurred during ...
1
vote
0answers
463 views

Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column

Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column I’ve been trying to understand some strange values in the RESOURCE_ASSOCIATED_ENTITY_ID column of SYS.DM_TRAN_LOCKS when ...
1
vote
0answers
88 views

Problem with MSDE 2000 5 minute keepalive over ISDN

We have a SQL Server transactionally pushing replicate data to an MSDE 2000 SP3a subscriber over ISDN. Prior to a recent upgrade to bring us to the MSDE 2000 level we pushed to MSDE 1. We are finding ...
1
vote
0answers
406 views

How to create full-text catalog as default catalog?

This would save me the redundant ON MyCatalog phrase when I create full-text indices. For example, CREATE FULLTEXT INDEX ON MyTable ( MyField1, MyField2, MyField3 ) KEY INDEX PK_MyKey ON ...