20,536 questions with SQL Server-related tags

Sort by: Updated
0 answers

In Visual Studio 2022, SSDT, SQL Project External Tables - Build Error!

Title: External Table Build Error in SSDT – SQL46010 near ')' but works in SSMS Hi, I’m working with Visual Studio 2022, SSDT, and SQL Server Projects, and I’m trying to create external tables in an Azure SQL Database. The external table creation works…

SQL Server Database Engine
asked 2025-06-18T17:25:26.11+00:00
Seven Hills 0 Reputation points
3 answers

How to install SQL Server Developer on a Snapdragon Laptop

I got a new Dell laptop that has a Snapdragon processor and am unable to install SQL Server. Is there a procedure for doing this? If the solution is emulation, then is there a procedure for setting up emulation too? Thanks

SQL Server Database Engine
asked 2025-06-17T21:19:04.1466667+00:00
Robert Watson 0 Reputation points
answered 2025-06-18T17:23:12.41+00:00
Bruce (SqlWork.com) 77,631 Reputation points Volunteer Moderator
0 answers

SQL Server Name

Hey, I cannot locate my SQL Server Name

SQL Server Open Specifications
SQL Server Open Specifications
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
3 questions
asked 2025-06-18T16:50:02.1933333+00:00
Bryant, Kiana (NBT) 0 Reputation points
1 answer

After pbirs integrates custom security extensions, how do I implement custom identity passing to SSAS?

I've implemented custom authentication as per the open source project "CustomSecuritySample". Now I can't get the RLS feature of SSAS. I used powerbi desktop rs to connect to SSAS in real-time and developed a report. I upload a report to a…

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.
3,056 questions
asked 2025-06-16T07:57:08.0866667+00:00
avensteven 0 Reputation points
answered 2025-06-18T15:33:29.6733333+00:00
YANG Rob 0 Reputation points
2 answers

Where can I find a download of SQL Report Builder 2016 / 14.X

Where can I find a download of SQL Report Builder 2016 / 14.X? Currently we are running SQL Server 2016 in our environment and it is recommended in documentation to use the same version of report builder that is installed on the SQL server. Does…

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.
3,056 questions
asked 2021-04-08T21:43:51.97+00:00
Specialk196 1 Reputation point
commented 2025-06-18T15:19:28.1966667+00:00
Carolyn Campbell 0 Reputation points
1 answer

How to download and install a specific version of report builder?

keep trying to open the report builder from the NAV development environment but I keep getting an error stating that the supported version could not be found. Note that I have the latest version of the report builder (Version 15.0.20073.0).

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.
3,056 questions
asked 2023-09-11T10:38:43.9066667+00:00
Erick Thamara 0 Reputation points
commented 2025-06-18T15:07:20.49+00:00
Carolyn Campbell 0 Reputation points
3 answers

Unable to acquire authorization token (ConnectionDlg.AadInteractiveAuthProvider) with "Azure Active Directoy - Universal with MFA" to Azure SQL server when SSMS is run as my privileged account

This works fine from another system, or if I log on to the laptop directly with my privileged account. I need to run SSMS as my privileged account, because that's the only account that has been authorized to connect to our Azure SQL servers &…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
9,139 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.
14,492 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
25,009 questions
asked 2024-10-07T14:33:49.44+00:00
Dom-Su BoChum 20 Reputation points
commented 2025-06-18T12:08:01.2166667+00:00
Jacob Horwath 0 Reputation points
3 answers

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI

I’m encountering an SSL certificate chain issue when trying to connect to my SQL Server from a Power BI server. The server connects, but when I click refresh, this error appears. Below are the details: Error Message: Microsoft SQL: A connection 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.
14,492 questions
asked 2025-02-13T08:46:38.4433333+00:00
Suchith D 5 Reputation points
answered 2025-06-18T11:37:05.9866667+00:00
Rafi Shazad 0 Reputation points
0 answers

SSRS-generated Word .doc files don't render correctly in MS Word 2505

SSRS 2022 version 16.0.9276.19198 generates Word 97-2003 .doc files which can be opened fine in MS Word 2504. Word 2505 doesn't display the same .doc files correctly. Is there a version of SSRS that generates Word .docx version 2007…

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.
3,056 questions
asked 2025-06-12T20:58:49.1+00:00
Zoltan Takacs 0 Reputation points
commented 2025-06-18T11:25:20.6533333+00:00
Miroslav Djorov 0 Reputation points
0 answers

How to delete SQL server in Registry or Cache

So, for almost 2 days I am breaking my head why these entries are not been deleted despite I did it multiple times. Could someone help me out and fix this real quick? PS C:\WINDOWS\system32> Get-WmiObject -Class Win32_Product | Where-Object {…

SQL Server Database Engine
asked 2025-06-17T19:35:14.24+00:00
Nithish Kumar 0 Reputation points
commented 2025-06-18T06:24:45.1733333+00:00
Nithish Kumar 0 Reputation points
0 answers

Reporting Service 2022 Show Folder Name in Report Manager's Search Results

Hi Guys, We are using folders to manage report access permissions. For advanced users, the same report may appear as linked reports in multiple folders, depending on their access rights. We have recently upgraded from Reporting Services 2008 R2 to…

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.
3,056 questions
asked 2025-06-18T04:07:35.2233333+00:00
Wilson Shen 0 Reputation points
edited the question 2025-06-18T05:45:45.7333333+00:00
Wilson Shen 0 Reputation points
0 answers

Cannot create a task from XML for task "Script Task" | XML task | SSIS | Version

Microsoft (R) SQL Server Execute Package Utility Version 16.0.1000.6 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 11:33:22 AM Error: 2025-06-17 11:33:23.68 Code: 0xC001F02A Source: 0_Test Description: Cannot create a…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
asked 2025-06-17T21:46:52.69+00:00
Sravan Kopparapu 0 Reputation points
commented 2025-06-18T05:40:05.9833333+00:00
Olaf Helper 47,416 Reputation points
1 answer One of the answers was accepted by the question author.

How I can change a file name with code in SSIS

I'm trying to change a file name to current year and Previous month with below script but it is still coming as current year and current month. I tried around to fix it but no luck. If anyone can show my mistake please "D:\Sales" +…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
asked 2025-06-16T20:32:08.67+00:00
Van Alstyne 0 Reputation points
accepted 2025-06-17T19:29:43.9833333+00:00
Van Alstyne 0 Reputation points
0 answers

VS2022 SSIS cannot load ODBC data column

Hi I'm trying to use VS 2022 Community SSIS to connect some ODBC data sources like SAP Hana or SQL Server 2022. I can see the table and data in Preview page, but cannot see any data columns in the "data column setting", any ideas about…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
asked 2025-06-17T02:46:40.8633333+00:00
Angi Wang 0 Reputation points
commented 2025-06-17T12:15:39.94+00:00
Yitzhak Khabinsky 26,576 Reputation points
0 answers

Error trying to use latest SQL Server Migration Assistant for Access

I have the latest SSMA for Access installed but can't get past a "New Workspace Error" either via the start wizard or trying to open a solution I created about 9 months ago. The error states "The type initializer for…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
asked 2025-06-17T11:07:16.47+00:00
Kevin Seerup 0 Reputation points
1 answer

How to fix this Error 0X80070643

I cant install Security update for SQL server 2019 RTM GDR (KB5046859) and i tried to install it from microsoft website but when install also give me error installing SQL Server Database Engine Services Instance Features

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
asked 2024-11-15T04:25:18.4133333+00:00
Moataz Hassan 0 Reputation points
answered 2025-06-17T08:59:47.3333333+00:00
Timur Sh 0 Reputation points
2 answers

Please Help me - How can I fix the 'Culture is not Supported' error when importing an Excel file to a database in SQL Server Management Studio

I have tried countless times to import an Excel file via the SSMS application interface and keep getting the below error. Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[CovidDeaths$] ( iso_code] NV . "…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 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.
14,492 questions
asked 2023-07-14T09:26:27.05+00:00
Nnamani Chisom Promise 40 Reputation points
commented 2025-06-17T06:26:13.57+00:00
Ammar Shaukat 1 Reputation point
2 answers

How to Fix:Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate].

I followed the documentation: https://learn.microsoft.com/en-us/sql/linux/quickstart-sql-server-containers-azure?view=sql-server-ver16&tabs=kubectl to deploy SQL server on AKS. But While connecting to it, getting the below error: Sqlcmd: Error:…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,374 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.
14,492 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
2,436 questions
asked 2023-06-27T20:19:16.9633333+00:00
Satyam 25 Reputation points
answered 2025-06-17T02:24:08.6+00:00
Angi Wang 0 Reputation points
1 answer

Javascript in URL does not create a link in SSRS 2022

In SSRS 2022, using the below Javascript will not generate a link once deployed. This feature works fine in SSRS 2016 and before. Browser version does not…

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.
3,056 questions
asked 2025-06-11T18:58:06.9833333+00:00
Patrick Dill 0 Reputation points
edited an answer 2025-06-16T23:50:02.73+00:00
Patrick Dill 0 Reputation points
1 answer

Enable Ledger on Azure SQL Server, will hang the Azure function execution which add around 65K records

I have an Azure function which read data from Excel sheets and update 3 SQL tables, and it clear 2 SQL tables before re-add the rows. On some scenarios, I will add the data as-is, while on another scenario I need to check if a column named ID exists, if…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
198 questions
asked 2025-06-15T23:41:33.0566667+00:00
john john Pter 1,040 Reputation points
answered 2025-06-16T21:34:34.4166667+00:00
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator