21,224 questions with SQL Server-related tags

Sort by: Updated
1 answer

Known issue? Insert into temp table sometimes throws 8152 instead of 2628

Our system frequently needs to create temporary tables in order to pass data from Java to stored procedures. Since we are using SQL Server 2022, I would expect that when inserting a too-large value into a column we would get exception 2628 with the…

SQL Server | SQL Server Transact-SQL
asked 2026-01-06T19:01:14.06+00:00
Dan Blum 0 Reputation points
answered 2026-01-06T19:34:30.4466667+00:00
Erland Sommarskog 130.5K Reputation points MVP Volunteer Moderator
1 answer

Attunity drivers are failing after OS upgrade to 2022

we have ssis packages where target is sql server 2016 and os 2016. recently we upgraded server os to 2022 but the sql server is still 2016. after upgrade the packages which are using attunity drivers to connect to oracle are failing when we give password…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2026-01-06T16:10:32.53+00:00
vamsi krishna 0 Reputation points
answered 2026-01-06T16:11:45.05+00:00
Q&A Assist
1 answer One of the answers was accepted by the question author.

SQL Server 2025 VECTOR_DISTANCE() should accept plain VARCHAR expression

Hello! Playing with VECTOR functions, I think these should accept implicit conversion from VARCHAR to VECTOR, to avoid additional casting operations: declare @v1 as VECTOR(3) = '[-1,1,0]' declare @s1 as VARCHAR(50) = '[-1,1,0]' drop table tab1; create…

SQL Server Database Engine
asked 2026-01-06T12:53:24.6133333+00:00
Sebastien Flaesch 51 Reputation points
accepted 2026-01-06T15:43:15.88+00:00
Sebastien Flaesch 51 Reputation points
0 answers

SSIS Job Failing Due to MongoDB Driver Dependency Error After MongoDB 8 Upgrade

As part of an ongoing upgrade to MongoDB version 8, we are updating the C# components used to integrate data into MongoDB collections to ensure compatibility with the latest MongoDB driver syntax and APIs. During this upgrade, we are encountering a…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2026-01-06T15:16:26.63+00:00
Sahar Aitlhou 0 Reputation points
2 answers

The SQL Server Management studio no longer shows running SSIS packages

Hi everyone, I run a bunch of SSIS packages in a SQL Server Agent job. The packages are deployed as files in the file system. They are executed as SQL Server Agent Service Account. I used to be able to see them under Running Packages. Today, they weren't…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2025-12-19T21:51:23.88+00:00
Igor Gelin 0 Reputation points
edited an answer 2026-01-06T12:39:26.4833333+00:00
Yitzhak Khabinsky 27,091 Reputation points
2 answers

Failed to create backup file in SQL Server

Hello, I'm having trouble with SQL Server backups and have a question. I translated this from Japanese, so the wording might be a bit awkward. [Environment] SQL Server 2019 running on a Hyper-V virtual environment on Windows Server 2016 [Issue] During…

SQL Server | SQL Server Transact-SQL
asked 2025-12-26T01:35:10.4033333+00:00
UTAMARO 0 Reputation points
commented 2026-01-06T09:57:08.3866667+00:00
Erland Sommarskog 130.5K Reputation points MVP Volunteer Moderator
1 answer

About SQL License

SQLのライセンスを購入して納品の連絡までは来たのですが、Microsoft365管理センターで対象のラインセンスが反映されず、困っています。 手続等足りていない部分があったら、その内容も含めて対応を確認したいです。 お手数をおかけしますがご確認をよろしくお願いいたします。

SQL Server Database Engine
asked 2025-11-25T07:23:26.52+00:00
大資 山田 0 Reputation points
commented 2026-01-06T09:29:27.6833333+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff Moderator
1 answer

SQLDriverConnect truncates File DSN attribute values - breaks OAuth2 AccessToken support

Category: ODBC / Driver Manager Description: Problem Summary: The Windows ODBC Driver Manager (odbccp32.dll) truncates File DSN attribute values when reading the DSN file and passing attributes to the driver via SQLDriverConnect. This breaks OAuth2…

SQL Server | Other
asked 2025-11-25T09:11:07.14+00:00
Vikas Kumar 0 Reputation points
commented 2026-01-06T08:55:34.39+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff Moderator
1 answer

Upgrade from SQL-Server 2019 Standard to SQL-Server 2022 Standard

I want to make an upgrade from SQL-Server 2019 Standard to SQL-Server 2022 Standard. But i can't check the button for the standard edition. Best regards Carsten Neuhaus IKN GmbH

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.
590 questions
asked 2025-11-25T11:45:42.41+00:00
Carsten Neuhaus 0 Reputation points
commented 2026-01-06T08:49:47.35+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff Moderator
0 answers

SSIS error

Good morning everyone, I'm getting the following error [Execute SQL Task] Error: Executing the query "DECLARE @ReturnCode INTEGER = 0; [Execute SQL Task] Error: Executing the query "DECLARE @RerurnCode INTEGER = 0; excute ? OUTPU..."…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2025-11-25T18:27:45.5966667+00:00
Naomi Nosonovsky 8,881 Reputation points
commented 2026-01-06T07:28:15.4133333+00:00
Akhil Gajavelly 1,110 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 2026-01-06T07:12:52.01+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff Moderator
1 answer

MySQL INSERT fails with ERROR 1064, 1265, 1292 (invisible character in numeric ID, ENUM mismatch, invalid DATETIME)

Hi, I’m importing seed data into a MySQL table and my bulk INSERT fails with multiple errors depending on the row. I suspect some data-cleaning/format issues during copy/paste or CSV → SQL conversion. Table definition CREATE TABLE lead_broker_status ( …

SQL Server Database Engine
asked 2026-01-02T12:42:04.7466667+00:00
Arthur Tong 0 Reputation points
edited a comment 2026-01-06T06:56:36.1166667+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff Moderator
2 answers

Error: 40 - Could not open a connection to SQL Server

We are encountering an issue while importing data from a data warehouse hosted on SQL Server into Power BI. The connection is established successfully, and the import begins as expected. However, after running for some time, the process fails with the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2025-11-25T21:24:25.6+00:00
Moorthy, Jayachandran 0 Reputation points
commented 2026-01-06T06:11:26.1266667+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff Moderator
1 answer

microsoftt access problem

when i run my laptop always a notification is aheaded tha odbc microsoft log in failed but i dont want this how i can solve this problem

SQL Server Database Engine
asked 2025-11-27T04:53:57.7933333+00:00
Darshan Chandra Roy 0 Reputation points
commented 2026-01-06T05:51:16.6366667+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff 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.
590 questions
asked 2025-11-29T19:05:58.6566667+00:00
Mario Jaile 41 Reputation points
commented 2026-01-06T05:34:56.1133333+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff 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
Mohamed Elsayed Tawfik 5 Reputation points
commented 2026-01-06T04:51:49.11+00:00
Akhil Gajavelly 1,110 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How do I change the font size in the 'Connect to Server' dialog box?

My 'Connect to Server' dialog box is almost unreadable due to small font size. While it's straight forward to change fonts elsewhere in SSMS through Tools->Options->Environment->Fonts and Colors, there doesn't seem to be a way to change the…

SQL Server | Other
asked 2026-01-05T15:56:39.62+00:00
Vaughn, Daniel R 20 Reputation points
answered 2026-01-05T20:27:38.47+00:00
Erland Sommarskog 130.5K Reputation points MVP Volunteer Moderator
2 answers

SQL Server Express 2025 installation issue on hp omnibook 7

I have got new HP Omnibook 7 flip ultra 7. I am trying to install sql server express 2025 but every time it failed. The exit code is -2061893606 (Error description: Wait on the Database engine recovery handle. Check sql server error log for potential…

SQL Server Database Engine
asked 2025-12-16T00:07:22.9033333+00:00
Amanullah Dar 0 Reputation points
commented 2026-01-05T20:07:48.13+00:00
Erland Sommarskog 130.5K Reputation points MVP Volunteer Moderator
3 answers

Cannot transfer my Access tables using the new SSMA 10.4 version

I would like to get SSMA 10.3 (Access → SQL Server edition) since I cannot use the current version which gives me the "Error Bad parameters for connection” regression in 10.4." I am running SQL Server Express, SSMA and VStudio 2022 Express so I…

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.
590 questions
asked 2025-12-27T19:33:44.8766667+00:00
James Johnson 5 Reputation points
commented 2026-01-05T20:03:46.7333333+00:00
Erland Sommarskog 130.5K Reputation points MVP Volunteer Moderator
3 answers

Sql Server License

Hi, Can I use the Pay-as-you-go pricing model for a SQL server on a local virtual machine? Or does it need its own dedicated machine? Thank you

SQL Server | Other
asked 2025-12-01T16:34:41.38+00:00
Kyle Malvey 0 Reputation points
edited an answer 2026-01-05T19:37:23.8566667+00:00
Bruce (SqlWork.com) 82,311 Reputation points Volunteer Moderator