21,616 questions with SQL Server-related tags

Sort by: Updated
1 answer

Quiero descargar SMSS

¿Cómo descargo SSMS, estuve intentando y no me deja, además no me aparece la opción de: "Descarga de SMSS"?

SQL Server Database Engine
asked 2026-06-08T17:06:39.55+00:00
Rosita 0 Reputation points
answered 2026-06-08T21:06:13.5666667+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
4 answers

Prevent a thick-client app's Windows user from accessing the local SQL Express DB outside the app

Setup: A Windows desktop app runs on non-admin workstations. It uses a local SQL Server Express instance on the same machine over shared memory. The app connects to SQL using the logged-in Windows user's own identity (the app process runs as that…

SQL Server Database Engine
asked 2026-06-04T13:03:09.61+00:00
Mansoor R 0 Reputation points
commented 2026-06-08T21:00:01.0566667+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
3 answers

Microsoft SQL Server 2022 - no TCP/IP connection in client protocols in SQLServer Configuration Manager

Hello, since SQL Server 2022 Standard edition I miss in "SQL Server Configuration Manager" under "client protocols" all protocols e.g. "TCP/IP", to enable client connection to the Database. Also I can not create manually a…

SQL Server Database Engine
asked 2026-05-26T06:58:27.8+00:00
Lackner, Mario 0 Reputation points
commented 2026-06-08T20:54:51.9266667+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
1 answer

Unable to install SQL Express

I get the following error when trying to install SQL Server Express: Oops... Unable to install SQL Server (setup.exe) Exit code (Decimal):-2061893606 Error Description: Wait on Database Engine recover handle failed

SQL Server Database Engine
asked 2025-11-03T16:21:04.7733333+00:00
John McKenna 0 Reputation points
commented 2026-06-08T20:48:19.75+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
2 answers

Test connection failed because of an error in initializing provider. The given key was not present in the dictionary.

I am getting this error VS2022 and VS2026 when tried to create a connection from ssis project with connection manager. SQL server version is Microsoft SQL Server 2022 (RTM-GDR) (KB5073031) - 16.0.1165.1 (X64) Nov 24 2025 19:08:45. It was working…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 questions
asked 2026-06-05T12:17:08.24+00:00
SB 0 Reputation points
commented 2026-06-08T15:40:55.9933333+00:00
Deepesh Dhake 80 Reputation points
1 answer

Disaster recovery license for SQL 2022 WSFC cluster

Hi all, I'm new to SQL, so I'd like to ask you a question about SQL licensing for a DR site. I have a WSFC for SQL Server 2022 in production with its own license. My question is: for a possible SQL cluster in the Disaster recovery site, is it possible to…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2026-06-08T10:11:50.3233333+00:00
Rezzani Marco 0 Reputation points
answered 2026-06-08T11:18:03.1533333+00:00
Marcin Policht 91,390 Reputation points MVP Volunteer Moderator
1 answer

How to find the installation file for an older version of SQL Server Migration Assistant?

I need to migrate an Oracle database to SQL Server, but the current Oracle version is 11g, which is not supported by the latest version of SSMA for Oracle. How can I install a version of SQL Server Migration Assistant that supports Oracle 11g? SSMA for…

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

606 questions
asked 2025-03-13T05:19:50.34+00:00
Vinh Dang Khanh 10 Reputation points
commented 2026-06-08T08:46:45.18+00:00
Cam Boxall 0 Reputation points
2 answers

Symmetric key alter issue in SQL Server 2025

Context: I am using SQL Server 2025 with symmetric keys protected by a certificate, and I encrypt/decrypt data using the EncryptByKey and DecryptByKey functions. I now need to migrate the symmetric key protection to Azure Key Vault. However, while…

SQL Server Database Engine
asked 2026-06-01T14:17:15.8166667+00:00
Dipak Nile 0 Reputation points
commented 2026-06-08T06:28:09.0266667+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
1 answer

Confirmation on Maintenance Plan DLL Usage for SQL Server 2025

Hello Team, Earlier, till SQL Server 2022 (version up to 16) we were compiling our Maintenance Plan source code project by referencing the required DLLs from the GAC. However, for SQL Server 2025 (version 17), based on our analysis of the…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 questions
asked 2026-05-25T14:13:00.8+00:00
Abhishek Modi (amodi) 20 Reputation points
recommended 2026-06-08T06:08:09+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

Performance Degradation after moving from SQL 2019 to SQL 2025

I am in the processing of upgrading our SQL environment from 2019 to 2025. We are troubleshooting perf issues in our pre prod env right now before upgrading production and I have a fairly simple query that loads 1.6m rows to a temp table and typically…

SQL Server Database Engine
asked 2026-05-07T17:39:23.1566667+00:00
Mantini, Ronald M 6 Reputation points
commented 2026-06-08T06:06:20.86+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
1 answer

BULK INSERT cannot access UNC path, error code 5 (Access is denied) using gMSA unless locally triggered

Running a stored procedure to bulk insert from a UNC path works locally via SSMS and via SQL agent job but if run remotely I receive Operating system error code 5 (access is denied). Please help as this workaround is not suitable for our…

SQL Server | SQL Server Transact-SQL
asked 2026-04-28T02:03:11.9766667+00:00
Michelle 0 Reputation points
commented 2026-06-08T05:49:06.44+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
1 answer

The SQL server 2019 installation failed in Windows Server 2025.

The SQL server 2019 installation failed in Windows Server 2025. From the logs, we understood that, installation fails because Microsoft Visual Studio Tools for Applications (VSTA) 2017 - a dependency of the Integration Services (SSIS) feature - crashes…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 questions
asked 2026-04-22T07:15:56.7+00:00
Siji, Merlin 0 Reputation points
commented 2026-06-08T05:24:29.31+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
1 answer

SSRS URL certificate renewal

The SQL Server certificate associated with the SSRS URLs will expire on June 26th. A replacement certificate has been installed on the SQL Server, but instructions are needed for correctly binding it to the SSRS URLs. Could you please advise whether…

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

3,162 questions
asked 2025-06-23T17:39:41.2266667+00:00
Gaddam Abhishek Reddy 0 Reputation points
commented 2026-06-08T05:13:01.5166667+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
1 answer

Deployed SSIS package has access denied to file directories and work fine in VS

I’ve tested a couple of things out with different packages that have been deployed to SQL Server. I noticed that within the same package, I can have a script task which fails to connect to a file directory but I don’t have an issue with connecting a flat…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 questions
asked 2025-06-02T15:38:53.3733333+00:00
Apostolu, Chris 0 Reputation points
commented 2026-06-08T05:11:34.33+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
1 answer

Facing an issue while Export/Backup SQL Database

While taking backup of an existing SQL Database using Export Database option, observed that its taking too much times in hours. After 3-4 hrs as well its showing progress of just 1% only. So want support for the same that what could be the reason behind…

SQL Server Database Engine
asked 2025-04-14T10:14:50.65+00:00
Gravitive Service 0 Reputation points
commented 2026-06-08T05:10:13.3+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
0 answers

How to find the previous versions of SSMA for Oracle

Hi Team , Can you please let us know how to find the previous version of SSMA ? Thanks! Seshu

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

606 questions
asked 2021-08-23T17:10:46.15+00:00
commented 2026-06-07T07:46:18.0066667+00:00
Cam Boxall 0 Reputation points
2 answers

Official request to obtain the installer for SSMA for Oracle v7.x

Since the source environment is a legacy Oracle 10g, I would like to obtain the installer for SSMA for Oracle v7.x.

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

606 questions
asked 2026-02-02T05:30:39.6066667+00:00
義教 平田 0 Reputation points
commented 2026-06-07T07:20:47.8533333+00:00
Cam Boxall 0 Reputation points
2 answers

maxdop of a query will fallback to serial or not.

if a query has maxdop 2 : in this case can microsoft decided in this situation to not to use parallelism and use all cores/or execute a query serially, as if parllelism is switched off

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2026-06-06T05:53:14.3433333+00:00
Rajesh Kumar Yadav 20 Reputation points
answered 2026-06-06T08:22:27.0833333+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
1 answer

How to install SSIS Packages on Availability Always On?

Hi expert , my organization plan to provide SSIS package on High Availability server ( Availability Always On) how can I do it? Great Appreciation for all answer warm regards Urbel

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 questions
asked 2026-06-02T08:02:08.6133333+00:00
Urbel 605 Reputation points
commented 2026-06-05T12:24:56.59+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
2 answers

how to fix sql installation problem in windows11

unable to install sql application since I have bought new laptop with windows 11. tried reaching out to hp support but still no use.facing the below error tried multiple times fixing but still the same.

SQL Server Database Engine
asked 2026-06-02T07:29:39.0266667+00:00
MOUNIKA DHUPAM 0 Reputation points
commented 2026-06-05T12:23:35.3833333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator