20,478 questions with SQL Server-related tags

Sort by: Updated
1 answer

Pipeline failure in Azure Data Factory

I am working on Azure Tables to operate in direct query mode in Power BI and using SQL database for merging and transforming the azure tables data which can then be queried by power bi for real-time dashboards. Using Azure Data Factory and running the…

SQL Server Database Engine
asked 2025-06-01T09:43:40.41+00:00
Satish Inaganti 0 Reputation points
answered 2025-06-01T10:42:52.0266667+00:00
Erland Sommarskog 120.9K Reputation points MVP Volunteer Moderator
0 answers

How to fix SSRS Portal Error – “The service is not available” After Restoring ReportServer DB to RDS MySQL

Hi all, I'm encountering an issue with the SSRS Web Portal showing the error: **"The service is not available." ** Here’s the background: The ReportServer database was restored from an on-premise server to Amazon RDS Custom for MySQL. …

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,048 questions
asked 2025-06-01T08:13:01.5366667+00:00
Swe 20 Reputation points
commented 2025-06-01T09:52:57.29+00:00
Erland Sommarskog 120.9K Reputation points MVP Volunteer Moderator
1 answer

Why doesn't Entra work on FCI (on-prem) and what workaround is available (and not other 3rd party providers)

Why doesn't Entra work on FCI (on-prem) and what workaround is available (and not other 3rd party providers)

SQL Server Database Engine
asked 2025-05-29T17:08:05.3766667+00:00
Frank Pivonka 0 Reputation points
commented 2025-05-31T18:18:54.7066667+00:00
Ben Miller-(DBADuck) 195 Reputation points MVP
1 answer

Best Way to Sync/Mirror a Database Without Primary Keys to Azure Analytics (Fabric, Synapse, Databricks)?

I’m exploring solutions to sync/mirror an external database (SQL Server/Azure SQL DB) to Azure analytics services (Microsoft Fabric, Synapse, Databricks), but my source tables do not have primary keys (PKs). Current Challenges: Explored Synapse sync…

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,342 questions
asked 2025-05-30T12:58:06.2866667+00:00
Gnanasoundari 45 Reputation points
commented 2025-05-31T08:09:31.0733333+00:00
Erland Sommarskog 120.9K Reputation points MVP Volunteer Moderator
2 answers

publication having 2 subscribers

We have transactional replication configured. We have a publication having 2 subscribers. If snapshot is generated on 1 subscriber, will it generate snapshot on the second subscriber?

SQL Server Database Engine
asked 2025-05-14T14:37:29.3066667+00:00
Chaitanya Kiran 801 Reputation points
answered 2025-05-31T05:14:40.7133333+00:00
Ben Miller-(DBADuck) 195 Reputation points MVP
2 answers

SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring

Subject: SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring   Dear Microsoft Support, I am writing to request assistance with a database mirroring issue I'm encountering in our SQL Server environment. Environment…

SQL Server Database Engine
asked 2025-05-14T14:47:24.9866667+00:00
Deepak Kumar | Veracity 0 Reputation points
answered 2025-05-31T05:12:50.0866667+00:00
Ben Miller-(DBADuck) 195 Reputation points MVP
1 answer

How to connect to SQL server in an azure VM from a function app in Azure

When trying to connect from Azure function app to our SQL instance we're getting the following result Failure Exception: SQLServerException : the tcp/ip connection to host xxxxx, via port 50001 has failed. error : host. verify the connection…

SQL Server Database Engine
asked 2025-05-30T10:02:01.17+00:00
Kubheka, Trevor S 0 Reputation points
answered 2025-05-30T22:57:44.0466667+00:00
Bruce (SqlWork.com) 76,696 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Can not attach database to SQL Server Express 15.0

SQLIssue1.pdfSQLIssue2.pdf Want to attached FosterTrak database to SQL server but it does not appear on the add list as shown in images. Have done this dozens of times. How do I fix this?

SQL Server Database Engine
asked 2025-05-30T15:44:06.1033333+00:00
SuperCoder 236 Reputation points
accepted 2025-05-30T22:54:11.01+00:00
SuperCoder 236 Reputation points
5 answers

Enable parallelism for TSQL scalar UDFs involving CLR function call in SQL Server

We are working on a UDF solution for MSSQL Server. Currently we have scalar TSQL UDFs which calls CLR functions. CLR functions (written in C#) further calls C functions present in a DLL file which is imported by C# layer using DLLImport. Also due to some…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
189 questions
asked 2025-05-30T05:25:49.0966667+00:00
Rakesh Kumar 0 Reputation points
answered 2025-05-30T19:48:51.6266667+00:00
Erland Sommarskog 120.9K Reputation points MVP Volunteer Moderator
3 answers

Can't connect to SQL Server from other computers

I want to ask you about a problem. I have developed a windows application that uses a SQL Server database with SQL Server authentication (with a username and password) to log in. The database is located on a local server which uses the same network…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-11-18T18:39:52.857+00:00
R3541 1 Reputation point
edited the question 2025-05-29T21:52:00.71+00:00
DillanSimmons 6 Reputation points Admin
3 answers One of the answers was accepted by the question author.

Need to migrate the physical SharePoint 2016 SQL servers to VMs.

We have, SharePoint Server 2016 - 2 application server, 3 WFE's and 2 database servers clustered environment. The 2 database servers are in physical servers and we are required to move it to VM before July 31, 2021 due to the end of support on our SAN.…

System Center Virtual Machine Manager
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
3,071 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-11-12T19:07:11.423+00:00
Bajracharya, Prabinesh 417 Reputation points
edited the question 2025-05-29T21:51:13.55+00:00
DillanSimmons 6 Reputation points Admin
3 answers

DPM 2019 installation issue connecting to SQL 2019

Hello, I am attempting to install DPM 2019 on a new virtual machine with Server 2019. I have installed SQL 2019 locally. I have created a domain account, "sa_sql_dpm". I am running the DPM 2019 setup as Administrator, but I get an error:…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
4,088 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-10-20T18:55:34.803+00:00
Zachary Hamilton 206 Reputation points
edited the question 2025-05-29T21:47:13.6233333+00:00
DillanSimmons 6 Reputation points Admin
3 answers

Alwayson /WSFC services fileshare wintness access/permssion

We have confgured alwayson(SQl server 2016 SP2 on windows 2012 ) with two nodes and fileshare wintness use network share. need to secure the file share wintess access to other doman users in the compnay an limited acccess only for Windows failover…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-10-19T02:31:23.33+00:00
Ashwan 536 Reputation points
edited the question 2025-05-29T21:46:41.6166667+00:00
DillanSimmons 6 Reputation points Admin
1 answer

How to create ISAPI Filter in visual studio 2012 onwards

Hi Team, We are using MSMD Pump for our analysis services. where, it is hosted on IIS and shared URL to users those are accessing our cubes without having explicit access on our cube server. But now we have a requirement to track all the request…

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,342 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-10-07T15:34:21.47+00:00
Mukesh Dutt 1 Reputation point
edited the question 2025-05-29T21:44:35.51+00:00
DillanSimmons 6 Reputation points Admin
4 answers

Inherited WSUS -- Thinking about making changes, looking for direction or guide

Just started a new job and I so happen to have the most WSUS experience of the entire team. Having said that I want to make sure that I configure WSUS correctly as it's been several years since I last configured it. Currently the config is the main…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-10-07T14:40:55.823+00:00
Rob Cook 1 Reputation point
edited the question 2025-05-29T21:44:33.81+00:00
DillanSimmons 6 Reputation points Admin
2 answers One of the answers was accepted by the question author.

SQL Server Always ON

Hi All, I have configured Distributed AG from DC1 to DC2 (SQL 2017 Ent edition with CU22 version) DC1- DB1, DB2 and DC2-DB3, DB4 I have restarted DC1-DB1 SQL services, after restart DC1-DB2 should be primary. But still DC1-DB2 showing as secondary. Is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-09-22T14:11:29.307+00:00
PraveenKumar 316 Reputation points
edited the question 2025-05-29T21:41:11.2533333+00:00
DillanSimmons 6 Reputation points Admin
4 answers

IDbConnection error on process SASS database caused by Windows updates

Hello, At some point, our developer instance of Analysis Services started to give an error: Errors in the high-level relational engine. . The exception was raised by the IDbConnection interface. It does not contain any on what is wrong with it. It…

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,342 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-09-22T10:05:03.96+00:00
Vladimir Kovalenko 11 Reputation points
edited the question 2025-05-29T21:41:06.4766667+00:00
DillanSimmons 6 Reputation points Admin
4 answers One of the answers was accepted by the question author.

SCCM 2019 - Installation of WSUS - SQL

Dear all, I am trying to install SCCM as we aquired the licences. Now what I am trying to do is to install the WSUS role in the "SCCM Server". I can successfully connect to the sqlserver\sccm (the instance) but then when I launch…

Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
281 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-08-26T16:05:33.823+00:00
Daystiney 251 Reputation points
edited the question 2025-05-29T21:38:19.2733333+00:00
DillanSimmons 6 Reputation points Admin
3 answers

SCCM SUP SUSDB on sql express edition running out of disk space post every software update synch

We have setup a new SCCM secondary site which also hosts SUP SUSDB role configured on the SQL express edition which gets installed along with secondary. The problem is on monthly software update synch the SUSDB size crosses 10 GB limit & synch fails.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-08-19T12:48:35.08+00:00
AKP 1 Reputation point
edited the question 2025-05-29T21:37:24.2333333+00:00
DillanSimmons 6 Reputation points Admin
0 answers

Any easy way to determine what SSIS Package references a file name? And what Job then references that SSIS Package?

We have been provided a list of file names that were processed in error...all with pretty much the same file name prefix of NCMT_CareQualityManagement with its final part being a DateTime stamp. Is there any easy way to determine what SSIS Packages…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,694 questions
asked 2025-05-29T18:30:46.6766667+00:00
Bobby P 231 Reputation points
commented 2025-05-29T20:07:36.7166667+00:00
Yitzhak Khabinsky 26,566 Reputation points