18,401 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

Error on report after upgrading to build 16.0.1115.92

Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). In early May…

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,853 questions
asked 2024-06-04T18:20:06.8033333+00:00
Alex M 10 Reputation points
commented 2024-06-21T15:17:39.86+00:00
Alex M 10 Reputation points
0 answers

There was an error trying to establish an Oracle connection with the database server

TITLE: Microsoft Visual Studio There was an error trying to establish an Oracle connection with the database server. Getting this error while trying to establish connection to Oracle is SSIS ConnectionManager. Tried to connect using…

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.
506 questions
asked 2024-06-21T15:03:49.6566667+00:00
Jobin, Priscilla 0 Reputation points
9 answers

SQL SERVER 2022 - certificate error when creating a job for integration services

In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,493 questions
asked 2024-04-10T03:35:21.82+00:00
Marcio Matos 65 Reputation points
answered 2024-06-21T15:01:17.0333333+00:00
Brenda Woods 0 Reputation points
3 answers One of the answers was accepted by the question author.

Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)

After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.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.
2,853 questions
asked 2024-05-30T16:41:17.3866667+00:00
Kehoe, Tim 20 Reputation points
commented 2024-06-21T13:29:48.24+00:00
Kehoe, Tim 20 Reputation points
0 answers

How to give an AAD group view only access to a single database within SQL Server with multiple databases

I have a SQL Server in my subscription with multiple databases. Each database corresponds to a client organization. I wanted to give each client read only access to their individual database without them being able to see the other databases. For a…

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.
13,117 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,184 questions
asked 2024-06-19T01:44:05.8133333+00:00
Abdul Asim 0 Reputation points
commented 2024-06-21T13:07:59.6333333+00:00
ShaktiSingh-MSFT 14,196 Reputation points Microsoft Employee
1 answer

How to fix SMTP server requires a secure connection or the client was not authenticated.The server response was 5.7.0

Hi Everyone, Could you please provide solution for SMTP issue. One of my client asking how to fix SMTP issue when the SQLDBmail failing to send DB emails due to SMTP server issue. I have pasted error message below 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.
13,117 questions
asked 2024-06-20T17:36:51.46+00:00
Uday Paleti 20 Reputation points
commented 2024-06-21T12:15:10.66+00:00
Uday Paleti 20 Reputation points
2 answers One of the answers was accepted by the question author.

How to modify filepath of datafile that is inside a filegroup? Is it the same approach on alter database modify file directly the file that is inside a filegroup? Or need to do alter database modify filegroup modify file?

How to modify filepath of datafile that is inside a filegroup? Is it the same approach on alter database modify file directly the file that is inside a filegroup? Or need to do alter database modify filegroup modify file?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-19T19:17:17.9066667+00:00
Michelle Urbano 20 Reputation points
commented 2024-06-21T12:01:57.87+00:00
Michelle Urbano 20 Reputation points
1 answer

ServerCertificate DSN property mentioned in system_odbc.ini is not honored by Microsoft ODBC Driver 18 for SQL Server version 18.3 in linux

Hi all, I have installed SQL Server instance in Windows and enabled SSL connections. Now I have installed ODBC SQL Server Native Client on Rhel 9 VM and configured a DSN in system_odbc.ini…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-14T20:07:00.91+00:00
Srikanth G 0 Reputation points
commented 2024-06-21T09:57:37.2+00:00
MikeyQiaoMSFT-0444 1,255 Reputation points
1 answer

Execution Timeout Expired Error with UPS API Request in SQL Server 2019 Backend

Hello everyone, I'm encountering an issue with a web backend application that uses SQL Server 2019. We send a request to the UPS API, but it fails, and the application error log shows the following message: LOGGER Error: 0 : 6/14/2024 2:45:38 PM :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-21T07:34:58+00:00
Vinith 25 Reputation points
answered 2024-06-21T07:43:19.1066667+00:00
Olaf Helper 42,571 Reputation points
1 answer

MS SQL express compare to MS SQL Server Enterprise

Hello, where to find compare of the fuctionalities for MS SQL Express 2019 vs Express 2022 vs Express 2024 vs MS SQL Server Enterprise 15.0.4360.2? Thank you 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.
13,117 questions
asked 2024-06-21T07:28:51.2166667+00:00
Salka, Milan 21 Reputation points
answered 2024-06-21T07:38:22.73+00:00
Olaf Helper 42,571 Reputation points
2 answers One of the answers was accepted by the question author.

Intermittent SQL Server Connectivity Issues: How to Diagnose and Resolve?

I'm experiencing intermittent connectivity issues with our SQL Server, and I'm looking for advice on how to diagnose and resolve them. Here are the details: Error Messages: [HYT00][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-08T19:29:32.7133333+00:00
Vinith 25 Reputation points
accepted 2024-06-21T07:20:45.08+00:00
Vinith 25 Reputation points
1 answer

I cant unistall the MS SQL server 2022 setup

when i tried to uninstall it, its show me this and i cant those products.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-20T05:36:17.01+00:00
Nameless 0 Reputation points
commented 2024-06-21T06:53:20.24+00:00
MikeyQiaoMSFT-0444 1,255 Reputation points
2 answers

how does database scoped credential work

I understand how to create and why, but how does then underlying process work? how does the second server know about the credentials created on the first server when using polybase. Our security team want an explanation as we wish to connect an on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-19T13:08:07.25+00:00
Colin Ferguson 106 Reputation points
commented 2024-06-21T06:52:45.88+00:00
MikeyQiaoMSFT-0444 1,255 Reputation points
1 answer

how to find the cpu memory disk and network of the OS where RDS is residing

hi, i have one RDS, but i do not have any other permissions, and i need to know the cpu , memeory disk and network staus of the OS where RDS is residing. if i had sqlserver on my machine it was so easy for me to press alt ctrl del to find the status of…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-17T06:24:31.67+00:00
Rajesh Kumar Yadav 0 Reputation points
commented 2024-06-21T06:51:36.8966667+00:00
MikeyQiaoMSFT-0444 1,255 Reputation points
2 answers

How to fix slower performance with Microsoft.Data.SqlClient.TdsParserStateObject ReadSniSyncOverAsync method?

How to fix slower performance with Microsoft.Data.SqlClient.TdsParserStateObject ReadSniSyncOverAsync method when it has multiple calls (21) in a transaction with average execution time of 6116 ms per call and totalling to 128436 ms?

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,544 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.
13,117 questions
asked 2024-06-13T09:10:47.4366667+00:00
ShahSamir-9495 0 Reputation points
commented 2024-06-21T06:51:13.3233333+00:00
MikeyQiaoMSFT-0444 1,255 Reputation points
0 answers

How to move notepad file and PowerShell files as SQL server table same as note file and PowerShell without columns and rows.

How to move notepad file and PowerShell files as SQL server table same as note file and PowerShell without columns and rows.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-21T06:07:50.1+00:00
nn 0 Reputation points
commented 2024-06-21T06:26:23.5266667+00:00
Olaf Helper 42,571 Reputation points
1 answer

SQL Agent job step outcome mentions "This security ID may not be assigned as the owner of this object."

Hello, I created a SQL 2016 Agent job which copies & replaces .bak files from Source Files Location to a Network Disk Share Target Files Location that are 1 day old as follows: robocopy G:\Source_Files_Location…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-17T18:41:45.6+00:00
techresearch7777777 1,801 Reputation points
commented 2024-06-21T06:16:51.1233333+00:00
MikeyQiaoMSFT-0444 1,255 Reputation points
2 answers

Licensing for read a database master in sql server always on

Good morning, I'm wondering about the licenses to have on the nodes of an Always On cluster. We have the main node and two passive secondary nodes. In order to monitor the good state of a cluster I made a procedure stored in the master database which…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-19T08:24:33.7166667+00:00
Cédric 0 Reputation points
commented 2024-06-21T05:55:44.8066667+00:00
LucyChen-MSFT 2,560 Reputation points Microsoft Vendor
2 answers

How to update the activation of SQL Server?

Dear All, We have an open value agreement and recently we have added an extra SQL license to the agreement. First, we purchased a license for 4 cores then we added 4 cores. Now, how can we use these new extra SQL Server licenses on the existing 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.
13,117 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
49 questions
asked 2024-06-19T14:05:36.9733333+00:00
Haitham Al-Haj 0 Reputation points
commented 2024-06-21T05:55:01.65+00:00
LucyChen-MSFT 2,560 Reputation points Microsoft Vendor
2 answers

where do I download a copy of sql server MDM for testing

I AM TRYING TO SHOW A CLIENT WHAT MDM FOR SQL SERVER CAN DO.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
asked 2024-06-19T20:25:44.4133333+00:00
Jim Manousos 0 Reputation points
edited a comment 2024-06-21T05:54:29.13+00:00
LucyChen-MSFT 2,560 Reputation points Microsoft Vendor