21,536 questions with SQL Server-related tags

Sort by: Updated
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,783 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
1 answer One of the answers was accepted by the question author.

Cannot install via command line without azure extension

I am trying to perform a silent installation of SQL Server 2025 Express using a command line setup. I need to skip the installation of the Azure Extension for SQL Server, which is enabled by default. Regardless of options specified, the Azure Extension…

SQL Server | Other
asked 2026-04-17T11:34:55.86+00:00
Jerry Metcoff 21 Reputation points
commented 2026-04-17T14:32:24.4733333+00:00
Jerry Metcoff 21 Reputation points
1 answer

I've installed SQL Server management studio 22, but I do not know how to set up or specify a server name

I'm not able to find the "snap-in" for SQL server on my PC

SQL Server Database Engine
asked 2026-01-14T22:26:15.6666667+00:00
Harvey Fram 0 Reputation points
commented 2026-04-17T13:13:01.55+00:00
Dinesh Yadlapalli 85 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
asked 2026-03-26T16:15:30.4366667+00:00
Bobbala Anusha 0 Reputation points
commented 2026-04-17T03:41:53.11+00:00
Akhil Gajavelly 1,810 Reputation points Microsoft External Staff Moderator
2 answers

Migrating Large Size scale Database

Hi all, what is alternative method to migrating side by side large size Database thanks for all reply regards, Urbel

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 2026-02-24T02:50:57.9666667+00:00
Urbel 585 Reputation points
answered 2026-04-16T20:50:19.1033333+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How to add PDF Ifilter for SQL 2025?

Hi everyone, I am recently facing an issue regard Full-Text indexing in SQL Server 2025. I have installed SQL 2025 with Full-text indexing. Then i install Adobe IFilter. Unlike SQL 2022, i am not able to find any output for pdf when i run the below…

SQL Server | Other
asked 2026-03-25T08:02:31.93+00:00
Suresh Sukumaran 20 Reputation points
commented 2026-04-16T15:34:23.8533333+00:00
Jack Ramirez 0 Reputation points