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)

4
votes
0answers
127 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
74 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
6k 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
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 ...
4
votes
0answers
633 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
35 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
32 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
985 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
2k 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
25 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
130 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
58 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
31 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
428 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
149 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
875 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
132 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
616 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
35 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
13 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 ...
1
vote
0answers
22 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 ...
1
vote
0answers
415 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
47 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
65 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
13 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
54 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
120 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
80 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
907 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
194 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
267 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
61 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
337 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
78 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
96 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
2k 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
50 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
41 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
219 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
144 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
2k 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
89 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
303 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
710 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
164 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
562 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
669 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
34 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 ...