17,558 questions with SQL Server-related tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2023-10-13T04:52:54.18+00:00
Dhanesh Kumar 40 Reputation points
commented 2024-03-19T04:37:59.9333333+00:00
Meenakshi - 0 Reputation points
0 answers

Can I download SQL Express on Mac computer?

Hello, Can I download SQL Server on my Mac? Thanks!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2024-03-19T03:56:51.2233333+00:00
TG-9754 0 Reputation points
0 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
asked 2024-03-12T05:50:24.12+00:00
Zaim Raza 0 Reputation points
commented 2024-03-19T03:46:28.4333333+00:00
Zaim Raza 0 Reputation points
1 answer One of the answers was accepted by the question author.

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.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,266 questions
asked 2024-03-16T15:57:23.7833333+00:00
Sivakumar Rajabather 20 Reputation points
commented 2024-03-19T03:40:50.2333333+00:00
Sivakumar Rajabather 20 Reputation points
2 answers

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…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2023-07-20T17:15:05.3566667+00:00
Bruno Silva 5 Reputation points
commented 2024-03-19T03:34:14.98+00:00
I N 0 Reputation points
1 answer

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,756 questions
asked 2024-03-18T14:18:43.8+00:00
Rob Attrill 0 Reputation points
answered 2024-03-19T03:17:57.79+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

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:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2024-03-18T09:12:38.65+00:00
Marek Mądrawski 0 Reputation points
answered 2024-03-19T03:06:59.57+00:00
CosmogHong-MSFT 21,146 Reputation points Microsoft Vendor
2 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
asked 2024-03-17T12:57:34.0733333+00:00
Office 0 Reputation points
answered 2024-03-19T02:27:05.0866667+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

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.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2024-03-18T17:01:42.6+00:00
commented 2024-03-19T02:22:45.69+00:00
CosmogHong-MSFT 21,146 Reputation points Microsoft Vendor
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2024-03-18T20:40:07.4433333+00:00
Dom 706 Reputation points
answered 2024-03-19T02:20:30.7966667+00:00
CosmogHong-MSFT 21,146 Reputation points Microsoft Vendor
4 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
asked 2024-03-15T21:53:36.26+00:00
Anne 276 Reputation points
answered 2024-03-19T02:01:31.4533333+00:00
ZoeHui-MSFT 31,271 Reputation points
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2024-03-19T01:30:24.8+00:00
kuya 0 Reputation points
4 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,532 questions
asked 2024-03-15T06:49:13.85+00:00
준영 이 0 Reputation points
commented 2024-03-18T23:46:08.8066667+00:00
준영 이 0 Reputation points
1 answer

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 Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2024-03-18T19:04:17.33+00:00
Marco 0 Reputation points
answered 2024-03-18T23:15:14.6933333+00:00
Marco 0 Reputation points
3 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,863 questions
Windows Server Licensing
Windows Server Licensing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
13 questions
asked 2024-03-12T05:17:36.9566667+00:00
sid 101 Reputation points
edited an answer 2024-03-18T23:01:29.8566667+00:00
Greg Low 1,150 Reputation points Microsoft Regional Director
0 answers

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…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,756 questions
asked 2024-03-18T22:49:05.2+00:00
Charan Reddy 0 Reputation points
3 answers

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:…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,756 questions
asked 2022-12-20T17:10:54.27+00:00
Venkateswarlu Y 6 Reputation points
answered 2024-03-18T22:09:27.1+00:00
Sunny Kr Gupta 0 Reputation points
1 answer

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…

Internet Information Services
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,202 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.
12,401 questions
asked 2023-02-03T15:13:20.1966667+00:00
Milind Panchal 0 Reputation points
commented 2024-03-18T19:38:26.2166667+00:00
Dawid Kiersnowski 0 Reputation points
4 answers

SQL Server Management Studio 19.1 autocomplete / intellisense not working

This is supposed to result in an autocomplete, like usual, after the cu_. Suggestions do not turn on. I am on a VPN via LogMeIn Hamachi. The connection is tunneled. I can still execute queries just fine. Autocomplete works at first, when I type…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
asked 2023-09-28T17:10:28.3066667+00:00
Zak Dwyer 0 Reputation points
answered 2024-03-18T19:31:43.61+00:00
Nicolas Baly 0 Reputation points
2 answers

Not able to connect to Azure SQL MI from webApp. I tried 1) Public endpoint 2) VNet integration too.

Not able to connect to Azure SQL MI from webApp. I tried 1) Public endpoint 2) VNet integration too. Followed the following steps for VNet integration: https://learn.microsoft.com/en-us/azure/app-service/overview-vnet-integration

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,401 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,629 questions
asked 2024-03-12T12:58:38.34+00:00
Siba 0 Reputation points
edited the question 2024-03-18T17:31:16.61+00:00
KapilAnanth-MSFT 33,071 Reputation points Microsoft Employee