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
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
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
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
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
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
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
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
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
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
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
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
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
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
download sql 2022 media
where can i download the media for sql2022? Thank You, Brian
SQL Server | Other
I need to download SQQL 2025 standard and enterprise
Where can I get our SQL 2025 media to start installing
SQL Server | Other
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
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
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
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…