Questions tagged [sql-server]

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.

715 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
10
votes
1answer
4k views

Parallel Redo Is Shutdown

When looking in Windows event logs, i'm seeing the following messages on an almost continuous basis - Starting up database 'Database'. Parallel redo is started for database 'Database' with worker ...
7
votes
2answers
4k views

Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps'

I've tried reinstalling 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 ...
6
votes
1answer
662 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 ...
5
votes
3answers
7k views

RDS 2012R2: RD Connection Broker HA - cannot connect to SQL

I have a brand new RDS environment I am trying to set up. I'm trying to follow this guide: https://msfreaks.wordpress.com/2013/12/09/windows-2012-r2-remote-desktop-services-part-1/ and have gotten ...
5
votes
1answer
10k 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 ...
5
votes
0answers
1k 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, ...
5
votes
2answers
5k views

IIS 7.5 web application failing with NT Authority\Anonymous Logon

I am finding various google results, but none seem to fix my problem. I am setting up a new WINDOWS 2008 R2 box at work that is to communicate with an existing SQL 2012 box via web tools running in ...
4
votes
0answers
1k 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
134 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 ...
4
votes
1answer
712 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
3answers
9k 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 ...
4
votes
1answer
1k views

Distributed and/or Parallel SSIS processing

Background: Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
4
votes
1answer
3k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
4
votes
2answers
4k views

How to set up Zabbix to monitor SQL Server Failover Active-Passive Cluster?

It should be simple, so it is just most likely my approach being totally off and someone will hopefully prod me into the right direction. We have a Zabbix 2.0.3 server instance set up monitoring a ...
3
votes
1answer
1k views

IIS and SQL Server Windows authentication in a django application

I am trying to run a django website which connects to a SQL Server, using IIS with Windows authentication. IIS server and SQL server are on different machines under the same domain i.e., iis_machine....
3
votes
0answers
384 views

Issue affecting general performance in Server 2012 R2

Back in 2016, We deployed a solution for one of our customers that was an Windows 2012 R2 RDS solution with 2 session host servers, a web server, a couple of file servers, a SQL server and an exchange ...
3
votes
1answer
304 views

Hyper-V host consuming available memory

I'm a bit new to configuring Hyper-V so this could be a simple question for someone, but I am in need of some advice. I have a Hyper-V host server with 128GB RAM, and all of this RAM is being ...
3
votes
0answers
283 views

MSSQL Server 2012 (not R2) maxing out CPU (98-100%) with svchost (wuaueng.dll)

Spent a fair bit of yesterday trying to find a solution for this, but this issue appears to only affect Server 2008...well, I beg to differ! MSSQL, hosted on Server 2012. Updated via WSUS. Enabled ...
3
votes
2answers
401 views

Configured Azure Backup sends me a health check report every 15 minutes

I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via EXEC msdb.smart_admin.sp_set_parameter @parameter_name = '...
3
votes
0answers
759 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): ...
3
votes
0answers
2k 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
474 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 ...
3
votes
1answer
882 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
3
votes
1answer
7k 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 ...
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
3k 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 ...
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\...
3
votes
1answer
7k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
2
votes
0answers
116 views

ODBC Driver 17 for SQL Server

Morning, Some background: Recently upgraded database and web servers from Server 2008R2 => 2016 OS Recently upgraded database instances from SQL Server 2008R2 => 2016 Recently upgraded the ODBC ...
2
votes
1answer
662 views

Blue question mark on SQL server and SQL server agent?

I just installed MS SQL server 2017 on MS Server 2019. All installation process were fine. Using SSMS 18 access SQL server locally was fine, no issue at all. But when I use SSMS 18 connecting SQL ...
2
votes
0answers
92 views

Can I use a gMSA for stored credentials in a SSRS data source?

I have an instance of SQL Server 2016 Reporting Services service running under DOMAIN\reporting$ containing a data source that needs to query a database using the stored credential DOMAIN\database$. ...
2
votes
0answers
203 views

MSSQL Server 2017 on Centos - AD auth - SSPI handshake failed

We have SQL Server 2017 installed on CentOS and connected to domain according to this tutorial - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication?view=sql-...
2
votes
0answers
103 views

How does DPAPI protect the master key for a service account?

I am trying to understand the security of TDE for MSSQL. The documentation says it relies on Windows DPAPI. DPAPI generates a master key using a user's credentials. This works well for human users ...
2
votes
0answers
597 views

Use SSH Tunnel with MSSQL

An owner of a MS SQL db has allowed access to their db from an IP address of a remote machine I own. I can SSH into that machine and connect to the DB using: ssh -i my.pem 100.0.0.100 sqlcmd -...
2
votes
0answers
185 views

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL ...
2
votes
0answers
311 views

Cannot Connect to Azure Database from Azure Web Application

We have a SQL Server database in Azure. In the same resource group is an App Service. The App service connects to the database, using the connection string: Server=tcp:[server].database.windows.net,...
2
votes
0answers
669 views

Importing BACPAC via SSMS to Azure SQL Server fails with AzureAD user

Recently, trying to import a BACPAC to an Azure SQL Server using SSMS (SQL Server Management Studio) has been failing with the following error: Failed to connect to server ___.database.windows.net. ...
2
votes
0answers
126 views

Bizarre SQL SRS error when trying to access SCCM reporting reports

In case this is an X-Y problem, what I'm trying to do is grab logs from SQL Server Reporting Services to tell me who did a couple horrible things in our SCCM environment - 1) deploying a rather large ...
2
votes
1answer
677 views

In a Server migration / move, Do I need to rename my Windows Server name if I change the Server name to Alias (CNAME) my new Server?

Hi I have an existing and new server that are part of a windows domain. I want to redirect network traffic to the new server and keep the existing one online short-term then offline it after a few ...
2
votes
3answers
6k views

Authentication of a AD user in SQL Management Studio

I'm struggling couple of days with the following issue. I'm want to let people, that are a member of a AD authentication with their username/password on SQL Management Studio 17.x but I cannot use ...
2
votes
0answers
144 views

SQL Server 2014 SP2 does not start on Windows Docker

I want to install and use SQL Server 2014 SP2 on Windows Docker. But the SQL Server service does not start. Steps to reproduce: Download "Microsoft SQL Server 2014 Service Pack 2 (SP2) Express" ...
2
votes
1answer
793 views

SQL Server 2012 installation shared feature directory and instance root directory

During installation, is it ok to choose different Drives (say D and E) for Installation shared feature directory and Instance root directory or they should be on the same drive, or should any of them ...
2
votes
0answers
2k views

Does SQL Server 2016 Support Windows Server 2016 Essentials?

The Requirements for SQL Server 2016 list the following operating systems as being supported: Windows Server 2016 Datacenter Windows Server 2016 Standard Windows Server 2012 R2 Datacenter Windows ...
2
votes
1answer
3k views

Cant connect to sql server database using ip

I've created a sql server database on server A. I was always using Windows Authentication to connect, but now I want to connect to database from server B. Then, I added a new user to database and ...
2
votes
1answer
755 views

SQL Mirror failing on setup

I've got two SQL servers, I need to mirror a database from one to the other. Should be straight forward, two servers no witness. Both servers are running the same edition of MS SQL Std 2014 The SQL ...
2
votes
1answer
33 views

RemoteApp: Can one be sure that no unwanted programs are started?

Back story: In our company, we bought a client/server process management software from which the client directly communicates with an SQL server. This is in my opinion a major security flaw, because ...
2
votes
0answers
936 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
487 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
1answer
463 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,...
2
votes
0answers
29 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 ...