Core component of SQL Server for storing, processing, and securing data
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
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
Core component of SQL Server for storing, processing, and securing data
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
Core component of SQL Server for storing, processing, and securing data
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
Core component of SQL Server for storing, processing, and securing data
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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
Core component of SQL Server for storing, processing, and securing data
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
Core component of SQL Server for storing, processing, and securing data
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
Programming language used to interact with SQL Server databases
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
Core component of SQL Server for storing, processing, and securing data
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
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
Core component of SQL Server for storing, processing, and securing data