existing ssrs reports work however when we try to create a new or modify the existing file it won't work
existing ssrs reports work however when we try to create a new or modify the existing file it won't work. It throws the error Value does not fall in the certain Range Database using - Postgres SQL Connector - PGNP OLEDB Provider This issue happened even…
Unable to preview the file in Azure Data Factory - Failure
Hi, I have created a pipeline in Azure Data Factory to migrate a table from MS SQL Server and loaded the table in Azure Data Factory. But unable to preview the table and getting the below error. Please look into this and help me to get this fixed.…
I have reset windows and when I reinstall sql server 2012 I still cannot install it, how can I fix it?
I got errors "Database Engine Services" and "SQL Server Replication" Failed
Indexing on Subscriber
I want to create index directly on subscriber in azure sql replication. Is it possible to do it without affecting the Publisher?
Getting error when trying to import an excel file to mssql server 2022 (ssms-19)
TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) BUTTONS: OK
Can I download SQL Express on Mac computer?
Hello, Can I download SQL Server on my Mac? Thanks!
SSIS Oracle destination insert commit size.
Hi, Which property in Oracle destination gives the same result as OLEDB Maximum Insert commit size functionality. right now, Script component is concatenating multiple rows together instead of one row per batch. Simply I want script component output…
How is it possible to set the minimum amount of CPU for a database inside a pool in Azure?
Good afternoon, For some time now, we have been experiencing issues regarding resources in a database pool. as a first solution we decided to increase the amount of vCore to improve processing, for a few days everything went well, but today a strange…
Can SSRS 2019 consume data from databases on SQL server 2022?
Is is possible for SSRS 2019 to consume data from databases created with SQL server 2022?
SQL Server Data Quality Client Application keep raising exception
Hello While creating matching policy with Data Quality Services Client application I have encountered the following error message: As the log says it's related to type serialization issue Microsoft.Ssdqs.Infra.Utilities.BlockedTypeException:…
How to uninstall sql and its packages?
I tried to use SQL Server Integration Services, but it wasn't working at all, I was running on administrator and I checked it was installed. So I tried to uninstall everything to reinstall and it keeps saying "setup failed". It starts to…
Load CSV file with slightly different schemas during each run
I have a CSV file with Column headers as the first line but often sometimes the column position will vary but will be available in a different place. Please help me to advise how to load this dynamic schema change in CSV file to SQL server tables.…
using lag/lead with SQL Server
Struggling with a query using LAG: My goal is to get ONE record per customer and show the CURRENT value of a field and the PREVIOS value of a field all in the same record. I guess I'm going about it all wrong. My current query and a snippet of results is…
Microsoft.ace.oledb.12.0 provider is not registered for VS 2022 and run64bitRuntime disabled
I recently upgraded my sql server from 2019 to 2022. And also start to use Visual studio 2022. Because there is some excel destination or source file in the SSIS package, I got some errors like Microsoft.ace.oledb.12.0 provider is not registered. I see…
After upgrade to SQL Server, what does "Register your servers" mean?
In the "Next Steps" part of below link: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup?view=sql-server-ver16 "After you upgrade to SQL Server, complete the…
I would like some advice on how to use a query to get the total size of each disk drive.
When I try to get the total size of each disk drive using sp_OAGetProperty in mssql, I cannot get a value greater than 17,592,186,040,320 for large drives. I would like to ask for advice on a solution that can be checked using a query. And I don't want…
Can't install SQL Server 2022 Express on new laptop - "wait on the database engine recovery handle failed"
Hello, I tried to install SQL Server 2022 Express on my new laptop. All prerequisites are fulfilled. At the end of the installation I get this error: error message.jpeg The log file of the installation is here: SSEI-Expr_20240315163124.txt Any…
SQL on Virtual Machine with Self-Install SQL server in Azure
We have deployed a Windows Server 2016 virtual machine in Azure. We now need to install SQL Server Standard edition on it. During the installation process, we are prompted to enter a key to proceed. We want to convey that we will be using a PAYG SQL…
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:…
How to fix provider: SSL Provider, error: 0 - One or more of the parameters passed to the function was invalid.
We have updated TLS 1.1 to 1.2 on application server where ASP.NET web application is hosted on IIS. The application is built with .Net framework 4.7.2. But after installing cipher on the application server, application unable to connect the SQL database…