21,355 questions with SQL Server-related tags

Sort by: Updated
1 answer

How does one go about buying a SQL license?

I know this sounds like it should be simple, but it's not. The marketplace goes nowhere, call MS, they don't call back. I assume I need to find a licensed partner, but that is also no response. Can anybody point me to somebody that I can give money to…

SQL Server | Other
asked 2026-02-24T15:24:35.8666667+00:00
Jim 386 Reputation points
edited the question 2026-02-24T15:58:40.57+00:00
Mike Bowen 2,056 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?

I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?

SQL Server | Other
asked 2026-02-24T14:52:39.89+00:00
Benjamin Hefner 20 Reputation points
accepted 2026-02-24T15:29:27.2033333+00:00
Benjamin Hefner 20 Reputation points
2 answers One of the answers was accepted by the question author.

A Scalar UDF works consistently in SQL Server 2017, fails sporadically under 2019 and 2022.

You can try this at home! I use this udf to capture the number of cores available when my stored procedure runs in cloud. But, since I develop against my local on-prem database, I coded it to return a -1 when it's not running in the cloud. Here's the…

SQL Server | SQL Server Transact-SQL
asked 2026-02-23T22:52:16.3333333+00:00
Steve Grimes 20 Reputation points
commented 2026-02-24T14:55:33.2633333+00:00
Steve Grimes 20 Reputation points
0 answers

SQL Server Developer Edition Installer can't identify an installed software it needs.

Hi! I'm having a problem installing Microsoft SQL Server Developer Edition. It says that a certain software is not installed, although it is indeed installed. Any idea how can I solve this issue? The following lines are copied from Details.txt…

SQL Server Database Engine
asked 2026-02-21T13:32:24.1533333+00:00
Abdelrahman Hany 0 Reputation points
commented 2026-02-24T13:47:34.6666667+00:00
Abdelrahman Hany 0 Reputation points
2 answers

SSIS Data Flow has trouble when it has to return many fields

I have an SSIS project that calls stored procedures to create extract files via OLE DB Source & Flat File Destination. The stored procedure returns 150 fields and sometimes a few million records. This causes SSIS & Visual Studio 2019 to take a…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,777 questions
asked 2026-02-05T20:09:28.96+00:00
Bob-7209 66 Reputation points
commented 2026-02-24T13:45:17.0066667+00:00
Bob-7209 66 Reputation points
2 answers One of the answers was accepted by the question author.

how to resolve degraded sql performance since upgrading from sql 2016 to sql 2022

We have a sql instance ( on premise) that was running sql 2016. Query store was not enabled. We have a large workload that runs overnight, hundreds of stored procedures. We have upgraded to sql 2022, but had an approximately 10% increase of the duration…

SQL Server Database Engine
asked 2026-02-15T23:44:37.3066667+00:00
Greg Booth 1,456 Reputation points
accepted 2026-02-24T12:38:04.3133333+00:00
Greg Booth 1,456 Reputation points
0 answers

RedHat Linux 9.7 SQL Server 2025 CU2 Fails to write database backup to Linux NFS Share

Hello, I have a VMWare VM running RedHat Linux 9.7 and SQL Server 2022 CU 23. SQL Server 2022 can successfully write database backups and the mssql agent job text log file to the Linux NFS share. I successfully upgraded the VM to SQL Server 2025 CU2.…

SQL Server Database Engine
asked 2026-02-23T22:49:30.06+00:00
Marcelo Marques 0 Reputation points
commented 2026-02-24T11:17:04.98+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server 2025 Standard License

I have downloaded SQL server 2025 Standard iso from volume licensing portal and when trying to install it gives predefined license key in the setup but we also have key available in licensing portal which is different than the one embedded in the setup…

SQL Server | Other
asked 2026-02-14T15:56:35.87+00:00
Shivank Gupta 0 Reputation points
commented 2026-02-24T09:29:52.9933333+00:00
Shivank Gupta 0 Reputation points
2 answers

STIntersection() hangs forever

Hello, when I execute this STIntersection() query for two valid polygons (in this case CurvePolygons), it will run forever and will cause (very) high CPU usage! The problem exists at least from SQL2016 to SQL2025 (with latest updates installed). See…

SQL Server Database Engine
asked 2026-02-18T18:14:47.0433333+00:00
MarkusW 0 Reputation points
commented 2026-02-24T09:17:02.62+00:00
MarkusW 0 Reputation points
1 answer

ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering

We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2): https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/ The issue is that using…

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,141 questions
asked 2025-07-08T12:42:00.13+00:00
Máté Gribovszki 0 Reputation points
commented 2026-02-24T09:15:21.9033333+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
1 answer

How to Suppress Microsoft Sign-In Dialog in SSMS 22 for Automated Testing?

We are running automated UI tests against SSMS 22 inside a Vagrant-based VM environment. When SSMS launches, it consistently shows the Microsoft account sign-in dialog (the Visual Studio–style “Sign in to your account” window). This dialog blocks our…

SQL Server | Other
asked 2026-02-16T08:04:31.63+00:00
utkarsh bandekar 10 Reputation points
commented 2026-02-24T09:01:02.6166667+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
1 answer

Problem with SQL server login

Screenshot 2026-02-14 120506 I am trying to connect to a local SQL Server instance (localhost;AdventureWorksDW2020) via Power BI Desktop and I am getting this specific error message ("We couldn't authenticate with the credentials provided. Please…

SQL Server | Other
asked 2026-02-14T11:44:38.18+00:00
qasim fasasi 0 Reputation points
commented 2026-02-24T08:59:23.9066667+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers

License SQL Server Developer

Can I use SQL Server Developer license in a server for only tests and development?

SQL Server Database Engine
asked 2026-02-13T19:17:36.0433333+00:00
GTI - Mstech 0 Reputation points
commented 2026-02-24T08:58:52.11+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
1 answer

Database is disappearing

Every time I create a table, it stays for a while (as long as 24 hrs), and I see it gets dropped. I get resource not available. Why am I losing the database?

SQL Server Database Engine
asked 2026-02-18T00:52:58.0866667+00:00
Bhaskar Kumar Chowdhury 0 Reputation points
commented 2026-02-24T08:50:41.8733333+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers

TITLE: Error ------------------------------ A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server

TITLE: Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote…

SQL Server | Other
asked 2026-02-20T07:27:25.2866667+00:00
Bhoomi Chauhan 0 Reputation points
commented 2026-02-24T08:47:01.7666667+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
1 answer

CDC change Data Capture on High availibility AlwaysOn 2019

Hello,  I have three nodes (SQL Server 2019) Always On availability group configuration -FYI. I have applied the CDC (Change Data Capture) jobs [cdc.DBName_capture] and [cdc.DBName_cleanup] on all three nodes. However, when a failover occurs from the…

SQL Server Database Engine
asked 2026-02-19T08:29:44.65+00:00
Mona Seddik 20 Reputation points
commented 2026-02-24T08:43:11.21+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers

SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005)

SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005) We have an SSIS package that reads data from a file on a network share (UNC path). For example, the file is located at \\EXAMPLE_DOMAIN\SharedFolder\file.csv (domain…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,777 questions
asked 2026-02-18T11:58:59.3166667+00:00
Thanyapong Latthikul 0 Reputation points
commented 2026-02-24T08:40:05.0666667+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers

How to delete an orphan user from On premise Powerbi report server Site Setting using Powershell Script

In the On-Premise Power BI Report Server setup one user has been migrated from Corp to AHM domain. But in the On-Premise Power BI Report Server Site settings his username can be seen as Content Manager. Since the powerbi is not able to verify the old…

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,141 questions
asked 2026-02-11T05:46:15.0733333+00:00
Sandeep Mawri 0 Reputation points
edited an answer 2026-02-24T07:32:29.42+00:00
kagiyama yutaka 805 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Data Migration Assistant

Hi all, why DMA V5.8 tools has no choice for target Platform SQL server On Prem, only SQL Azure to select.. what's your solution for SQL Server On Prem Paltform? thanks for all reply regards, UrBel

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.
601 questions
asked 2026-02-24T02:22:42.8133333+00:00
Urbel 400 Reputation points
commented 2026-02-24T04:06:35.3+00:00
Urbel 400 Reputation points
1 answer

Migrating Large Size scale Database

Hi all, what is alternative method to migrating side by side large size Database thanks for all reply regards, Urbel

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.
601 questions
asked 2026-02-24T02:50:57.9666667+00:00
Urbel 400 Reputation points
commented 2026-02-24T02:54:44.9466667+00:00
Urbel 400 Reputation points