SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,060 questions
4 answers
Where and how do I add the SQL license key when SQL server reporting services expire
Our SQL 2022 reporting services stopped working. We figured out it had expired, and I must add the SQL license key. I need to know the process of adding the license key to SQL reporting services.
asked 2024-11-20T21:34:40.0933333+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(124.80000000000001, 57.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Dennis Huston
0
Reputation points
commented 2024-11-21T18:26:40.3233333+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
67,251
Reputation points
4 answers
Where and how do I add the SQL license key when SQL server reporting services expire
Our SQL 2022 reporting services stopped working. We figured out it had expired, and I must add the SQL license key. I need to know the process of adding the license key to SQL reporting services.
asked 2024-11-20T21:34:40.0933333+00:00
Dennis Huston
0
Reputation points
commented 2024-11-21T18:26:40.3233333+00:00
Bruce (SqlWork.com)
67,251
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS server 2022 connecting to SQL Server 2019 - Jobs are failing
Good day, We have many SSIS packages developed and stored in the file system. We're running them using dtexec utility like this dtexec.exe /FILE E:\SSIS_ROOT\VA\package\exec_usp_File_Extract_Setup.dtsx /SET…
asked 2024-11-15T18:33:44.1866667+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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
7,886
Reputation points
commented 2024-11-21T14:24:52.6233333+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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,961
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS server 2022 connecting to SQL Server 2019 - Jobs are failing
Good day, We have many SSIS packages developed and stored in the file system. We're running them using dtexec utility like this dtexec.exe /FILE E:\SSIS_ROOT\VA\package\exec_usp_File_Extract_Setup.dtsx /SET…
asked 2024-11-15T18:33:44.1866667+00:00
Naomi Nosonovsky
7,886
Reputation points
commented 2024-11-21T14:24:52.6233333+00:00
Yitzhak Khabinsky
25,961
Reputation points
0 answers
Free up space in mdf
Hi guys, When I want to shrink a databasefile I do see there is approx 90% of free space and when I start the shrink it doesn't do anything. When I want to shrink the database I do see no free space. Can somebody explain this to me? kr Marco
asked 2024-11-19T15:41:56.54+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, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Marco Bakker | DBA.nl
72
Reputation points
commented 2024-11-21T13:59:11.91+00:00
Marco Bakker | DBA.nl
72
Reputation points
0 answers
How to fix setup SQL Express Server 2022
Can't install SQL Server (Express) 2022 Detail.txt When i first tried to install SQL Server, the error '%1 is not a win32 app'. I tried installign again without firewall after removing everything. Now I have this issue.
asked 2024-11-21T13:18:00.3466667+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(105.60000000000001, 97%, 20%)' 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)
Verstraete Brent
0
Reputation points
asked 2024-11-21T13:18:00.3466667+00:00
Verstraete Brent
0
Reputation points
0 answers
Azure MI Linked Server
Hi Team, I want to create linked server in Azure Managed Instance using Microsoft OLEDB driver, but I am unable to do the same so can you please help me with that if there is any way where we can do that. Or is there any other solution to connect Azure…
asked 2024-11-21T10:43:38.2166667+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(230.39999999999998, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Prateek Hiremath
0
Reputation points
commented 2024-11-21T12:16:51.6933333+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, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,125
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Documented CREATE CERTIFICATE with FORMAT = 'PFX' example, gives syntax error
Hello, I'm trying to use the CREATE CERTIFICATE command in SQL SERVER 2019 but I get the error: Incorrect syntax near '='. Using the example: E. Creating a certificate from a PFX file CREATE CERTIFICATE Shipping04 FROM FILE =…
asked 2024-11-21T10:14:57.5333333+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(112.00000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Chitacu, A. (Adrian)
0
Reputation points
accepted 2024-11-21T11:23:40.9433333+00:00
Chitacu, A. (Adrian)
0
Reputation points
1 answer
Why the same issue is been addressing in both KB
KB5042749: This KB article addresses the CVE-2024-37341 vulnerability by fixing a specific issue in the affected software. The exact nature of the fix can include code changes to eliminate the vulnerability, such as patching a security hole or updating…
asked 2024-11-21T06:28:55.12+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(316.8, 60%, 40%)' 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)
Balakrishna
0
Reputation points Microsoft Vendor
answered 2024-11-21T07:16:43.6166667+00:00
ZoeHui-MSFT
37,991
Reputation points
1 answer
Why the same issue is been addressing in both KB
KB5042749: This KB article addresses the CVE-2024-37341 vulnerability by fixing a specific issue in the affected software. The exact nature of the fix can include code changes to eliminate the vulnerability, such as patching a security hole or updating…
asked 2024-11-21T06:28:55.12+00:00
Balakrishna
0
Reputation points Microsoft Vendor
answered 2024-11-21T07:16:43.6166667+00:00
ZoeHui-MSFT
37,991
Reputation points
2 answers
Error -2054422515 installing SQL Server Express using a .net desktop application
We use a 3rd party application to install/upgrade sql server on client PC. But it is throwing an exception stated above.Detail.txt What I am trying: Upgrade SQL Server from 2012 to 2016 SP3 using 3rd party installer. Here I am attaching the Detail log…
![](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, 8%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
0 answers
Upload to Azure Migrate - Error AADSTS16000
I am using the latest version of Data Migration Assistant. Once I finish the assessment of a local SQL Server instance and try to upload the assessment to Azure migrate, I get this error after signing in to my Azure account. I can log into the portal and…
asked 2024-11-15T06:26:16.32+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(60.8, 62%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Agam Chauhan
0
Reputation points
commented 2024-11-21T05:49:05.9733333+00:00
Agam Chauhan
0
Reputation points
1 answer
Migration_Azure
I have migrated the data from SQL server to Azure SQL Database. The size on the SQL dataset was around 250 mb but on migration when i checked the size it is around 500 mb. I would like to know the reason and how can i cross check that
asked 2024-11-21T04:04:53.5+00:00
Prateek Hiremath
0
Reputation points
edited an answer 2024-11-21T04:36:40.3366667+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,505
Reputation points Microsoft Vendor
0 answers
Using Database Mail to Send Attachments Local to SQL Server
Hi All, Running SQL Server Express 2017. We have a requirement to send emails with file attachments using database mail. The files have been placed in a directory located on the same server as the SQL server. The SQL service has read-only access to the…
![](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(140.8, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV7%3C/text%3E%3C/svg%3E)
![](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(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
partition by
Hi, how to add partition by in below table where there is no date key or duration..please give example here is example of sample data customerid - 1 product - grains productcategory-rice sales- 1000
![](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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
1 answer
ADO.NET connection failure to Azure Database from VS 2022 SSIS Package running against SQL Server 2022 using Microsoft SQLClient Data Provider
I have a SSIS package running on SQL Server 2022 in VS2022 that connects to a 3rd party Azure database as a source with ADO.NET using Microsoft Entra Password that has been running successfully for a few years. However, recently I needed to make…
asked 2024-11-12T13:59:46.06+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(102.4, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Teresa Thomas
1
Reputation point
commented 2024-11-21T01:57:38.74+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
975
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
cluster Index
if we have large amount of data and customer id would be unique key and product and product and price and billons of data how cluster Index is doing in memory operation? and helpful would be non cluster Index here is example of sample data customerid…
1 answer
System.Data.Entity.Infrastructure.DbUpdateConcurrencyException HResult=0x80131501 Message=Store update, insert, or delete statement affected an unexpected number of rows (0).
using System; using System.Collections.Generic; using System.Data; using System.Data.Entity; using System.Data.Entity.Infrastructure; using System.IO; using System.Linq; using System.Net; using System.Web; using System.Web.Mvc; using…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
754 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,945 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,060 questions
asked 2024-11-18T17:56:30.2966667+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(316.8, 3%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Phạm Thanh Lam
0
Reputation points
commented 2024-11-21T01:03:25.0833333+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, 62%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
Hongrui Yu-MSFT
2,865
Reputation points Microsoft Vendor
1 answer
How to install Reporting Services in an Azure SQL VM
Hello, I have an Azure SQL VM and i need to install SQL Reporting Services. I downloaded the setup but it asking for a serial number that i don't have. How do i know the serial number of SQL to insert in the instalation process? Or there is another way…
asked 2023-11-21T15:33:23.5+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(256, 21%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sérgio Raposo
0
Reputation points
edited a comment 2024-11-20T23:29:38.1833333+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(265.6, 28.000000000000004%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Daniel Montero
0
Reputation points
0 answers
ODBC DSN (SQL Server 18 driver) can't connect to Azure hosted database using ActiveDirectoryServicePrincipal
I have an ODBC DSN set up using SQL Server ODBC driver 2018.184.01.01. I can connect to my Azure hosted database using this DSN in Python, with the DSN, UID, PWD in the connection string. However attempting the same connection string using the C language…
asked 2024-11-20T21:48:56.5366667+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(224.00000000000003, 41%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Michael Aiello
0
Reputation points
commented 2024-11-20T22:07:04.1466667+00:00
Erland Sommarskog
112.8K
Reputation points MVP