SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,116 questions
0 answers
Azure Data Factory: Copy Data Activity: "Schema import failed: Please select a table"
Hello! I am pretty new to Azure Data Factory and trying to build my first data pipeline. So far, I have managed to install an integration run time in my PC and established a connection to the on prem SQL server. I have tested the connection and it says…
asked 2024-06-22T10:16:15.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 22%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vanga, Bhargav
0
Reputation points
asked 2024-06-22T10:16:15.37+00:00
Vanga, Bhargav
0
Reputation points
0 answers
Assembly Create Issue in MS Sql Server 2022
Create failed for SqlAssembly 'JintLibrary'. (Microsoft.SqlServer.Smo) Assembly 'system.runtime, version=7.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL catalog. (Microsoft SQL Server, Error: 6503) the library…
asked 2024-06-22T04:56:15.9266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 73%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Karan Sahu
0
Reputation points
edited a comment 2024-06-22T09:08:43.6766667+00:00
Viorel
114K
Reputation points
2 answers
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…
asked 2024-05-24T00:46:20.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Michael F. Assis
20
Reputation points
commented 2024-06-22T03:06:44.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Brett
0
Reputation points
0 answers
SQL Server can't accessed by app services even though they're in same vnet (2 different subnets)
Hi, I recently configured a virtual network for one of my applications which has 2 subnets - appnet and datanet. The Sql server is in datanet and app services are in app net. While running the application, the network is rejecting the ipaddresses for…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,058 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,245 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,116 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,204 questions
asked 2024-06-21T13:49:46.1433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 73%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Suresh, Subin (GB)
20
Reputation points
commented 2024-06-22T01:21:39.1466667+00:00
Greg Low
1,575
Reputation points Microsoft Regional Director
1 answer
How to copy an SSAS cube
Good day, I have a cube in SSAS for one financial period, that I wish to replicate for a new financial period, how can I achieve this? Please assist Many thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
1 answer
Steps to use Cyber Ark to manage Data Source Credentials with on Prem Power BI report server
Hello, I am getting mixed results when trying to determine if Power BI report Server can use Cyber ARK PVWA for managing Data Source account passwords. Using PVWA enables Web application to connect to a credential managed Vault to retrieve service…
asked 2024-06-21T13:27:08.5466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 92%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
NORRIS, CHIP
0
Reputation points
answered 2024-06-22T01:08:18.9366667+00:00
Greg Low
1,575
Reputation points Microsoft Regional Director
1 answer
how to schedule power bi reports for email delivery?
how to schedule power bi reports for email delivery?
asked 2024-06-21T13:00:40.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 59%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Anita Amick
0
Reputation points
answered 2024-06-22T01:01:01.0833333+00:00
Greg Low
1,575
Reputation points Microsoft Regional Director
4 answers
Cannot connect to SQL Database. Please contact SQL server team for further support
Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…
asked 2022-12-20T17:10:54.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 80%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVY%3C/text%3E%3C/svg%3E)
Venkateswarlu Y
6
Reputation points
answered 2024-06-21T23:15:03.6666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jeevan Srikanth Nalla
0
Reputation points
2 answers
Error Restoring Specific Filegroups to a New Database: "The backup set holds a backup of a database other than the existing"
Hello, I am currently working with SQL Server 2019 Web Edition and need to restore specific filegroups from a production database to a new database in a development environment. Here are the steps I've followed so far, along with the errors I'm…
asked 2024-06-21T08:44:27.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 62%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vinith
25
Reputation points
answered 2024-06-21T22:20:43.35+00:00
Erland Sommarskog
104.1K
Reputation points MVP
2 answers
indexes - cleanup
Hi All, Need some suggestions on how to disable or drop some of the unused indexes? Regards, Sam
asked 2024-06-19T05:10:52.2333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 13%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sam
1,396
Reputation points
commented 2024-06-21T22:16:46.2933333+00:00
Erland Sommarskog
104.1K
Reputation points MVP
3 answers
Mssql express installation failure
I am trying to install sql express on my laptop but i am unable to i have attached the error message and error file Summary_DESKTOP-JU2JTT1_20240604_154222.txt
asked 2024-06-04T14:48:02.3+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 47%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Samuel
0
Reputation points
commented 2024-06-21T22:10:35.69+00:00
Erland Sommarskog
104.1K
Reputation points MVP
0 answers
System Database Backups for Azure SQL Managed Instance
I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…
asked 2024-06-21T20:35:16.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
Chancellor, Joe
0
Reputation points
asked 2024-06-21T20:35:16.1766667+00:00
Chancellor, Joe
0
Reputation points
1 answer
Error loading Oracle components in VS 2019 after SSIS upgrade to version 4.6 and rollback to 3.16
I'm getting the following error when attempting to open an Oracle source, destination, or connection manager in VS 2019. The text version of the above screenshot and message details are in the code block below. We began encountering this error after…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,787 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,493 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.
190 questions
asked 2024-06-20T18:12:19.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 73%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Amanda Hansen
0
Reputation points
commented 2024-06-21T19:54:53.9333333+00:00
Amanda Hansen
0
Reputation points
0 answers
Get error column name using script transformation
Hello, Hello with error caused by the GetIdenfificationStringByLineageID. I'm trying to get the actual error column name and I can't get pass this error message. Thanks,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
1 answer
Place Rounded Border in Reporting Services
I am currently using Report Builder, and I would like to know the way to place a rounded border in the corner of a table or text box Currently it can only be squared and I would like a border like this: is it possible to do this? if possible how would…
asked 2023-06-22T05:04:18.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 43%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marco Tulio Chavez Maradiaga
0
Reputation points
commented 2024-06-21T18:12:45.7566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 57.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kathern Wilenski
0
Reputation points
2 answers
increase in database size
Hi All, We have a 2 TB disk to stored of the sql database files. db has 3 data files and 1 log file. log file is stored on a different drive. The issue is with the data file drive. Current disk usage (E:\ drive) reached is 1.20 TB out of 2TB. After…
0 answers
Matrix's backgroud color
HI, I NEED A HELP I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K. I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX... HOW CAN I DO THIS…
asked 2024-06-21T16:06:29.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 95%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELI%3C/text%3E%3C/svg%3E)
Luciana Iura de Oliveira Mello de Melo
0
Reputation points
asked 2024-06-21T16:06:29.46+00:00
Luciana Iura de Oliveira Mello de Melo
0
Reputation points
0 answers
SharepointListSource Issue in SSIS when Deploymed on SQL Server 2019
Hello, i have an SSIS Package project that was designed in 2015 and was working fine and deployed on the windows server 2012 R2 targeting SQL Server 2014.Now we are migrating to windows server targeting SQL Server 2019.I took the package and opened it in…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,544 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,116 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,071 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,493 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,521 questions
asked 2024-06-21T15:50:35.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 96%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tumo Maraisane
0
Reputation points
commented 2024-06-21T15:57:19.5133333+00:00
Tumo Maraisane
0
Reputation points
2 answers
Software Download Verification
Is their a location on Microsoft website that provides the hash values and algorithm used for all their file download such as SSMS, visual studio etc..
asked 2024-06-18T17:50:57.0766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 97%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELW%3C/text%3E%3C/svg%3E)
Lazarus Wright
0
Reputation points
commented 2024-06-21T15:54:35.4966667+00:00
Lazarus Wright
0
Reputation points
2 answers
Error on report after upgrading to build 16.0.1115.92
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). In early May…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)