144 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition?

Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition? Here is my SQL Server details SQL Server Management Studio 20.2.30.0 SQL Server Management Objects…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-10-03T13:37:18.4033333+00:00
Lyles, Kevin 0 Reputation points
0 answers

SDDL permission changes to allow non-admin service account to SQL Services

I have managed service account with local admin privilege. I created non-admin service account and I want to give it the same permissions as the managed service account has. I got SID and SDDL string. I tried to make changes to SDDL and command prompt…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,048 questions
asked 2024-10-02T14:21:50.7166667+00:00
Lucja Dolega 0 Reputation points
0 answers

CSP header

We are using SSRS via the standard Web Portal URL. The security department is particular about the CSP header. What is the minimum CSP SSRS Web Portal needs to have? Can we remove 'unsafe-inline' 'unsafe-eval' from the CSP header?

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.
2,918 questions
asked 2024-10-02T03:12:07.7533333+00:00
work account 1 0 Reputation points
0 answers

how to fix "XAAccess - EnableXAAccess(EnalbeXAAccess) => Exiting(False)" error in DB2OLEDBv6 in for Windows 2019 Server

When install DB2OLEDBv6.msi for a Windows 2019 Server it start install, but in middle cancel and do rollback for install process. I tried install it with "DB2OLEDBv6 /quiet /l log.txt" In log.txt file appears first errors: Calling custom…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,744 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.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,744 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.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia 0 Reputation points
0 answers

how to fix "XAAccess - EnableXAAccess(EnalbeXAAccess) => Exiting(False)" error in DB2OLEDBv6 in for Windows 2019 Server

When install DB2OLEDBv6.msi for a Windows 2019 Server it start install, but in middle cancel and do rollback for install process. I tried install it with "DB2OLEDBv6 /quiet /l log.txt" In log.txt file appears first errors: Calling custom…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,744 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.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,744 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.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia 0 Reputation points
0 answers

Azure DevTunnel Host cannot access sql server instance.

Hi. I'm trying to access my local SQL Server instance remotely, using Azure DevTunnel as the remote host. I'm doing the following: devtunnel host -p 1433 -a Then I'm using the host that comes back to attempt to log in to sql server. This doesn't seem…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-09-30T13:47:02.5833333+00:00
Nore Gabbidon 0 Reputation points
0 answers

Ambiguous variable property override in SSIS

0 In instances where a user tries to override the same variable multiple times while executing a SSIS package, all the records in SSISDB.internal.execution_property_override_values seem to be updated. DTExec.exe /ISServer…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-09-26T10:29:07.82+00:00
Prabin Kayastha 0 Reputation points
0 answers

Ambiguous variable property override in SSIS

0 In instances where a user tries to override the same variable multiple times while executing a SSIS package, all the records in SSISDB.internal.execution_property_override_values seem to be updated. DTExec.exe /ISServer…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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.
13,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-09-26T10:29:07.82+00:00
Prabin Kayastha 0 Reputation points
0 answers

Multiple SELECT CONTAINSTABLE conditionals

I have a SQL code that exceeds the 4000 character limit and I'm trying to split it. The example works (I've removed a lot of words). USE [Esp BOE - Derecho Civil] GO SELECT SQL_TABLE.*, FT.* FROM [Libro_BOE - Codigo de Contratos] AS SQL_TABLE INNER JOIN…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-09-23T03:23:37.85+00:00
zequion 446 Reputation points
edited the question 2024-09-24T02:18:41.1366667+00:00
zequion 446 Reputation points
0 answers

SSMA says my SQL Server agent isn't running, but it is.

When connecting to my target SQL instance, on the same server as SSMA, it gives me a warning that SQL Server Agent isn't running and must be up. However, it is up and running. What is it looking for, and how do I get it to recognize the actual status?

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.
532 questions
asked 2024-09-22T17:06:40.97+00:00
Kevin Slack 0 Reputation points
0 answers

Oracle Partners

How can I find Partners with competency to migrate Oracle workloads to Azure?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-09-11T21:42:30.5533333+00:00
David Carvalho 0 Reputation points
edited the question 2024-09-12T02:55:30.75+00:00
AmaranS 6,410 Reputation points Microsoft Vendor
0 answers

Host Restarts in Azure Function Triggered by EventHub, Causing Data Loss

Hello, I'm currently working with v4 Azure Function app running on Linux, implemented in python using v2 programming model, which is triggered by EventHub. The function processes incoming payloads, performs some transformations, and writes the data into…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,971 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
636 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.
13,771 questions
asked 2024-09-11T11:38:09.7366667+00:00
Jusuf Ramic 0 Reputation points
0 answers

Microsoft Access/SQL Server Hosted on Azure - How to Distribute to End Users

I am wanting to use Microsoft Access to create various dashboards/forms for inventory management, PO requests, and maintenance.  I feel confident in my abilities on the Microsoft Access development end.  I guess what I’m looking for is advice on how to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
389 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
877 questions
asked 2024-08-28T16:10:50.44+00:00
Kyle Chesshir 0 Reputation points
edited the question 2024-08-29T06:11:51.9566667+00:00
ShaktiSingh-MSFT 15,301 Reputation points
0 answers

Login failed for user 'IIS APPPOOL\DefaultAppPool' MS SQL Studio 2019 Express Defaultapppool user stopped being created in last month

Login failed for user 'IIS APPPOOL\DefaultAppPool' MS SQL Studio 2019 Express Defaultapppool user stopped being created in last month Defaultappppool advanced setting set to true. Cannot open website after created. If I manually add Defaultapppool user…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,744 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.
13,771 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
9,587 questions
asked 2024-08-09T20:30:56.3066667+00:00
Jeter 0 Reputation points
0 answers

How to setup Azure Automation account to restore database on SQL MI ?

Hello, I have a PowerShell script (see below) that I currently run daily from a task scheduler on a VM to restore a production database (SQL Managed Instance) to a secondary instance (SQL Managed Instance). I am planning to move this process to an Azure…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,254 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,502 questions
asked 2024-07-23T20:11:08.8833333+00:00
Anoop Noel Nakkala 0 Reputation points
edited the question 2024-08-08T04:04:42.66+00:00
Givary-MSFT 32,501 Reputation points Microsoft Employee
0 answers

CDC Attunity : Async switch from online redo log to archived log when online logs are not available

My organization has been using the CDC Attunity tool for the past three years to manage data replication between an Oracle 11g source database and a SQL Server 2016 destination database. Recently, we have encountered an issue where the tool is unable to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-07-29T14:16:57.0366667+00:00
Krutika Shirbhate 0 Reputation points
0 answers

How can I get/update the DataSource linked to a SSRS Subscripton via API 2.0?

I have a subscription that has its data source connection severed every time I update the source report (the subscription is on a linked report). I want to get the DataSource so that I can verify it exists and then reassociate it to the subscription. If…

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.
2,918 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,502 questions
asked 2024-07-25T18:38:09.8266667+00:00
Kalata, Wesley 0 Reputation points
0 answers

What to do about "window.$RSjQuery is not a function" in Reserved.ReportViewerWebControl.axd

I inherited an ASP.NET Web Forms project that uses RDLC. It was using the Microsoft.ReportViewer 11.0.3366.16 NuGet package and my task has been to upgrade it to the Microsoft.ReportingServices.ReportViewerControl.WebForms 150.1652.0 NuGet. By…

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.
2,918 questions
asked 2024-07-24T15:34:12.08+00:00
Kevin Lipscomb 0 Reputation points
0 answers

SSRS Failed to Load Resource with Status code 401

Dear All, I am facing issue while accessing Report server dashboard from Application Server Browser(Edge). My Report Server URL is : http://IP:8081/Reports, https://ssl/Reports browser is continuously asking for username and password even though…

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.
2,918 questions
asked 2024-07-23T06:06:31.8666667+00:00
Prashant Sawant 0 Reputation points
0 answers

SSRS Bing Maps Intermittent Error

We are using SSRS to create reports with a mapping component for our SQL Server 2019 database. We are using the default Bing maps tile layer to show a Road background for the maps. Starting earlier this month we have had an intermittent error where a…

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.
2,918 questions
asked 2024-07-22T12:40:09.2666667+00:00
Christopher Doseck 26 Reputation points