Content
SSIS script task SMO call fails when running from Windows 2016 Server (sql server agent) but succeeds when run from Visual Studio or Windows 2012
This SSIS package is part of the scheduled process that worked fine for years. It started failing after we upgraded OS of SSIS SQL Server (application server) from Windows Server 2012 to Windows Server 2016. Note that this SSIS package (contentious…
SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…


error with the code: Exit code (Decimal): -2068119551 installing SQL Server 2022 Express Edition ?, i attach the sumarry.txt context in this post message
Overall summary: Final result: Error: vea los detalles a continuación Exit code (Decimal): -2068119551 Start time: 2023-03-23 17:01:46 End time: 2023-03-23 17:03:30 Requested…


Query write
Am trying to update the same table by shuffling the column data, no condition to rearrange. I just want to make sure that the ID does not match with same car name again. I tried my best with self join, Lead and LAG function still no luck. any help…
ReportViewer WebForms TotalPages shows zero when there are multiple pages
I have an application that uses Microsoft.ReportingServices.ReportViewerControl.WebForms Version: 150.1537.0 (.NET 4.8 framework) to display SSRS reports. The issue that I'm currently experiencing is that sometimes the TotalPages number in the toolbar…


How to Display multiple columns in WinForms combobox?
This picture is Access 2010.Data come from SQL. I tried to move to Winform. I know how to bind data sources. Can WinForms combobox do the same? Show 3 columns and titles, When a row is selected, return only Plan_no. I am new, maybe I need more detailed…


Can I upgrade from MS SQL server 2019 evaluation edition to SQL 2022 Standard edition? My evaluation period has expired.
I currently have a 2019 MS SQL server evaluation period installed on my machine. The version passed the expiry and I would like to purchase a license. Wonder if I can purchase a 2022 SQL server standard edition and upgrade my expired evaluation version.…


How to configure Connection string without username and password by using managed instance Azure AD authentication with Azure SQL
Hi there , I am having 4 .net web applications hosted in IIS in the domain joined Azure VM. I am using Azure Sql databases for all the applications(All dbs in a elastic pool of sql server) . Coming to connection strings for DB connectivity ,right now I…


How can i solve this?
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.…


How to backup the SQL Server resource itself not the databases?
Pretty basic scenario, someone deletes a SQL Server by accident or maliciously, doesn't matter which. What happens to all of my databases? What about all of the settings in the SQL Server resource (allowed networks, etc.)? How do I backup this SQL Server…


SQL Management Studio Query Designer not working
I cannot get SSMS to auto link tables anymore in the Query Designer, I have completely removed it, deleted the folders and reinstalled and it still won't work. Below are pictures to show you what I mean. This is a PC where it is working and my PC where…


How to change the SQL Server 2019 standard license key
Hello It takes a long time to get the SQL Server 2019 standard license key The 7-day temporary license key is registered and in use. I want to change the license key that I recently purchased, how can I change it?


what is the query statement to get list of all Users within a specific DB role?
Hello, what is the query statement to get list of all Users within a specific DB role? Thanks in advance.


A connection was successfully established with the server, but then an error occurred during the login process Error from .Net core WebAPI
Hi, I've an application that uses WebAPI in .Net core 6 and uses Kestrel server. When calling HttpPost request, the code tries to inject data in DB but fails with error: The certificate chain was issued by an authority that is not trusted. Inner…


When deployed my SSIS package does not return any rows or errows from the Excel datasource
I have created a package which gets rows from an Excel file, transforms them and writes them into a SQL Server. But the problem is that when being executed from SSDT it returns data, but when being executed using a SQL Server Agent it does not write rows…


Restoring full backup of TDE database to alternate server. The media family is incorrectly formed.
I am trying to restore a full backup of a TDE encrypted database to an alternate server. I overwrite an existing database on the destination server - but the restore fails even if I try creating a new database. Prior to encrypting the databases, I was…


How can I fix the SQL Server -2061893606 error on SQL Server 2022 Express edition?
Hello, I reset my computer completely and deleted all files because I received this error, but it still didn't fix. By the way, my operating system is Windows 11.


SQL CLR use existing Asymmetric key for new file
Hi All, Trying to work on CLR objects. I have created dll from Visual studio using strong name. Now I need to create assembly for that new file. We already have CLR implemented for another dll. I want to use same assymetric key and user to create…
partition a table on a column other than the primary key
We have some tables and we need to partition them. Some of our tables have a primary keys and we need to partition them on a column other than the primary key in order to truncate or drop the partition later on based on a specific retention. can you…


Error reported when creating a new SQL Server Reporting Service database
I'm using the SSMS Configuration Tool to create a new ReportServer database. The database is a SQL Server Managed Instance in Azure. In the SQL Managed Instance version is: "Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 18 2023 08:44:24" When…

