21,128 questions with SQL Server-related tags

Sort by: Updated
1 answer

there will be 500 if I use NetworService?

I am using .net core web 9.0 and SQL Server Express and If the ThreadPool is NetworkService there will be 500 and If I use administrator as the identityrole it will be ok but now I have to use NetworkService since I have to use another package. I have…

SQL Server Database Engine
asked 2025-11-30T13:45:32.2766667+00:00
mc 6,356 Reputation points
edited the question 2025-12-01T01:01:35.15+00:00
mc 6,356 Reputation points
2 answers

Copy Database Wizard fails

Hello folks, My goal is to migrate DB from server A (MSSQL 2019 Standard) to server B (MSSQL 2022 Standard). These two servers are two different VMs and they can communicate over network. I would like to avoid, if possible, the…

SQL Server | Other
asked 2025-11-30T21:47:49.12+00:00
Federico 0 Reputation points
answered 2025-11-30T22:09:26.3533333+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
0 answers

SQL server 2022 job fails

Hello SQL Server 2022 16.0.4212.1 Installed in a windows server 2025 DC. SQLSERVERAGENT starts with NT Service\SQLSERVERAGENT I have some jobs that runs at the scheduled times. But one no. Failure: "Job failed. The job was invoked by Schedule 9…

SQL Server | SQL Server Transact-SQL
asked 2025-09-11T07:43:40.6466667+00:00
Delmira Oliveira 100 Reputation points
commented 2025-11-30T20:10:22.81+00:00
Urantia 0 Reputation points
2 answers

Sql 2025 T-SQL Job

SQL 2025 Std running in a Windows server 2022 Std A job with a T-SQL task (which calls a stored procedure) ran well weekly for almost a month, at a specific time of day For various reasons, I had to change it so that it would run at a different time of…

SQL Server | SQL Server Transact-SQL
asked 2025-11-09T17:54:49.8566667+00:00
Delmira Oliveira 100 Reputation points
commented 2025-11-30T19:43:05.1266667+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
2 answers

Error in connecting power bi to AXDW by DirectQuery

I opened the Power BI app on a virtual machine (VM) and tried to connect to AXDW using the server name "." or "dvhd10043vm" and the database name AXDW with the DirectQuery method. However, I encountered the following error message:…

SQL Server Database Engine
asked 2025-11-30T07:07:40.1+00:00
Data Analyst (Mohamed Tawfik) 0 Reputation points
answered 2025-11-30T12:24:51.2833333+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
3 answers

SQL Server 2025 - Unable to run Python scripts

I have built a SQL Server 2025 instance and, following the instructions here I have installed and configure R and Python support. R is working fine but when I try to run a simple Python script I get the errors: EXEC sp_execute_external_script…

SQL Server Database Engine
asked 2025-11-25T14:50:01.7933333+00:00
Peter Bishop 206 Reputation points
commented 2025-11-30T10:40:20.0766667+00:00
Peter Bishop 206 Reputation points
1 answer

Recompile Command Performance Effect

We use .net core Ef .netcore version 8.0. We use an interseptor to manipulete each EF s sql commandS. This interceptor adds OPTION(RECOMPILE) to each sql query. Could you please tell me it is neccessary to use this command.

SQL Server | SQL Server Transact-SQL
asked 2025-11-30T07:44:45.0966667+00:00
Hakan Çakmak (Udepa) 0 Reputation points
answered 2025-11-30T10:37:27.2766667+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
1 answer

Need Archived Installer for SSMA 10.3

Hi, I’m running SQL Server 2022 Express on Windows 10 (64‑bit) and using SSMA for Access. With SSMA 10.4, I keep getting the error “Bad parameters for connection” when connecting via Windows Authentication. I understand this is a known regression in…

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.
583 questions
asked 2025-11-29T19:05:58.6566667+00:00
Mario Jaile 41 Reputation points
answered 2025-11-29T19:06:05.9+00:00
Q&A Assist
1 answer

I need a Data Catalog to make schema using power bi conneted with Data warehouse from Microsoft Dynamics

I need a data catalog to properly connect the sales cube using the Power BI app with a Direct Query connection type. There are many tables in the AXDW, and I don't have the schema for this data in my company (Alsanidi).

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,365 questions
asked 2025-11-26T14:51:13.6666667+00:00
Data Analyst (Mohamed Tawfik) 0 Reputation points
commented 2025-11-29T15:00:33.67+00:00
Data Analyst (Mohamed Tawfik) 0 Reputation points
2 answers

How can I download the developer version of SQL Server 2022? the download link not working. SSMS / SSIS

Hi, I need to download the Developer version of SSMS / SSIS 2022. The link in Microsoft web site doesn't work. (https://go.microsoft.com/fwlink/p/?linkid=2215158&clcid=0x409&culture=en-us&country=us) Any suggestions? Thanks in advance Haim.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,365 questions
asked 2025-03-31T04:35:46.67+00:00
Haim Meiri 0 Reputation points
answered 2025-11-28T22:43:15.7966667+00:00
Julie Agbowu 0 Reputation points
4 answers

Issue with sending emails from contained availability group SQL 2022

Hi, We're having issues with sending out emails from the contained availability group in SQL 2022 The setup consists of 3 servers 2 sync and 1 async. All accounts/profiles are setup on availability group and also all the individual servers (which i…

SQL Server | Other
asked 2023-04-20T12:37:20.2533333+00:00
Audrius Zepkinas 0 Reputation points
commented 2025-11-28T19:42:31.3633333+00:00
JD. Wilson 0 Reputation points
5 answers

SSIS Package Execution Error - The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered

Hello Community, I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the background information with the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,759 questions
asked 2025-06-24T18:20:55.04+00:00
Ryan 16 Reputation points
edited a comment 2025-11-28T19:33:59+00:00
Ryan 16 Reputation points
1 answer

Inquiry Regarding Migration from SQL Server 2019 to SQL Server 2022 and SSIS 2012 Migration Path

Dear Microsoft Support Team, I hope you are doing well. Our team is currently running SQL Server 2019 and using SSIS packages developed in SQL Server Integration Services (SSIS) 2012. We are planning to migrate our environment to SQL Server 2022, and we…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,759 questions
asked 2025-11-28T09:12:30.29+00:00
TIPPAWAN SOMSEE 0 Reputation points
edited the question 2025-11-28T13:56:44.2+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
1 answer

sql server

how can i get a sql certificate from microsoft what all things do I need to do and how please explain

SQL Server | SQL Server Transact-SQL
asked 2025-11-28T12:41:56.46+00:00
Jivesh Pandey 0 Reputation points
commented 2025-11-28T13:23:37.0333333+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
2 answers

download sql 2022 media

where can i download the media for sql2022? Thank You, Brian

SQL Server | Other
asked 2025-11-21T19:15:30.2366667+00:00
Brian Coder 0 Reputation points
commented 2025-11-28T11:58:22.5233333+00:00
Akhil Gajavelly 875 Reputation points Microsoft External Staff Moderator
2 answers

I need to download SQQL 2025 standard and enterprise

Where can I get our SQL 2025 media to start installing

SQL Server | Other
asked 2025-11-25T21:10:33.0466667+00:00
Poupart, Christian 0 Reputation points
commented 2025-11-28T11:48:22.8133333+00:00
Akhil Gajavelly 875 Reputation points Microsoft External Staff Moderator
1 answer

Unable to Pull Docker Image for SQL Server

docker pull mcr.microsoft.com/mssql/server Using default tag: latest Error response from daemon: failed to resolve reference "mcr.microsoft.com/mssql/server:latest": failed to do request: Head…

SQL Server Database Engine
asked 2025-05-05T02:53:11.8933333+00:00
Vinod Kumar Nerella 0 Reputation points
answered 2025-11-28T11:33:50.82+00:00
Akhil Gajavelly 875 Reputation points Microsoft External Staff Moderator
2 answers

Please Help me - How can I fix the 'Culture is not Supported' error when importing an Excel file to a database in SQL Server Management Studio

I have tried countless times to import an Excel file via the SSMS application interface and keep getting the below error. Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[CovidDeaths$] ( iso_code] NV . "…

Microsoft 365 and Office | Excel | For business | Windows
SQL Server | Other
asked 2023-07-14T09:26:27.05+00:00
Nnamani Chisom Promise 45 Reputation points
commented 2025-11-28T11:13:56.62+00:00
Dominique Rolin 0 Reputation points
2 answers

DB STARTUP events in AG replica SQL error log

HI Team, we got an Availability group with 4 nodes (1 primary, 2 synch nodes, 1 asynch node). in the secondary replica sql error logs I see frequent messages as below for various secondary databases. Example: Buffer Pool scan took 11 seconds: database…

SQL Server Database Engine
asked 2025-11-16T22:59:43.8533333+00:00
subhash-DBA 155 Reputation points
answered 2025-11-28T10:11:36.2266667+00:00
Lakshmi Narayana Garikapati 640 Reputation points Microsoft External Staff Moderator
3 answers

Joins vs Functions and Performance

It is axiomatic that joining to another table from your primary table to retrieve data, using primary keys, provides better performance than using a function. At least that's what I know from the last time I cared about it years ago. It's time to care…

SQL Server | SQL Server Transact-SQL
asked 2025-07-03T19:12:57.03+00:00
Don Thompson 0 Reputation points
answered 2025-11-28T10:03:59.3866667+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator