562 questions
1 answer
I am trying to create a Service-Based Database inside the Visual Studio project, but keep getting error indicating the certificate chain was issued by an authority that is not trusted.
I am trying to add a Service-based database using the Visual Studio 2026 IDE by selecting: Add/New Item/Service-based Database I keep getting this message: A connection was successfully established with the server, but then an error occurred during the…
SQL Server Database Engine
asked 2026-01-03T16:06:45.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Victor Gent
20
Reputation points
commented 2026-01-03T20:12:51.0666667+00:00
Erland Sommarskog
130.4K
Reputation points MVP
Volunteer Moderator
1 answer
i forgot my password i set for microsoft sql and even name . so can i make new id again
Forgot my Password And and entry name With which I logined so can I reset Or how can I make New ID If I don't know anything about the old account..
SQL Server | Other
14,630 questions
asked 2026-01-02T09:36:33.4733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 36%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
ROOPREET GUPTA
0
Reputation points
commented 2026-01-02T19:24:35.5833333+00:00
Erland Sommarskog
130.4K
Reputation points MVP
Volunteer 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
562 questions
asked 2026-01-02T12:42:04.7466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 74%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Arthur Tong
0
Reputation points
answered 2026-01-02T16:30:13.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
27,091
Reputation points
2 answers
One of the answers was accepted by the question author.
Official Download Link for MS SSMS v20.2.1
Hello Everyone, I am trying to upgrade my existing MS SSMS from v18.12.1 to v20.2.1 in one of my environments. I am looking for the installer, but I could not find one from the Microsoft Official website. This page of 20.2.1 takes me to the download of…
SQL Server Database Engine
562 questions
asked 2026-01-01T11:35:25.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 2%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Arkapriya Gupta
20
Reputation points
commented 2026-01-02T11:59:59.88+00:00
Arkapriya Gupta
20
Reputation points
1 answer
Identity Column jumps massively from 168712 to 9999993
I have table with identity column id. There was massive jump from id 168712 to 9999993. It has happened twice in different servers. Its not identity cache/transaction rollback/manual insert/ reseed. Why its happening. Please guide me on this.
SQL Server | SQL Server Transact-SQL
257 questions
asked 2025-10-17T16:06:46.38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 62%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Perumal, Gowthami
5
Reputation points
commented 2026-01-02T10:32:41.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
install sqlserver 2022 Error 0x80004005 Access Denied
I'm getting an error code 0x80004005: Access Denied when trying to install SQL Server 2022 on my Windows Server 2016. This error occurs with all editions, including the Express edition. Can you help me identify what might be causing this issue?
SQL Server Database Engine
562 questions
asked 2025-10-17T00:55:52.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWZ%3C/text%3E%3C/svg%3E)
Wen Zhao
0
Reputation points
commented 2026-01-02T09:50:20.97+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server 2019 CU32 (KB5063757) Patch Hang and Master DB Corruption – Requesting Guidance
Hello, I’m seeking advice regarding a critical issue encountered during testing of the SQL Server 2019 CU32 (KB5063757) patch. Due to the severity of the symptoms observed, we are currently postponing deployment to our production…
SQL Server Database Engine
562 questions
asked 2025-10-15T06:02:59.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 15%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
권태우
20
Reputation points
commented 2026-01-02T08:58:38.2833333+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
3 answers
MSDASQL - Unexpected Failure when Connecting ODBC Driver
I was trying to link my localhost SQL server to a remote MySQL server. I have configured a ODBC connection to the remote server and tested that the connection is successful. However, when I try to link the ODBC to my local server, the linked server…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
1,144 questions
SQL Server | Other
14,630 questions
asked 2023-06-30T07:50:47.44+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 2%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Chiu Tung Lau
5
Reputation points
edited a comment 2026-01-02T07:46:15.0966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 53%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sukanta Samanta
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Possible to host SQL server 2022 in AWS RDS as SSRS database?
Hello, I would like to know is that possible to host SSRS database sql server 2022 in AWS RDS? I trying to host SSRS in EC2 and SQL server in RDS then I use rds admin user to connect database on Configuration manager set up and getting this permission…
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,122 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 63%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 30%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
2 answers
How can I obtain product key information to use for this current SPLA client that we had deployed using a dev key?
On the information provided below for SQL server, if I go to my company’s admin center and go to billing, my products, I do not have SQL licensed there to download, and I’m not wanting to download and install my own SQL license anyway, so I’m not sure…
SQL Server | Other
14,630 questions
asked 2025-12-31T22:51:57.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 43%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
McVay, Joy
0
Reputation points
answered 2025-12-31T23:18:16.18+00:00
Erland Sommarskog
130.4K
Reputation points MVP
Volunteer Moderator
1 answer
SSIS Support for JIRA REST API
Hello, I am using SQL Server 2017 with SSIS 2017. Does SSIS support importing data using JIRA REST API directly or do we have to install/add some third-party connectors or drivers to SSIS first? Thanks
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,763 questions
asked 2021-10-10T10:01:45.613+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2025-12-31T22:14:48.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 69%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Daniel Calbimonte
0
Reputation points
1 answer
sql install error
installing sql express basic mode the parameter is incorrect
SQL Server Database Engine
562 questions
asked 2025-12-31T15:12:11.7266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 3%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Joe Kaminski
0
Reputation points
commented 2025-12-31T16:29:35.52+00:00
Erland Sommarskog
130.4K
Reputation points MVP
Volunteer Moderator
3 answers
I am unable to save my SSMA for DB2 project. I think the metadata queries have syntax errors.
I am trying to migrate from DB2 running on an IBM i server and migrate to Sql Server 2017 running on Windows 2016. When I try to save my SSMA for DB2 project, I select my Schema and press save. The process begins and I see errors in the output window.…
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-18T16:35:28.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 1%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGW%3C/text%3E%3C/svg%3E)
Greg Witsken
0
Reputation points
commented 2025-12-31T14:43:29.5333333+00:00
Greg Witsken
0
Reputation points
2 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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
James Johnson
5
Reputation points
commented 2025-12-31T13:43:51.1966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 31%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
John Cripps
0
Reputation points
2 answers
In my project we are using ssdt setup for sql changes so where i create one view i am getting ambiguous issue for columns how can i resolve in sql i tested its working fine but in ssdt build i am getting issue
In my project we are using ssdt setup for sql changes so where i create one view i am getting ambiguous issue for columns how can i resolve in sql i tested its working fine but in ssdt build i am getting issue
SQL Server Database Engine
562 questions
asked 2025-12-30T07:27:04.9833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 99%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ashwini Kanjapur
0
Reputation points
answered 2025-12-31T11:20:57.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shruti Dhruv
560
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server 2022 setup executables blocked on Windows 11 24H2 – installer does not launch
SQL Server 2022 Developer Edition setup binaries (RSETUP.exe, x64\setup.exe) do not launch on Windows 11 Pro 24H2 (build 26100.x). Behavior: “Access is denied” “This app can’t run on your PC” Or no UI when launched as Administrator Smart App Control…
SQL Server Database Engine
562 questions
asked 2025-12-24T07:44:03.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nirmal Kumar
0
Reputation points
commented 2025-12-31T11:03:25.5533333+00:00
Shruti Dhruv
560
Reputation points Microsoft External Staff
Moderator
0 answers
sql server database engine service how can i resolve this in windows 11
i have an issue while installing sql server its showing error databse engine service failed in window 11 and i installing 2025 version of sql server
SQL Server Database Engine
562 questions
asked 2025-12-22T07:15:13.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
jhasaketan behera
0
Reputation points
commented 2025-12-31T10:58:30.4666667+00:00
Shruti Dhruv
560
Reputation points Microsoft External Staff
Moderator
2 answers
Under a Select Plus agreement, there is no product key provided. How can SQL Server be upgraded in this case?
I have purchased SQL Server 2022 Standard. How can I upgrade from the free edition (Express / Evaluation) to SQL Server 2022 Standard? Our organization is under a Select Plus agreement, and we do not have a visible product key—only the License Summary is…
SQL Server Database Engine
562 questions
asked 2025-12-31T07:42:13.85+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 42%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
唐宏
0
Reputation points
answered 2025-12-31T10:54:56.7+00:00
Erland Sommarskog
130.4K
Reputation points MVP
Volunteer Moderator
1 answer
SQLServer is crashing and ask help to fix this
I'm having a problem with an Autodesk program that works with SQL Server. Autodesk support referred me to you to resolve the issue. Thank you.
SQL Server Database Engine
562 questions
asked 2025-12-23T23:52:30.8933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 43%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
rudy pizzolato
0
Reputation points
edited a comment 2025-12-31T10:54:18.6966667+00:00
Shruti Dhruv
560
Reputation points Microsoft External Staff
Moderator
3 answers
Is MS ODBC driver 18.5.1.1 compatible with SQL Server 2025 for new JSON and VECTOR types?
Hello, I would like to test the new JSON and VECTOR types of SQL Server 2025 with the Microsoft ODBC driver for SQL Server. I have installed SQL Server 2025 CTP 2.0 on my Windows 11. For now I have MS ODBC driver 18.5.1.1 for Linux (Debian 12). Is this…
SQL Server Database Engine
562 questions
asked 2025-06-12T12:44:51.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 57.99999999999999%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Sebastien Flaesch
31
Reputation points
commented 2025-12-31T09:48:13.3966667+00:00
Erland Sommarskog
130.4K
Reputation points MVP
Volunteer Moderator