20,001 questions with SQL Server-related tags

Sort by: Updated
0 answers

Need support for SSRS

I developed a report and tested it on Visual Studio SSRS and deployed, I checked data source connection to be working but report still throwing error. see error message below:

Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
59 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,460 questions
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,992 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,685 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
668 questions
Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
59 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,460 questions
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,992 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,685 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
668 questions
asked Feb 12, 2025, 2:33 PM
IBRAHIM A. IBRAHIM 0 Reputation points
0 answers

Need support for SSRS

I developed a report and tested it on Visual Studio SSRS and deployed, I checked data source connection to be working but report still throwing error. see error message below:

Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
59 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,460 questions
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,992 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,685 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
668 questions
Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
59 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,460 questions
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,992 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,685 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
668 questions
asked Feb 12, 2025, 2:33 PM
IBRAHIM A. IBRAHIM 0 Reputation points
1 answer One of the answers was accepted by the question author.

Do I need to do something if I get the "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025" email?

Hi Getting the "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025" email asking me to upgrade the API-s. We are hosting for our customer a shared "SQL Server" in our Azure with 4 databases. When I am running the…

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.
14,460 questions
asked Feb 12, 2025, 12:39 PM
Botond Kupan 0 Reputation points
accepted Feb 12, 2025, 12:48 PM
Botond Kupan 0 Reputation points
0 answers

When I am running a long running query or stored procedure on Azure Sql databse, I am getting "A transport-level error has occurred when receiving results from the server" error. I have tried same query from portal as well but

When I am running a long running query or stored procedure on Sql databse, I am getting Msg 64, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified…

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.
14,460 questions
asked Feb 8, 2025, 12:03 PM
Pankaj Sharma 0 Reputation points
commented Feb 12, 2025, 12:03 PM
Vijayalaxmi Kattimani 1,330 Reputation points Microsoft Vendor
1 answer

The [VS2017PATH] points to the SSMS 21 Preview directory instead of the Visual Studio 2022 directory. How can I modify it to correctly reference the VS2022 directory when searching for the SSDT folder in the wxs file using DirectorySearch?

Issue with SSDT Folder Search Path in SSMS 21 Preview I’m encountering an issue with the search path for the SQL Server Data Tools (SSDT) folder when using SQL Server Management Studio (SSMS) 21 Preview. Below is the wxs code I’m using for the search…

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,460 questions
asked Feb 11, 2025, 6:48 PM
Chirag Gaonkar 0 Reputation points
commented Feb 12, 2025, 11:18 AM
Matteo Taveggia 21 Reputation points Microsoft Employee
1 answer

Error when connecting to Sql Server using Microsoft Sql Server Management Studio

Hi, Team I got an error when connecting to Sql Server using Microsoft Sql Server Management Studio. There was no problem before. Can you help me find out the reason? The following is the detailed error information TITLE: Connect to Server Cannot…

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.
14,460 questions
asked Feb 7, 2025, 7:56 AM
Allen F MAO 0 Reputation points
edited a comment Feb 12, 2025, 10:05 AM
Mahesh Kurva 2,670 Reputation points Microsoft Vendor
0 answers

Region-specific drives for a VM located in Azure AU region

Hi Team, We have a requirement from clients to have the data in the respective data drives, for example - client from US wants to have their data in a drive which is physically located in the azure data centre in US region. We are looking at partitioning…

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,356 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,336 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,068 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,460 questions
asked Feb 6, 2025, 11:25 PM
Berchmans Marcelline 5 Reputation points
commented Feb 12, 2025, 8:24 AM
Keshavulu Dasari 3,270 Reputation points Microsoft Vendor
0 answers

Re-Ouvrir directement un fichier sql server query

Bonjour , Depuis +/- 1 mois si je veux ouvrir un fichier sql server query contenant déja une requete sql , cela lance bien le logiciel "microsoft sql server 2014 management studio " , mais sur une query vide de code . Auparavant cela ouvrait…

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,460 questions
asked Feb 12, 2025, 7:44 AM
Boismal, Pascal 0 Reputation points
commented Feb 12, 2025, 8:00 AM
LiHongMSFT-4306 30,666 Reputation points
1 answer

Unable to install sql server(setup.exe) Exit code(decimal): -206805377Error description: invalid command line argument Consult the windows installer SDK for detailed command line help

I've been trying to find a solution for this but i can't at all. I tried deleting everything all files and programs and reinstalling. I even deleted the files from registry editor. I also cleaned my recycling bin but sill the issue presists. I changed…

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,460 questions
asked Feb 12, 2025, 7:18 AM
Alfalah, Mohammad 0 Reputation points
answered Feb 12, 2025, 7:39 AM
ZoeHui-MSFT 40,511 Reputation points
1 answer

Why I can't uninstall the sql server 2019?

Why when i try to delete the sql server 2019, i couldn't delete the shared features SQL Client Connectivity SDK. This is the error details showed:Action required: Use the following information to resolve the error, and then, try to uninstall this feature…

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,460 questions
asked Feb 12, 2025, 7:01 AM
tri minh 0 Reputation points
answered Feb 12, 2025, 7:33 AM
LiHongMSFT-4306 30,666 Reputation points
2 answers One of the answers was accepted by the question author.

SSIS Data from SQL Server into an Excel File Using SSIS

Good day, I have data like the below: CREATE TABLE [dbo].[test_data]( [Local_Site] [varchar] NULL, [LM_Company] [int] NULL, [TotalStaff] [int] NOT NULL, [NewOpp] [nvarchar] NULL, [ExistOpp] [nvarchar] NULL, [EasyTarget] [int] NOT NULL, [GoldTarget] [int]…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,642 questions
asked Jan 30, 2025, 10:30 AM
Rontech10111 161 Reputation points
accepted Feb 12, 2025, 6:52 AM
Rontech10111 161 Reputation points
2 answers

Which SQL Server Collation setting to use?

Hello, user is requesting a new empty DB to be created on our SQL Server 2019 instance and some of the requirements worth noting are... Encoding: UTF8 Case Insensitive Was mentioned it should be similar to one of our existing old SQL Server DBs 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.
14,460 questions
asked Feb 11, 2025, 11:37 PM
techresearch7777777 1,921 Reputation points
answered Feb 12, 2025, 6:45 AM
Olaf Helper 45,881 Reputation points
2 answers

Can I execute a report from Report Builder in my VS2022 VB.net WinForms application

I have been able to display a report on an asp webpage from my vs2022 vb.net webforms application but I can not display a report that has more than 1 table/dataset. Is this possible?

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,101 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,460 questions
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,992 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,779 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,101 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,460 questions
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,992 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,779 questions
asked Feb 11, 2025, 11:38 PM
BJ Harper 0 Reputation points
edited an answer Feb 12, 2025, 6:45 AM
Jiachen Li-MSFT 33,451 Reputation points Microsoft Vendor
2 answers

Can I execute a report from Report Builder in my VS2022 VB.net WinForms application

I have been able to display a report on an asp webpage from my vs2022 vb.net webforms application but I can not display a report that has more than 1 table/dataset. Is this possible?

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,101 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,460 questions
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,992 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,779 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,101 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,460 questions
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,992 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,779 questions
asked Feb 11, 2025, 11:38 PM
BJ Harper 0 Reputation points
edited an answer Feb 12, 2025, 6:45 AM
Jiachen Li-MSFT 33,451 Reputation points Microsoft Vendor
3 answers

Store proc body with select and update

We have store proc in azure sql db which is having select and update statement, with select we don't have any issue but while updating if we are updating less then 14 rows then it's working fine but if we have more then 14 rows then it is not…

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,460 questions
asked Feb 11, 2025, 3:36 PM
Nikhil Somani 0 Reputation points
answered Feb 12, 2025, 6:27 AM
Olaf Helper 45,881 Reputation points
2 answers

Database Mail SQL Server

Hello, Anyone know why if we send mail from SQL Database mail i always git this error. "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2025-02-10T18:57:12). Exception Message: Cannot…

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,460 questions
asked Feb 10, 2025, 12:04 PM
Handian Sudianto 5,706 Reputation points
commented Feb 12, 2025, 6:16 AM
ZoeHui-MSFT 40,511 Reputation points
2 answers

SQL Server 2022 Express installation issues.

I have been trying to install SQL Server Express all morning. I run the installer as admin and make sure everything from previous attempts has been removed. Attached are my detail and summary files from my most recent failed…

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,460 questions
asked Feb 11, 2025, 9:48 PM
Ethan 0 Reputation points
answered Feb 12, 2025, 5:46 AM
ZoeHui-MSFT 40,511 Reputation points
2 answers

SSRS 2022 Embedded images not appearing when taskbar = False

Reports with embedded images work perfect when taskbar = true. However, the resources can not be found when = false. I've spent over 2 hours with ChatGpt troubleshooting logs and configuration settings. My wildcard cert is working perfectly. Both portal…

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,992 questions
asked Feb 11, 2025, 2:20 PM
Chris Polito 0 Reputation points
answered Feb 12, 2025, 1:52 AM
ZoeHui-MSFT 40,511 Reputation points
1 answer One of the answers was accepted by the question author.

Why MSDN deprecates the AddWithValue method

I am trying to connect to a SQL Server table and update or register data in a program created in C#. In order to create a program that can take measures against SQL injection and support N prefixes, I am thinking of using the AddWithValue method, a…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,425 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,460 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.
11,289 questions
asked Feb 7, 2025, 8:02 AM
那由多 0 Reputation points
accepted Feb 12, 2025, 1:51 AM
那由多 0 Reputation points
1 answer

I can't install sql server 2022 developer deition

Screenshot 2025-02-11 175236.png Summary_S3R6E-PC_20250211_181332.txt this is what i'm having trouble with. i can't install it on my pc.

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,460 questions
asked Feb 11, 2025, 11:35 PM
Sergei Umbac 0 Reputation points
answered Feb 12, 2025, 1:38 AM
LiHongMSFT-4306 30,666 Reputation points