21,525 questions with SQL Server-related tags

Sort by: Updated
0 answers

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,369 questions
asked 2026-04-09T13:45:38.3033333+00:00
MICHAEL DIJKMAN 0 Reputation points
1 answer One of the answers was accepted by the question author.

Error Update SQL Sever version

Hi Expert, I'm updating SQL Server 2019 RTM version with Latest Update version but failed that report log message " The NT service 'MsDtsServer150' could not be stopped" what should i do to resolve this error? great thanks for all warm…

SQL Server Database Engine
asked 2026-04-09T10:00:07.8+00:00
Urbel 545 Reputation points
accepted 2026-04-09T10:02:48.2133333+00:00
Urbel 545 Reputation points
2 answers

Cannot Deploy SSIS project. Error: Could not load type Microsoft.Internal.VisualStudio.Shell.Interop.IVsCustomTelemetryService from assembly Microsoft.Internal.VisualStudio.Interop PublicKey

I get this error trying to deploy a package after installing VS2026 March 2026 release Version 18.4.2. All though it does deploy the error pops up after every step during deployment. I tried a repair, I tried removing the ComponentModelCache folder and…

SQL Server Integration Services
SQL Server Integration Services

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

2,783 questions
asked 2026-03-27T13:39:52.1333333+00:00
Barr, David 10 Reputation points
answered 2026-04-09T09:38:24.3266667+00:00
Guy Barrett 0 Reputation points
3 answers One of the answers was accepted by the question author.

direct link to download the offline installer for SQL Server 2019 evalution

Hello, I need the direct link for: https://www.microsoft.com/en-us/evalcenter/download-sql-server-2019, but this link provides to me an exe file, and I need the direct link to the ISO to script. Is not the express version, is standard, tks

SQL Server | Other
asked 2022-07-07T21:39:23.877+00:00
Osvaldo Martins Yariwake 21 Reputation points
commented 2026-04-09T09:32:02.75+00:00
Richard Rozema 0 Reputation points
2 answers

Issue with Getting email from Gmail from SQL Server 2019 Home Lab Server

Dear Team, i have configured profile with account and giving smtp.gmail.com with 587 and 25 port each time but not sure why not getting email on my gmail inbox from db server that is running on windows server 2019 with sql server 2019. error msg says…

SQL Server | Other
asked 2026-04-06T06:31:12.9033333+00:00
mirza hussain 0 Reputation points
commented 2026-04-09T09:12:28.59+00:00
Lakshmi Narayana Garikapati 1,225 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,153 questions
asked 2026-03-18T18:03:35.4933333+00:00
Janet Taglianetti 0 Reputation points
commented 2026-04-09T09:06:00.5333333+00:00
Lakshmi Narayana Garikapati 1,225 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
commented 2026-04-09T09:03:30.18+00:00
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server 2019 Master Data Services Excel Add-in issue on new server

Hi All, We are migrating our SQL Server 2019 Master Data Services (MDS) installation running on Windows Server 2019 to a new installation on Windows Server 2019. We have migrating only databases on new server With Edge it's ok but with MDS Excel…

SQL Server | Other
asked 2026-04-01T15:08:17.6666667+00:00
Reinero Joel 0 Reputation points
edited an answer 2026-04-09T08:32:08.1866667+00:00
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator
4 answers

STAR Schema Model Design

Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…

SQL Server Database Engine
asked 2026-01-28T02:53:43.0233333+00:00
pdsqsql 436 Reputation points
recommended 2026-04-09T04:12:57.2366667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
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-09T03:49:53.8+00:00
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator
2 answers

Unable to run SQL Server Migration Assistant for MySQL

I have installed SQL Server Migration Assistant for MySQL but it will start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How can 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.

605 questions
SQL Server | Other
asked 2024-02-27T00:20:41.68+00:00
John Wilson 15 Reputation points
answered 2026-04-08T15:56:46.24+00:00
Josh Ricketts 0 Reputation points
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,153 questions
asked 2026-04-08T14:20:02.13+00:00
Farheen Qureshi 0 Reputation points
answered 2026-04-08T14:20:17.82+00:00
Q&A Assist
3 answers

Copying a 32-Million Row Table From Production Server to Test Server

So we believe we're having tempdb issues with a very wide table that has 32-Million Rows on it. There is no Primary Clustered Index, No Indexes defined on it at all. We have tried an INSERT SELECT going across a Linked Server to our Test Server to copy…

SQL Server | SQL Server Transact-SQL
asked 2026-03-13T19:43:14.18+00:00
Bobby P 271 Reputation points
commented 2026-04-08T12:27:00.6666667+00:00
Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator
2 answers

Guidence required in time bound index reorganization job

We are planning to configure an Index Reorganize job on the server with a specific operational constraint. The job must complete or stop before the customer’s business hours begin (05:00 AM server time). If the job is still running at 05:00 AM and needs…

SQL Server | Other
asked 2026-03-15T13:34:58.7566667+00:00
Raju Kothapally 10 Reputation points
commented 2026-04-08T11:11:58.0533333+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
2 answers

SQL Agent Job failing with Error 8152 (String or binary data would be truncated) during Replication/Distribution

Hi everyone, I am encountering a persistent failure in a SQL Server Agent Job that appears to be related to a Replication Distribution Agent. The Error: The job fails at Step 1 (Distribution Agent startup) or Step 3 (Detect nonlogged agent shutdown) with…

SQL Server | Other
asked 2026-03-12T19:52:40.2633333+00:00
Ramya 0 Reputation points
commented 2026-04-08T06:24:23.51+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
1 answer

How to fix SQL Server installation error and run successfully

I have repeatedly install Microsoft SQL 2025, though it show that the server is running but I have been unable to connect as I keep having error message; see below - TITLE: Error The client was unable to establish a connection because of an error during…

SQL Server | Other
asked 2026-03-10T23:13:31.24+00:00
Gregory Mwenketishi 0 Reputation points
commented 2026-04-08T06:06:31.5733333+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
2 answers

when is the update to sql server be available to allow vector index with GUID

Trying to use sql server with Vector indexing for tables with GUID keys. We don't use INT for keys. When will updatable guid key tables with Vector indexing be available. Thank you David

SQL Server Database Engine
asked 2026-03-10T13:17:45.1366667+00:00
OnePage 20 Reputation points
edited a comment 2026-04-08T05:50:48.45+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
2 answers

Connect ssms to sql server

How to connect SSMS to SQL SERVER. New installation of SQL 2025 and ssms.

SQL Server Database Engine
asked 2026-03-10T01:56:57.0366667+00:00
Keith Oliver 0 Reputation points
commented 2026-04-08T05:31:02.16+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
1 answer

can you use ssrs integrated mode in sharepoint subscription edition

can you use ssrs integrated mode in sharepoint subscription edition

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,153 questions
asked 2026-04-06T20:40:18.06+00:00
Reeves, Jim 0 Reputation points
commented 2026-04-08T05:25:31.9166667+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
2 answers

How to change SQL Server Instance from running to start?

I am trying to open PCM600 for writing to relays. When trying to open the pop up that show is PCM600 has encountered a problem. SQL Server instance not found. Verify that SQL Server is installed and running. Not sure what I am supposed to do. I go into…

SQL Server Database Engine
asked 2025-10-28T12:08:30.0033333+00:00
Donald Rutledge [EXT] 0 Reputation points
recommended 2026-04-08T04:51:57.2933333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator