21,539 questions with SQL Server-related tags

Sort by: Updated
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
asked 2026-04-20T17:33:12.6733333+00:00
sanjay MN 0 Reputation points
answered 2026-04-20T20:54:56.7366667+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator
0 answers

Oracle source and destination missing in visual studio 2022 after installing Microsoft Connector for Oracle v1.2/1.3

We are running SSIS packages originally developed for SQL Server 2016 on servers that have been upgraded to SQL Server 2022 (both OS and database engine). The packages use the Attunity Oracle connectors. After the upgrade we attempted to open the…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,785 questions
asked 2026-04-20T20:13:59.91+00:00
vamsi krishna 0 Reputation points
1 answer

I am facing issue while installing Sql Server 2025 Express to my laptop Asus TUF Gaming laptop

To:Microsoft SQL Server Support Dear Microsoft SQL Server Support Team, I am experiencing installation issues with SQL Server 2025 Express Edition on my ASUS TUF Gaming A15 laptop running Windows 10 Home Single Language. During setup, the installation…

SQL Server Database Engine
asked 2026-03-15T14:24:39.82+00:00
sanjay MN 0 Reputation points
commented 2026-04-20T17:48:06.98+00:00
sanjay MN 0 Reputation points
2 answers

Issues with SQLSetConnectAttr and SQL_ATTR_ENLIST_IN_XA

When using this for implementing an xa-switch for usage with an XATMI product with 2 different thread of controls, the ODBC-driver returns XAER_RMERR in the following scenario Thread A OP_START with TMNOFLAGS Thread A OP_END with TMSUSPEND Thread B…

SQL Server Database Engine
asked 2026-03-26T21:52:19.2733333+00:00
Kristian Ivarsson 0 Reputation points
commented 2026-04-20T16:45:56.3233333+00:00
Kristian Ivarsson 0 Reputation points
1 answer

SQL Server 2025 - DTExec.exe.config file included assembly dependancies range for Microsoft.Data.SqlClient.dll

We observed that DTExec.exe.config (SQL Server 2025 SSIS runtime) contains an assemblyBinding bindingRedirect entry for Microsoft.Data.SqlClient with oldVersion="0.0.0.0-5.0.0.0" redirecting to newVersion="5.0.0.0". We integrate…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,785 questions
asked 2026-04-20T14:28:11.3366667+00:00
Abhishek Modi (amodi) 20 Reputation points
answered 2026-04-20T14:28:32.77+00:00
Q&A Assist
1 answer

SSRS Install Fails because Access Control List is not in Canonical Form

We are upgrading SQL server from 2016 to 2017, which means SSRS is now a separate installation. The OS is Windows Server 2019. We ran the 2017 version of SQLServerReportingServices.exe and the main installation log reports, "UnexpectedError: Burn…

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,154 questions
asked 2026-03-16T13:49:27.29+00:00
Loc750-2546 1 Reputation point
recommended 2026-04-20T12:50:55.73+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

what data type i should use for roversion col and can i use less than greater than with it.

can i use Rowversioncol ( in my database it's synonyme timestamp is used) to run the following query to find all inseted after this @LastKnownRowVersion; SELECT * FROM YourTable WHERE RowVersionCol > @LastKnownRowVersion; data type i should use for…

SQL Server | SQL Server Transact-SQL
asked 2026-04-02T07:54:36.2033333+00:00
rajesh yadav 291 Reputation points
recommended 2026-04-20T12:37:35.11+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Unable to install micrsoft sql server

Unable to install sql server, there is some installtion of previous version is present so unable to install microsoft sql server 2019

SQL Server Database Engine
asked 2026-04-13T06:57:25.6866667+00:00
Akshay Hebbar 0 Reputation points
commented 2026-04-20T12:13:17.21+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
2 answers

Act! V22: Windows 11 preventing installation of ACT! V22because of SQL and Shell issues. Help?

I have ACT! v22 which is on a Desktop and a Laptop. Both have Windows 11 and work fine. I just purchased a new laptop and I cannot get ACT! V22 to install. The error message is related to Windows 11 not allowing SQL 2014 and Shell 2 (I believe) to…

SQL Server | Other
asked 2026-03-20T22:32:03.4466667+00:00
David Shear 0 Reputation points
recommended 2026-04-20T12:12:41.2333333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

SSAS Issue on Cube refresh gives "Subscription identifier is invalid"

Hello, Could you please help us on issue below: When we process cubes by SSIS batch, we occasionally bump into the below error: "The Subscription identifier is invalid; it must be unique when subscribing and the identifier of a registered…

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,370 questions
asked 2026-04-09T13:45:38.3033333+00:00
MICHAEL DIJKMAN 0 Reputation points
commented 2026-04-20T12:10:03.01+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
1 answer

SSRS server not available 503 error

Hi Team, I have configured SQL Server Reporting Services (SSRS) and integrated it with MS SQL Server. The setup was working fine for the past few months; however, currently, we are facing an issue while accessing the report server. Error Details: HTTP…

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,154 questions
asked 2026-04-08T14:20:02.13+00:00
Farheen Qureshi 0 Reputation points
commented 2026-04-20T12:09:25.09+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
2 answers

Access to SQL

How can we request access for someone in our company to SQL Server Reporting Services?

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,154 questions
asked 2026-03-18T18:03:35.4933333+00:00
Janet Taglianetti 0 Reputation points
recommended 2026-04-20T12:04:23.84+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

How do we request access for someone in SSRS?

How do we request access for someone in SSRS to run reports?

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,154 questions
asked 2026-03-17T18:56:04.48+00:00
Janet Taglianetti 0 Reputation points
recommended 2026-04-20T12:04:04.14+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

I cannot download the software

It appears that the account you login to your computer with does not actually have full Administrator rights, which is a requirement for installation of the 4-CU and dependent software (SQL..., etc.). Contact your IT department so that they can: …

SQL Server | Other
asked 2026-02-19T03:37:41+00:00
Marlon King 0 Reputation points
recommended 2026-04-20T12:03:37.1966667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Patching is breaking the Master Database of SQL Server Installed

Hello, I am operating Microsoft SQL Server 2019 Enterprise Edition within our environment. One of our SQL Server instances, which is hosted on a virtual machine (VM), has SQL Server Integration Services (SSIS) installed. We’ve encountered a recurring…

SQL Server Database Engine
asked 2025-07-29T17:16:10.94+00:00
Tendongho, Charles 20 Reputation points
edited an answer 2026-04-19T08:45:17.17+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator
2 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
asked 2026-02-28T15:53:48.6066667+00:00
KF-3028 0 Reputation points
answered 2026-04-19T00:57:11.8366667+00:00
Yutaka_K_JP 1,655 Reputation points
2 answers One of the answers was accepted by the question author.

SSIS - How to create an ELT process that is schema-adapative

How can I create an ELT process that is schema-adapative? If new columns are added in the source, those columns should be added to the destination and populated. If columns are otherwise changed, alters should be executed on the destination. We could…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,785 questions
SQL Server | Other
asked 2023-05-23T21:08:05.9566667+00:00
Tampa Ken 20 Reputation points
commented 2026-04-18T15:01:02.28+00:00
Ivan Mitev 0 Reputation points
1 answer

Microsoft Access Linked Table To Sql Server Express via ODBC 17 or ODBC 18 Driver

I developed a Ms Access Database (FE) from Office 365 for a laptop/desktop and I’ve always linked my tables to Sql Server Express 2025 (BE) located within a domain environment via User DSN with the ODBC 11 driver with the following connection…

SQL Server | Other
asked 2026-04-17T15:28:33.6133333+00:00
Greg Kidder 0 Reputation points
commented 2026-04-18T07:48:08.2+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer 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
asked 2026-04-17T07:24:16.13+00:00
Kamarur Rama 0 Reputation points
answered 2026-04-17T20:23:38.87+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator
2 answers

POC: Best approach to automate DB Query Stress Testing in CI/CD Pipeline for .NET Core + SQL Server + AKS?

Hi Community, We are planning a POC to automate database query stress and load testing integrated into our CI/CD workflow. Looking for guidance on tools, patterns, and real-world experience. Our Tech Stack: Backend: .NET / .NET Core Web API …

SQL Server Database Engine
asked 2026-04-17T16:07:06.1566667+00:00
Sikdar, Sameer 0 Reputation points
answered 2026-04-17T20:10:33.9966667+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator