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
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
SQL Server Name
Hey, I cannot locate my SQL Server Name
SQL Server Open Specifications
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
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
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
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
SQL Server
Microsoft Entra ID
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
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
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
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


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

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
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
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
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
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
SQL Server


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
SQL Server
Azure Kubernetes Service (AKS)
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
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
