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)

5
votes
0answers
7k 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 ...
4
votes
0answers
341 views

Windows Authentication to a Remote Server within an Intranet Environment

I have several servers (all on the same DC) within an Intranet environment at my company. For simplicity, I'll focus my question on the IIS and SQL Servers. I have an IIS 7.5 web server and a remote ...
4
votes
0answers
159 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 ...
4
votes
0answers
815 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, ...
3
votes
0answers
446 views

Why am I getting “RESTORE DATABASE TERMINATED ABNORMALLY” (Error 3013) when restoring from Azure Blob Storage to SQL Server 2014

Our production database server is backing up its databases nightly to Azure Blob Storage, using the BACKUP TO URL command in SQL Server 2014 Standard. I'm now attempting to restore those backups to a ...
3
votes
0answers
70 views

SQL server and PHP restart

i have Apache/PHP running on a server running windows 7 with SQL server 2008 r2 running on windows Server 2008. When SQL is restarted Apache/php will no longer connect to SQL once it is back up ...
3
votes
0answers
66 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 ...
3
votes
0answers
2k 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
1k 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 mydomain\...
2
votes
0answers
33 views

SQL Server without memory reservation completely hangs

We are currently experiencing failures on our SQL Server machines. It appears that once a server on the same (VMWare) host as our SQL Servers starts a maintenance procedure. The SQL Servers will ...
2
votes
0answers
953 views

Connecting to MS SQL Server using FreeTDS: Error 20002: “Adaptive Server connection failed”

I am trying to use FreeTDS to connect from a Linux server (RHEL v7) to a separate server running MS SQL Server 2014. However, when attempting to connect with tsql I get the following errors (error ...
2
votes
0answers
306 views

The wait operation timed out

I have encountered this problem when running a Data-fill routine for a Data-set Data-adapter in C# which uses a stored procedure written in SQL Server Azure. The SQL Server stored procedure executed ...
2
votes
0answers
87 views

Constrained Delegation between IIS, SQL Server, SSRS and File System

First of all, not sure which site is best suited for this question be it SO, SF or SU so please feel free to suggest migration! I have a requirement to constrain delegation between several machines ...
2
votes
0answers
3k 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
27 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
182 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
3k 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 ...
2
votes
0answers
78 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
32 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
486 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
1k 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 ...
2
votes
0answers
159 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

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 Excel....
2
votes
0answers
2k 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 ...
2
votes
0answers
984 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
133 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
44 views

Deployment fails for SQL Server 2014 SP1 Standard on Windows Server 2012 R2 VM

Apologize in advance - this stuff isn't exactly my wheelhouse. I'm trying to provision a VM with Windows Server 2012 R2 and setup SQL Server 2014 SP1 Standard using the Azure portal. I pretty much ...
1
vote
0answers
19 views

Certificate is not showing up in SQL Server

I need to say first that I am not a DBA and so, my problem is getting SQL Server Configuration Manager to recognize a certificate. I have 3 SQL Instances I work on, 2 are on the same network, the ...
1
vote
0answers
38 views

Move Azure SQL database server between subscriptions

We have two subscriptions (DEV and PROD). A database server has been deployed to the DEV subscription, but it is now in use by our production system. I want to move the Azure SQL database server to ...
1
vote
0answers
66 views

SQL Server Agent job run as: permissions

I have a number of SQL Server Agent jobs running CmdExec statements. They are simple jobs that call simple batch files. They are run with a Run As: Proxy account, that has permissions to run as a ...
1
vote
0answers
25 views

Strange error in SQL Server from ASP.NET app

I posted this question on stack overflow, but to no avail. Getting desperate here. So we have an extremely random error (by which I mean, there appears to be no usage pattern that precedes the error) ...
1
vote
0answers
12 views

How do I stop SSRS from sending any missed reports when starting the service?

We fired up a test SSRS service that hasn't run for a couple of months. It appears that it has decided to send all reports where it has missed the schedule (so any report that didn't send since it was ...
1
vote
0answers
55 views

Connecting SSIS to AWS RDS SQL Server Instance

I am trying to connect SSIS to an AWS RDS SQL Server instance. Whenever I try to run the packages through the SQL Server Agent, I encounter this error message: Non-SysAdmins have been denied ...
1
vote
0answers
16 views

Can connect to MSSQL 11 with SQL Auth, but can't connect with the same credentials to “import and export” wizard

I'm connecting to a MSSql 11.0.2100 server named "server" with a user named "user" via SQL auth. When I try the exact same credentials in the "import and export" wizard, the connection fails with: ...
1
vote
0answers
282 views

Cannot connect to sql server by IP Address but using the hostname works

After upgrading to the newest version of windows (windows 10 build 10586) I am no longer able to connect to a remote sql server by ip address. Here is the error I see: [SqlException (0x80131904): ...
1
vote
0answers
13 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...
1
vote
0answers
61 views

Creating an assymmetric key inside SQL server to access a DLL fails

I need to access a DLL (C#) from SQL trigger for one of our requirements. I have compiled the DLL and could load it in SQL server space by using the "Create Assembly" and then create a trigger for it. ...
1
vote
0answers
74 views

SQL Server VSS writer interfering with VMWare snapshots

After changing to TSM for the VMWare backups, we've started experiencing an odd issue with our Snapshot backups. We take system drive snapshots as a backup solution for the machine states. All the ...
1
vote
0answers
112 views

Error when viewing database mirroring monitor in SQL Server with non-default port

I have database mirroring set up (with witness) on SQL Server 2014 Standard. Both servers use default instance on a non-default port (not 1433). Mirroring works perfectly fine. However, when I try to ...
1
vote
0answers
47 views

SQL Server Windows authentication - username not changed

I've recently changed my PC name and Windows user account as well. Before: OLDPCNAME\oldusername After: NEWPCNAME\newusername When I log in to my SQL Server management studio using Windows ...
1
vote
0answers
51 views

Installing SSDT on Windows Server 2008 R2 SP1

I'm trying to install SQL Server Data Tools on a Windows Server 2008 R2 SP1 machine. I'm getting the following error: I've tried using both the .exe file and the ISO. I'm getting my files from here:...
1
vote
0answers
103 views

Is it safe to back up SQL Server data directly if using VSS?

I have a client with a very basic single server setup that includes a small SQL Server Express database. I recently configured Symantec Backup Exec 2010 Quickstart edition for them. This is the free,...
1
vote
0answers
3k views

PostgreSQL - Invalid byte sequence for encoding “UTF8”: 0xe7 0x75 0x20

Here is the problem : Everything worked fine with my postgresql system until I decided to click on the "rotate logs" button in the server status tab (from pgAdmin). After that, I faced this issue, ...
1
vote
0answers
61 views

MS SQL Server data lost or corrupted

I have a situation regarding MS SQL Server database. My friend ask me to repair a certain database, because a range of data has been lost after a hard disk failure, but eventually after ...
1
vote
0answers
16 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
76 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
500 views

Volume Shadow Copy Service error: Unexpected error calling routine XML document is too long. hr = 0x80070018

I have about 1400 SQL databases on my environment (on 3 different volumes). I've got follow errors during taking VSS snap. Also SQLWriter goes from stable to failed "nonretryable" *Event ID 8193, ...
1
vote
0answers
192 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 defined,...
1
vote
0answers
138 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
319 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 ...