How to create initial full backup followed by transaction logs daily?
This is related to work. I have been sending out a full-back up of a database in BAK file format (using SQL Server 2022) for a client, but now the client is asking for an initial full backup followed by transaction logs daily. How do I go about doing it…
SQL Server | SQL Server Transact-SQL
Facing issue with SQL Server CDC
Hi Team, I am working on Change Data Capture feature in SQL Server (on premises). In the Database in which Change Data capture feature is enabled, I am having a table MQ which gets filled with a CT table, having a SQL function which selects data from…
SQL Server Database Engine
How can I recover my purchased Microsoft SQL 2019 license?
Good morning, I purchased a Microsoft SQL Server license on August 20, 2021. Authorization number: [Moderator note: personal info removed] License number: [Moderator note: personal info removed] I need to reinstall the server using the license with its…
SQL Server Migration Assistant
Getting an error installing SQL Server 2022 in my computer
I'm getting error when installing SQL server 2022. I'm attaching the summary and details log here.Detail.txt
SQL Server Database Engine
Issues with SSRS Configuration Manager reports
Hi, we have been struggling with this for a while now (we needed to change Configuration Manager SSRS service account password and then this started): 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.…
SQL Server Reporting Services
How to install my SQL Server Express 2025
Hi, I have issues regarding the SQL Server 2025 Express and I got this error/trouble-shooting message popped up this display. Can you help me process this step by step how to resolve this? I'm using Windows 11 (I think) in this case. Thank you.
SQL Server | Other
SQL volume license not available
SQL server license was purchased through our reseller. Volume license is still not visible on my admin account
SQL Server Database Engine
ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering
We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2): https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/ The issue is that using…
SQL Server Reporting Services
I have installed SSMS 2022 but unable to login.
Hello Team, I have installed SSMS 2022 on my local laptop. But I am unable to connect to the connection string. My laptop server name is ASHISH and instance name is MSSQLSERVER. I am entering ASHISH\MSSQLSERVER as Server Name but it is showing error code…
SQL Server Database Engine
Applying token authentication to read data from a ZenDesk source in a SSIS 2022 package
Hi, I need to maintain an existing SSIS 2022 package that performs an API call to a ZenDesk source by the removed username and password authentication method, changing this authentication type to token one. Unfortunately, I don't know ZenDesk and I have…
SQL Server Integration Services
Microsoft SQL Server 2025 availability on CSP
When will Microsoft SQL Server 2025 be available on CSP and does it come with PBIRS Functionalities and Software Assurance
SQL Server Integration Services
SSRS Report Credential Error
SSRS report works initially but fails after 10–15 minutes of idle time. When user clicks Next page, Print, or Download, the report throws error: "Credentials have not been supplied for a data source used by the report." The report is generated…
SQL Server Reporting Services
PBIRS error when creating a scheduled refresh
PBIRS 15.0.1118.126 Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) 2026-01-12 10:50:43.3169|ERROR|54|OData exception occurred: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred…
SQL Server Reporting Services
Microsoft ODBC Driver for SQL Server Version 17.10.000
Microsoft ODBC Driver for SQL Server Version 17.10.000 returns with error "Test failed" Anyone can assist me with this issue or any ideas, currently it is installed on Windows 11 VM.
SQL Server Database Engine
How does one go about buying a SQL license?
I know this sounds like it should be simple, but it's not. The marketplace goes nowhere, call MS, they don't call back. I assume I need to find a licensed partner, but that is also no response. Can anybody point me to somebody that I can give money to…
SQL Server | Other
I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?
I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?
SQL Server | Other
A Scalar UDF works consistently in SQL Server 2017, fails sporadically under 2019 and 2022.
You can try this at home! I use this udf to capture the number of cores available when my stored procedure runs in cloud. But, since I develop against my local on-prem database, I coded it to return a -1 when it's not running in the cloud. Here's the…
SQL Server | SQL Server Transact-SQL
SQL Server Developer Edition Installer can't identify an installed software it needs.
Hi! I'm having a problem installing Microsoft SQL Server Developer Edition. It says that a certain software is not installed, although it is indeed installed. Any idea how can I solve this issue? The following lines are copied from Details.txt…
SQL Server Database Engine
SSIS Data Flow has trouble when it has to return many fields
I have an SSIS project that calls stored procedures to create extract files via OLE DB Source & Flat File Destination. The stored procedure returns 150 fields and sometimes a few million records. This causes SSIS & Visual Studio 2019 to take a…
SQL Server Integration Services
how to resolve degraded sql performance since upgrading from sql 2016 to sql 2022
We have a sql instance ( on premise) that was running sql 2016. Query store was not enabled. We have a large workload that runs overnight, hundreds of stored procedures. We have upgraded to sql 2022, but had an approximately 10% increase of the duration…