Microsoft Q&A

SQL Server

15,449 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

15,449 questions with SQL Server-related tags

Sort by: Updated
0 answers

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 Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,950 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.
9,087 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,774 questions
asked 2023-03-24T15:48:11.8233333+00:00
Ed 21 Reputation points
commented 2023-03-24T23:16:36.9+00:00
Ed 21 Reputation points
6 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,950 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.
9,087 questions
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 6 Reputation points
commented 2023-03-24T21:33:09.7333333+00:00
Ismail Habib 0 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-23T22:17:00.9866667+00:00
sd xzzx 0 Reputation points
edited an answer 2023-03-24T21:27:08.21+00:00
Erland Sommarskog 72,341 Reputation points MVP
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-24T21:00:58.6466667+00:00
DBA 21 Reputation points
1 answer

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…

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,235 questions
asked 2023-03-22T20:05:22.5066667+00:00
Jason Wilburn 0 Reputation points
commented 2023-03-24T20:10:44.03+00:00
Jason Wilburn 0 Reputation points
2 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
7,547 questions
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,398 questions
asked 2023-03-22T05:43:11.3733333+00:00
Kerry Ou 186 Reputation points
commented 2023-03-24T20:06:06.52+00:00
Karen Payne MVP 30,126 Reputation points
2 answers

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-24T07:08:03.1866667+00:00
Sajin Sathikumar 0 Reputation points
answered 2023-03-24T19:20:52.3733333+00:00
Rahul Randive 861 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

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.
9,087 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
1,967 questions
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,544 questions
asked 2023-03-24T13:31:22.6033333+00:00
Raghava Akula 231 Reputation points
edited a comment 2023-03-24T19:10:29.1833333+00:00
Raghava Akula 231 Reputation points
1 answer

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,950 questions
Azure SQL Database
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
4,073 questions
Azure Database for PostgreSQL
asked 2023-03-24T17:27:17.93+00:00
NEERAJ RAM 0 Reputation points
commented 2023-03-24T18:47:52.1766667+00:00
Oury Ba-MSFT 10,326 Reputation points Microsoft Employee
4 answers

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 Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-23T17:33:17.4933333+00:00
Ryan Tracey 0 Reputation points
answered 2023-03-24T17:52:26.1233333+00:00
Bruce (SqlWork.com) 31,326 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-23T21:51:15.7933333+00:00
Dominic Legendre 21 Reputation points
commented 2023-03-24T16:52:55.58+00:00
Viorel 88,566 Reputation points
2 answers

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2022-12-08T02:10:54.427+00:00
JOONHYEOK LEE 1 Reputation point
answered 2023-03-24T16:25:09.2233333+00:00
p chattopadhyay 0 Reputation points
2 answers One of the answers was accepted by the question author.

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-21T21:36:22.0266667+00:00
techresearch7777777 1,386 Reputation points
accepted 2023-03-24T15:28:20.2466667+00:00
techresearch7777777 1,386 Reputation points
7 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,824 questions
asked 2021-12-14T12:23:52.077+00:00
Amit Potdar 91 Reputation points
commented 2023-03-24T15:24:57.1466667+00:00
Blasco73 0 Reputation points
1 answer

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,950 questions
asked 2023-03-24T12:09:35.3466667+00:00
BlueFire291 0 Reputation points
edited an answer 2023-03-24T15:17:22.9066667+00:00
Yitzhak Khabinsky 20,636 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-22T19:52:03.1766667+00:00
James E. Gerberich 0 Reputation points
edited a comment 2023-03-24T14:48:59.3933333+00:00
James E. Gerberich 0 Reputation points
4 answers One of the answers was accepted by the question author.

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 Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-21T08:30:29.1933333+00:00
Melik Baykal 20 Reputation points
accepted 2023-03-24T13:52:03.8933333+00:00
Melik Baykal 20 Reputation points
2 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-21T17:07:47.53+00:00
Spunny 241 Reputation points
accepted 2023-03-24T13:37:49.63+00:00
Spunny 241 Reputation points
1 answer One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
asked 2023-03-23T22:59:05.5033333+00:00
Bassam Geagea 20 Reputation points
accepted 2023-03-24T13:32:21.4666667+00:00
Bassam Geagea 20 Reputation points
1 answer

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…

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,235 questions
asked 2023-03-20T15:38:10.28+00:00
JohnSebastian-3934 121 Reputation points
commented 2023-03-24T13:20:07.9033333+00:00
JohnSebastian-3934 121 Reputation points