18,674 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

SSMA - Convert adhoc DML and DDL queries

Hello, Does Microsoft SQL Server Migration Assistant (SSMA) provide a way to convert an ah-doc DML or DDL query from DB2 z/OS syntax to MS SQL Server? By other means, I have an application that today has queries that execute on a DB2 z/OS and after the…

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.
517 questions
asked 2024-07-24T17:03:00.64+00:00
Santo, Nuno 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,875 questions
asked 2024-07-24T15:34:12.08+00:00
Kevin Lipscomb 0 Reputation points
0 answers

Why is SSRS Report Subscription - Shared Schedule dropdown unsorted?

When when creating/changing a SSRS Report Subscription at the point where we need to select a Shared Schedule from the available list, the dropdown that opens is Unsorted and would be nice to have them sorted the same way that they are when Schedules are…

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,344 questions
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,875 questions
asked 2024-07-24T15:19:56.53+00:00
Nenea Nelu 66 Reputation points
0 answers

Installing IBMi Access Driver on Azure Data Factory Integration Runtime

Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,182 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
asked 2024-07-24T07:19:18.0966667+00:00
Alexandru Moise 0 Reputation points
commented 2024-07-24T14:20:12.52+00:00
Smaran Thoomu 12,615 Reputation points Microsoft Vendor
1 answer

Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update

Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
193 questions
asked 2024-07-24T06:47:23.6766667+00:00
Timbol, Mary 0 Reputation points
edited an answer 2024-07-24T13:45:13.7533333+00:00
Anna Xiu-MSFT 27,816 Reputation points Microsoft Vendor
2 answers

How to cleanup Python directories Launchpad service

I have installed the Python 3.7 machine learning feature in SQL Server but the memory growth is huge after executing several Python scripts. When you execute a SQL job with a python statement the launchpad creates folders in the…

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,344 questions
asked 2023-02-07T15:50:18.53+00:00
Eric Bezemer 191 Reputation points
commented 2024-07-24T11:26:58.1233333+00:00
RandomGuy123 0 Reputation points
3 answers One of the answers was accepted by the question author.

How to access database by External Datasource using Service Principal Name(SPN)

I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…

Azure SQL Database
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,344 questions
Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,770 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,597 questions
asked 2024-07-21T14:42:53.0533333+00:00
Devendra Parmar 20 Reputation points
commented 2024-07-24T10:39:48.5633333+00:00
Devendra Parmar 20 Reputation points
0 answers

Analysis Services reads data from a data source, but gives connection error while processing multidimensional analysis

  I have built an Analysis Services Multidimensional project using Microsoft Visual Studio Professional 2022 with the SQL Server Analysis Services 16.0 extension connected to Analysis Services on a remote SQL Server 2019 instance. The Visual Studio…

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,263 questions
asked 2024-07-24T09:58:05.98+00:00
Goglio, Gianluigi [NMS Group] 20 Reputation points
2 answers

Customer Best Practices Assessment: exclude checks/false positives

Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…

Azure SQL Database
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
383 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,344 questions
asked 2024-07-19T09:42:13.16+00:00
Berend Broekhoff 0 Reputation points Microsoft Employee
answered 2024-07-24T09:35:35.1333333+00:00
Berend Broekhoff 0 Reputation points Microsoft Employee
2 answers

Failed to Create Maintenance Plan in SQL Server 2019 show Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap)

Hi, I have been trying to create maintenance plan using maintenance plan wizard in SSMS. As i go through the plan, the prompt show error 'Saving maintenance plan failed' with Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap). The…

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,344 questions
asked 2024-07-22T06:12:07.33+00:00
Muhammad Danial Nu'man Noorman 0 Reputation points Microsoft Vendor
commented 2024-07-24T09:27:25.52+00:00
LucyChenMSFT-4874 2,995 Reputation points
2 answers

How to create Excel Connection to a SQL database

This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update the content from the SQL database.

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,344 questions
asked 2024-07-18T20:11:35.03+00:00
Jhon jr 0 Reputation points
commented 2024-07-24T08:20:55.21+00:00
LucyChenMSFT-4874 2,995 Reputation points
1 answer

Issue with SQL Server compatibility level 2022 and sp_executesql

One of our customers running SQL standard edition 2022 wanted to explore setting their database's compatibility level to 2022; but when they do this, at least one of our queries fails to return metadata. So they have to keep the compatibility level at…

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,344 questions
asked 2024-07-19T20:07:28.8033333+00:00
Eckels, Adam 0 Reputation points
commented 2024-07-24T08:20:20.6566667+00:00
LucyChenMSFT-4874 2,995 Reputation points
2 answers

How can I find my SQL server License to upgrade Report Server Configuration Manager

Our version of Report Server Config Manager is on Evaluation. We license an Azure sql server from Office365 but I cannot find the license key. I need to upgrade the RSCM but it's requiring a key.

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,344 questions
asked 2024-07-22T16:24:00.86+00:00
Mt Rose Administrator 0 Reputation points
edited a comment 2024-07-24T08:19:36.8066667+00:00
LucyChenMSFT-4874 2,995 Reputation points
1 answer

Resource Governor questions.

https://www.sqlshack.com/sql-server-2014-resource-governor/ Greetings. I'm using the link above to configure Resource Governor. I run some queries to max out the RAM usage but my PerfMon counters dont elevate the way theirs do. I can see RAM usage…

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,344 questions
asked 2024-07-23T22:05:40.0066667+00:00
chrisrdba 381 Reputation points
answered 2024-07-24T08:15:25.4333333+00:00
LucyChenMSFT-4874 2,995 Reputation points
1 answer

SQL Agent job step outcome mentions "This security ID may not be assigned as the owner of this object."

Hello, I created a SQL 2016 Agent job which copies & replaces .bak files from Source Files Location to a Network Disk Share Target Files Location that are 1 day old as follows: robocopy G:\Source_Files_Location…

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,344 questions
asked 2024-06-17T18:41:45.6+00:00
techresearch7777777 1,801 Reputation points
commented 2024-07-24T07:49:28.91+00:00
Erland Sommarskog 106.8K Reputation points
8 answers

SSMS takes 10-20 + minutes to open

When I open SSMS, I can l look at see it in Task manager like it is running but it doesn't open for quite some time after that. Sometimes 20 minutes or more. Processor Intel(R) Core(TM) i7-8750H CPU @ 2.20GHz 2.21 GHz Installed RAM 32.0 GB…

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,344 questions
asked 2021-06-02T21:42:09.04+00:00
TalComoSoy88 11 Reputation points
commented 2024-07-24T07:14:55.75+00:00
Edward Young 0 Reputation points
5 answers One of the answers was accepted by the question author.

How to migrate Microsoft dynamics NAV 2018 to SQL server

How to migrate Microsoft dynamics NAV 2018 to SQL server

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,344 questions
asked 2024-07-09T06:51:57.79+00:00
Anandhswarupp 85 Reputation points
accepted 2024-07-24T06:07:16.88+00:00
Anandhswarupp 85 Reputation points
2 answers

Multiple Users Read/Write to same SQL record

Hello, I have a pretty simple database that is read and written to through an asp.net c# website. Users see a grid with data and they can open a record to make changes. More than one user can open that same record, and what I am finding out is that when…

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,344 questions
asked 2024-07-11T20:52:39.55+00:00
Byrd, Frank 0 Reputation points
commented 2024-07-24T03:30:34.53+00:00
MikeyQiaoMSFT-0444 1,910 Reputation points
1 answer

sql server install not properly

TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: SQL Server Setup has encountered an error when running a Windows Installer file. Windows Installer error message: An error occurred during the installation of assembly…

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,344 questions
asked 2024-07-04T04:46:59.23+00:00
Ashutosh Olekar 0 Reputation points
commented 2024-07-24T03:28:36.9766667+00:00
MikeyQiaoMSFT-0444 1,910 Reputation points
2 answers

MSSQL$MICROSOFT service won´t start automatically after a Win server 2022 restart

I have a client with a Win Server 2022 (10.0.20348) and a SQL server. It turns out that SQL service will not start automatically after a restart. Now, while a restart on a server does not happen every day, I would like to know if there's a way to fix…

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,344 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,624 questions
asked 2024-07-02T16:21:01.23+00:00
Matias G. Keib 0 Reputation points
commented 2024-07-24T03:24:24.5633333+00:00
MikeyQiaoMSFT-0444 1,910 Reputation points