SQL Server

Microsoft SQL Server 2022 - no TCP/IP connection in client protocols in SQLServer Configuration Manager

Hello, since SQL Server 2022 Standard edition I miss in "SQL Server Configuration Manager" under "client protocols" all protocols e.g. "TCP/IP", to enable client connection to the Database. Also I can not create manually a…

Symmetric key alter issue in SQL Server 2025

Context: I am using SQL Server 2025 with symmetric keys protected by a certificate, and I encrypt/decrypt data using the EncryptByKey and DecryptByKey functions. I now need to migrate the symmetric key protection to Azure Key Vault. However, while…

MSSQL prefer way to transfer big file from server to client.

Hello I have a cpp client which connects to MSSQL server 2025 using ODBC or Native client. I need to transfer large number of files (can vary from 100 MB to 1GB there can be many files from 1 to 100) what is best way to transfer such large amount of data…

Questions regarding the details of differential backup

According to the online documentation, differential backup determines whether a sector has changed. I have the following two questions: Is it possible that within a single sector, 1 page belongs to SQL Server and 7 pages belong to other application files…

Unable install MSSQL ODBC Driver on the PPC64le

Dear Microsoft support, is there in near future planned to develop MSSQL ODBC driver for PPC64le architecture? From accessible documentation is not available/supported from your side at this moment. Thank you for response. Br, Erik

Migration feature on SSMS 22

Hi Expert, I'm running first time Migrate SQL Server feature on SSMS 22 for Database Assessment with 10TB size, this report as below: "Status": "Error", "**AssessmentRecommendations": [],** "Name":…

getting below error while installing microsoft sql server 2025

Setup issue to SQL Server Management studio installer 22

Hi, When doing the setup of SQL Server Management studio installer 22 on Windows server 2025, I got "internet connection, and not able to do the download". How to find out the issues on the server for this?

Binding error when refreshing schema and data in Power BI model

Getting the below binding error when refreshing the schema and data for this particular query in Power BI model. The view and query run without any errors in SSMS

SSRS 2016 Matrix Dynamic Column Group Overflow Bug when LayoutDirection is RTL

Hi SSRS Product Team, We are experiencing a critical rendering bug/limitation in SQL Server Reporting Services (SSRS 2016 / Report Builder version 15.0.200) related to Right-to-Left (RTL) dynamic matrix expansion. Description of the Issue: When designing…

I cannot connect to storage account when setting up SQL Server backup?

I followed the following steps: Right-click your new SQLTestDB database, hover over Tasks and then select Back up... to launch the Back Up Database wizard. Select URL from the Back up to destination drop-down, and then select Add to launch the Select…

Kerberos fails on AG Listener — only from cluster nodes, ticket not generated

Environment: SQL Server Always On AG on top of FCI, Windows Server cluster, domain-joined nodes. Problem: Connections to the AG listener always fall back to NTLM, but only when connecting from the cluster nodes themselves. From any other machine on the…

Deployed SSIS package has access denied to file directories and work fine in VS

I’ve tested a couple of things out with different packages that have been deployed to SQL Server. I noticed that within the same package, I can have a script task which fails to connect to a file directory but I don’t have an issue with connecting a flat…

SSIS package row delimiter Failure

Hi, I have a package that reads a file from a network location and inserts the data into a database. The data flow task includes four components: Flat File Source Derived Column to convert DT_NText to DT_WTSR Derived Column to convert DT_WTSR to…

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…

Confirmation on Maintenance Plan DLL Usage for SQL Server 2025

Hello Team, Earlier, till SQL Server 2022 (version up to 16) we were compiling our Maintenance Plan source code project by referencing the required DLLs from the GAC. However, for SQL Server 2025 (version 17), based on our analysis of the…

Why is SQL AO-AG slower to failover than SQL Mirroring

Encountered problem: Our use-case has 3 x Server 2022 in a topology of a domain controller with two node cluster. This is a SQL Always On AG architecture. The cluster hosts the SQL availability group roles. This is a replacement for the MS deprecated SQL…

Windows for business | Windows Server | Storage high availability | Clustering and high availability

Windows for business | Windows Server | Storage high availability | Clustering and high availability

1,171 questions

Sign in to follow

SQL Server | Other

SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,744 questions

Sign in to follow

set date range to all records on dates parameters

I want to set my date range in parameters to all dates. how can I do that in parameters settings

Cannot add users or groups in report server portal

The problem is that I cannot set the users or groups after adding the custom security.

Performance Degradation after moving from SQL 2019 to SQL 2025

I am in the processing of upgrading our SQL environment from 2019 to 2025. We are troubleshooting perf issues in our pre prod env right now before upgrading production and I have a fairly simple query that loads 1.6m rows to a temp table and typically…