SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
SSRS Report Server 22 Native Scale Out with a network Load Balancer not working as expected.
I have setup a 2022 SQL Instance. Using the DB from a 2012 r2 instance. I have looked over documentation. I can only get the last report server joined to the instance to display the webserver and the reports server. Example node1, 2 and 3 were installed…
Cannot alter column because it is 'ROWGUIDCOL'
After restoring a database one of my columns was changed from NULL to newid(). I tried to run ALTER TABLE Table1 ALTER COLUMN Id uniqueidentifier NULL script and I got 'Cannot alter column Id because it is 'ROWGUIDCOL'
Availability Groups in depth
Hi, I want in depth information on Availability Groups. Any link that I can read?
Microsoft (R) Visual Basic Compiler asking the upgrade the version.
We are trying to Execute SSRS report using rs.exe and will store result in CSV file. For this We have prepared (.rss) file, and executed from command prompt with following command. rs -i filename.rss -s https://server_name/ReportServer -v…
How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11
Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…
In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role.
In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role. If yes then what is that. Do I need to install SQL…
Hyper-V replica - EnableWriteOrderPreservationAcrossDisk for SQL VM not working
According to Support policy for hardware virtualization product - SQL Server | Microsoft Learn, Hyper-V replica for a VM running SQL server is a supported scenario as long as you enable EnableWriteOrderPreservationAcrossDisks as described in the…
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
Quick Connection to SQL Server in Management Studio
Hello, I am using Management Studio to manage my databases, and I have multiple servers with several different databases. Is there a way to avoid having to enter the server name and user name every time? Perhaps by presetting all connection settings?
What is the function difference between MS SQL Standard and Express
What is the function difference between MS SQL Standard and Express in MS SQL 2017
Windows 11 Microsoft SQL 2022 Express Edition
Hey, currently in work we have PC with Windows 11 Pro license which is used as small "server". Here we have installed MS SQL servers. We want to add new software database into MS SQL 2022 Express Edition but software creator said we need…
The MSSQLSERVER and AGENT service terminated unexpectedly
Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server through scheduled…
SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…
Connecting SQL Server Data to RDLC reports in Blazor .Net Framework
Hello, I am trying to create/integrate RDLC reports in Blazor .NET framework. So far: I have managed to open a RDLC report thanks this Question and Answer:…
Error when installing SSIS
I am trying to install SSIS after the install of VS 2019 and I keep running into an issue. I have a WIN 2011 machine. I have tried with VS2022 / VS 2019 Profession as well as community editions. I have installed and uninstalled many times with the hope…
Removing database from AG
I have an AG. On secondary replica, if we remove database from AG, what will be the database status on primary replica
SSRS UnhandledReportRenderingException
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). When we…
SQL Server Non Clustered Index CREATE taking forever to cancel
I ran a CREATE NON CLUSTERED INDEX command for 1.5 hours. Decided to cancel it because it was stopping other things running. The command has now been running for 22 hours. What is it doing that takes so long to roll back? The table is 2 billion rows and…
Downgrade SQL Server 2022 to SQL Server 2019
We just purchased SQL licensing for 32 cores at 2,500 per month, 1 year. We have the media to download for SQL2022; however, we need SQL Server 2019 in order to make our application work. How do we go about downgrading the instance? We have an…