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
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
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
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
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
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
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
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
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
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
Windows Server
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
SharePoint Server Management
Windows Server
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
SQL Server
Windows Server
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
Windows Server
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
Windows Server
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
Windows Server
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
Windows Server
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
Windows Server
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
SQL Server
Windows Server
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
Windows Server
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…