SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
1 answer
What is the proper syntax
Hi, According to the documentation at https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver17, I can use the following syntax: ALTER TABLE [draft].[dbo].[temp2] ADD PRIMARY KEY(id) WITH( FILLFACTOR = 20 |…
SQL Server Database Engine
asked 2026-03-27T22:37:37.0366667+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(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
56
Reputation points
recommended 2026-04-30T05:27:45.73+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(227.2, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Not able to install Microsoft SQL Express
I have attempted installation multiple times, but it keeps failing. Steps I have already tried: Cleaned up old SQL Server components and services Verified prerequisites (.NET Framework 4.8, Visual C++ Redistributables, Windows updates) Ran installer…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-03-26T16:15:30.4366667+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(112.00000000000001, 2%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Bobbala Anusha
0
Reputation points
recommended 2026-04-30T05:27:24.1+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
how to use azure communications service for smtp
SQL Reporting Services sending subscription emails
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,156 questions
asked 2026-02-10T18:45:30.46+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(294.40000000000003, 0%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ6%3C/text%3E%3C/svg%3E)
JamesPierce-6019
0
Reputation points
recommended 2026-04-30T05:27:04.9766667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
Get Data With Power BI - unable to get data from SQL Server
in taking course via learn.microsoft.com - get data with power bi, I receive (for 2 days now) msg - Unable to Connect. "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
SQL Server | Other
14,735 questions
asked 2026-02-28T15:53:48.6066667+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(256, 55.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK3%3C/text%3E%3C/svg%3E)
KF-3028
0
Reputation points
recommended 2026-04-30T05:26:36.43+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Cannot install SQL Server 2025 Express with WinGet
Running the following script code: winget install --id Microsoft.SQLServer.2025.Express -s winget Echos the following message: Microsoft (R) SQL Server Installer Copyright (c) 2025 Microsoft. All rights reserved. Operation finished with result:…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
4 questions
asked 2026-02-26T08:21:03.1133333+00:00
PtJade Ceramic
0
Reputation points
recommended 2026-04-30T05:26:07.6+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
How deploy copilot using Vscode when running PowerBI backend?
I'm hosting a 2022 SQL Server Adminstrator on an Office instance of m365, but the boot screen doesn't allow for adminstrator privelege access for the powerbi backend. How to fix?
SQL Server | Other
14,735 questions
asked 2026-02-25T22:25:54.2266667+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(153.6, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Garrett Settles
0
Reputation points
recommended 2026-04-30T05:25:40.5666667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Unable to connect to SQL Server for Learning Labs
It has happened in several labs (Get data in Power BI and Prepare data for analysis in Power BI). I've tried clearing cookies/cache but still just get error messages. DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred…
SQL Server | Other
14,735 questions
asked 2026-02-25T21:18:47.5066667+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(160, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ammo Parmar
0
Reputation points
recommended 2026-04-30T05:25:22.79+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
SSMA for Db2 cannot connect to Db2 running on AIX.
SSMA for Db2 cannot connect to Db2 running on AIX. connection string is: Provider=DB2OLEDB;Password=[password];Persist Security Info=True;User ID=[UserId];Initial Catalog=[DB Name];Data Source=[DB Name];Authentication=Server_Encrypt_Pwd;Network…
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.
605 questions
asked 2025-11-20T02:22:21.9466667+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(268.8, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
Ikuo Takekawa/竹川 育夫
0
Reputation points
commented 2026-04-30T05:04:41.58+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,820
Reputation points Microsoft External Staff
Moderator
1 answer
transactional replication between non-domain servers
Hi all, I have two sql server database servers. These are on the same network but there is no domain server. Can I configure these servers for transactional replication ? I know this is possible but how? Any document do you have to do this? Any…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-04-24T11:40:43.4133333+00:00
yunus emre ISIK
261
Reputation points
commented 2026-04-30T04:47:16.9966667+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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
2 answers
Sql server 2025 installation error
Hello Microsoft Support Team, I am reaching out regarding an installation issue with Microsoft SQL Server 2025 (Express Edition) on my ASUS TUF Gaming A15 laptop running Windows 10 Home Single Language (Build 26200). During installation, the server fails…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-04-20T17:33:12.6733333+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' %3ESM%3C/text%3E%3C/svg%3E)
sanjay MN
0
Reputation points
commented 2026-04-30T04:43:14.7666667+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server Login Failures (Error 18456) due to Reporting Services attempting to access non-existent ReportServer database
We are experiencing repeated SQL Server login failures (Event ID 18456) on one of our servers. Details: SQL Server Version: SQL Server 2016 Error Message: "Login failed for user 'REA\IND-WBN-DEV$'. Reason: Failed to open the explicitly specified…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-04-17T07:24:16.13+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, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kamarur Rama
0
Reputation points
commented 2026-04-30T04:41:19.7566667+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
2 answers
Linkage issue to express 2017
Hi, To Sql express 2017, I got the issue like A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not…
SQL Server | Other
14,735 questions
asked 2026-04-29T03:53:13.83+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(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Scott Huang
3,406
Reputation points
commented 2026-04-30T02:16:56.18+00:00
Scott Huang
3,406
Reputation points
0 answers
SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)
Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…
SQL Server | Other
14,735 questions
asked 2026-04-29T12:20:04.25+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(252.8, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Parag Nimbhore
0
Reputation points
commented 2026-04-29T15:34:52.3+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
1 answer
SSIS 2019/2022 - Teradata 20.00 - Microsoft Teradata Connector - Source and Destination not showing in SSIS Toolbox after installation
I have to upgrade to Teradata 20.00 and cannot get the Teradata Source and Destination Tools to show up in SSIS 2022 with VS2022. I have tried with the packages targeting 2019 and 2022. The installation of the connector itself claims to have been…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,789 questions
asked 2026-04-29T15:20:20.2533333+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, 57.99999999999999%, 22%)' 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)
Susann
0
Reputation points
answered 2026-04-29T15:21:00.58+00:00
Q&A Assist
2 answers
vs_SSMS installation - Destination URLs
Dear all, I'm installing vs_SSMS (SQL Server Management Studio) on a client's server. I requested them to open internet connection to be able to install SSMS as i know that the installation once it runs, will download the required files. The client's IT…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-01-13T12:48:10.6633333+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(300.8, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Alaa Al Halabi
0
Reputation points
commented 2026-04-29T14:49:37.47+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(176, 67%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Newman, Scott
0
Reputation points
1 answer
SQL Server Audit / Extended Events – Role‑based (sysadmin) filtering limitations
Hello Microsoft Team, We are implementing security monitoring for sysadmin account usage on an on‑premises SQL Server instance and would like to know what EX events or Audit to achieve our goal? We tried Audit and XE events but those are capturing all…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-04-24T17:19:09.7+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, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uday Paleti
0
Reputation points
commented 2026-04-29T13:06:36.3866667+00:00
Uday Paleti
0
Reputation points
1 answer
Issues with SSIS packages after upgrading SQLServer from 2019 to 2022.
These packages have been running successfully for years, but failed after upgrading SQLserver to 2022. Further detail: the package contains a Script task (VB) that creates and populates files on the file system (either excel or PDF). We have two…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,789 questions
asked 2026-04-28T18:10:56.7+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(76.8, 99%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Ben Pflanzer
0
Reputation points
commented 2026-04-29T12:13:29.7+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
1 answer
SSIS Package Fails with System.Data.SQLite Could Not Load Error (E_POINTER)
I have deployed an SSIS project using an .ispac file into SSISDB. The project contains Cdata Odoo components and Kingswaysoft toolkit. When I try to execute the package (both from SSISDB and from Visual Studio), it fails with the following…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,789 questions
asked 2026-04-29T06:12:42.41+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(268.8, 34%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
Ishika Raiyani
20
Reputation points
commented 2026-04-29T10:04:13.5333333+00:00
Ishika Raiyani
20
Reputation points
1 answer
SQL Agent job fails to run Restart-Service but works interactively
I have a SQL Agent job that runs a CmdExec step using a proxy account. The text of this step is: powershell.exe -ExecutionPolicy Bypass -File D:\Scripts\RestartService.ps1 The content of this script is: Restart-Service -DisplayName "Some…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-04-28T10:24:00.1766667+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, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
256
Reputation points
commented 2026-04-29T09:06:51.69+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
2 answers
Erro na instalação do SQL Server 2025 express - Exit Code-2061893606
Prezados, Estou enfrentando um problema recorrente ao tentar instalar o Microsoft SQL Server 2025 Express Edition em meu computador com Windows 11. Durante o processo de instalação, o setup falha com a seguinte mensagem: Exit code (Decimal):…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
695 questions
asked 2026-04-25T17:49:50.47+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(176, 92%, 27%)' 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)
Joao Beluso
0
Reputation points
commented 2026-04-29T05:50:11.7766667+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator