Microsoft Q&A

SQL Server

14,828 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

Browse all SQL Server tags

14,370 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Select row based on 2 column values

Please I have this table that looks like the below(schema script in the post) The table when selected will look like the below I need to get the value in A(XCHGRATE) where my desired date falls between B(EXCHDATE) and C(EXPNDATE) In this case my date…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T14:05:03.7433333+00:00
Michael M.M. D'Angelo 96 Reputation points
answered 2023-02-08T15:22:23.5033333+00:00
Jingyang Li 4,521 Reputation points
1 answer

Can't login SSRS web portal with AADDS account on other VM in same VNet

I have two VMs on Azure in same VNet, VM1 is running SQL 2016 with SSRS. I can connect SQL services fine with domain account from the VM2 but SSRS web portal is not logging in with domain account. Local SQL server account logs in to SSRS web portal on…

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,132 questions
Azure Active Directory Domain Services
asked 2023-02-08T00:06:03.19+00:00
Umair 0 Reputation points
commented 2023-02-08T15:14:18.93+00:00
Umair 0 Reputation points
2 answers

Cannot get Project Values to display in Report Writer

I am relatively new to Report Builder and am encountering an issue getting data to populate in a test report I am making. Here is an example of what is created when I click to Run. Here is a small sample of the data being uploaded: Input Project Cost…

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,132 questions
asked 2023-02-07T16:54:01.9133333+00:00
Dockter, Chloe 0 Reputation points
commented 2023-02-08T14:30:35.9033333+00:00
Dockter, Chloe 0 Reputation points
2 answers

What should I consider after changing SQL logon account to sMSA for each service. In terms of permissions to other drives and servers.

I want to migrate SQL logon accounts from virtual accounts to stand alone Managed Service Accounts. When I tested, some backup jobs started failing due to insufficient permissions in the backup location. Where do I give permissions to sMSAs to access…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
3,665 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
8,266 questions
asked 2023-02-06T14:27:12.4633333+00:00
Eudias Kifem 20 Reputation points
edited a comment 2023-02-08T14:27:49.4133333+00:00
Eudias Kifem 20 Reputation points
1 answer

Sql select most repeated value

Hi, I have a database called a “reader”, and a table called "dailyreader". The dailyreader has 6 columns and i am looking to create a query to select the most repeated values in all columns and show how many times has been repeated. 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.
8,594 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
646 questions
asked 2023-02-08T13:31:04.7266667+00:00
M Simo 0 Reputation points
commented 2023-02-08T14:23:54.8833333+00:00
Yitzhak Khabinsky 20,021 Reputation points
1 answer

Is an availability group listener a proxy?

Is a SQL Server availability group listener an application-layer proxy? In other words, which of the following methods does a SQL Server availability group listener use to get traffic to SQL Server instance?: Method A(non-proxy): SQL Server client…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T04:43:54.2866667+00:00
Michael Ross 0 Reputation points
commented 2023-02-08T14:11:01.3466667+00:00
Michael Ross 0 Reputation points
1 answer

how to fix reportviewer rendering exception when EnablePartialRendering on ScriptManager is set to true

WARNING! There was an error parsing the document In our MVC application we are calling an ASPx page (using an iframe) that contains a reportviewer control, the reports are loading but when I click "Show report" button after I give the…

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,132 questions
ASP.NET Web Forms
ASP.NET Web Forms
A part of the ASP.NET web application framework that can be used to create ASP.NET web applications.
412 questions
asked 2023-02-06T09:48:38.77+00:00
Gimi 0 Reputation points
commented 2023-02-08T13:41:07.4566667+00:00
Gimi 0 Reputation points
2 answers

How to cleanup Python directories Launchpad service

I have installed the Python 3.7 machine learning feature in SQL Server but the memory growth is huge after executing several Python scripts. When you execute a SQL job with a python statement the launchpad creates folders in the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T15:50:18.53+00:00
Eric Bezemer 181 Reputation points
commented 2023-02-08T11:35:50.8566667+00:00
Eric Bezemer 181 Reputation points
3 answers

Access primary database instance from read replica instance

Since we are starting to use read replica in our projects, we are going to migrate the our data retrieval procedures to read only database. But, we are doing the performance track inside that procedures that we are moving to read only DB and it is…

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.
8,594 questions
asked 2023-01-27T12:04:45.9166667+00:00
Mathankumar Rajendran 0 Reputation points
edited a comment 2023-02-08T11:33:50.68+00:00
Mathankumar Rajendran 0 Reputation points
2 answers

How to Fix SSRS prompting for user name/password?

I am accessing SSRS reports using URL method in my UI by using iframe element in React js . Whenever I open it for first time it will ask me for user name and password of server. I am using SSRS report server 2019 Is there any way to pass username and…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
8,266 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,132 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
6,043 questions
asked 2023-02-06T11:25:16.1233333+00:00
Amit M 0 Reputation points
edited a comment 2023-02-08T09:40:47.6933333+00:00
Amit M 0 Reputation points
2 answers One of the answers was accepted by the question author.

MS SQL 2019 Developer Edition Download Link

Hi, I'm trying to find link for MS SQL 2019 Developer Edition. But all links lead to https://www.microsoft.com/en-us/sql-server/sql-server-downloads where SQL 2022 is. Where can I find link to download SQL 2019 Dev?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T16:31:34.9033333+00:00
Pavel.Dyachuk 136 Reputation points
accepted 2023-02-08T09:12:04.2166667+00:00
Pavel.Dyachuk 136 Reputation points
1 answer

Microsoft Reporting Services PDF Rendering Extension 11.0.0.0 - What is the Release Date?

Can Someone please tell me how to find out the release date of: Microsoft Reporting Services PDF Rendering Extension 11.0.0.0 ? I have a PDF document that has the following as the producer. It looks altered (all Metadata except create date and PDF…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T19:34:01.4533333+00:00
RAS 0 Reputation points
edited the question 2023-02-08T08:22:39.72+00:00
Andreas Baumgarten 66,156 Reputation points MVP
1 answer

ERROR: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse)

Hello, When I want to edit the configuration file at Package Configuration Wizard, I get this error: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse) Please refer to the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 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.
8,594 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,457 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
646 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: The period of time during which a program is being executed in a computer.
960 questions
asked 2023-02-08T07:25:00.0866667+00:00
syazwan amir 0 Reputation points
answered 2023-02-08T08:22:12.63+00:00
ZoeHui-MSFT 18,896 Reputation points
1 answer

always on sync to the secondary replica

hi folks, how do i sync up secondary replica in always on with the primary replica if my primary is online and i can not take primary offline. I'm thinking of approach, -backup full db on primary and restore it on to secondary with norecovery -backup…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T06:46:44.19+00:00
Heisenberg 181 Reputation points
answered 2023-02-08T08:17:53.2833333+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Vendor
2 answers

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch

Hello, I have created ODBC 32bit Connection to Oracle database using Oracle in Instaclient12_2 . Then created a ssrs report and execute successfully from the designer, but after publish the report to the reportserver, i tried to open it from the browser…

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,132 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.
8,594 questions
asked 2023-02-03T18:05:32.2166667+00:00
Vibin Lazar 0 Reputation points
commented 2023-02-08T07:52:42.96+00:00
AniyaTang 2,101 Reputation points Microsoft Employee
1 answer

can we use the same filters to create cascade parameters and individual parameters in SSRS?

I am creating a report which contains 3 parameters COUNTRY, STATE, and CITY. I have already created a cascade parameterized report which means the CITY result is based on the STATE result and the STATE result is based on the COUNTRY result. But what I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 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,132 questions
asked 2023-02-03T20:16:27.59+00:00
keshar joshi 0 Reputation points
commented 2023-02-08T07:51:50.6766667+00:00
AniyaTang 2,101 Reputation points Microsoft Employee
5 answers

Where can I download SQL Reporting Service 2019?

When I click on the link to Download the SQL Reporting Services for 2019, it says it is no longer available. SQL Reporting Services for 2017 is still available. Why isn't 2019???

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,132 questions
asked 2023-02-04T00:03:01.2733333+00:00
Tim McKay 5 Reputation points
answered 2023-02-08T07:50:43.23+00:00
AniyaTang 2,101 Reputation points Microsoft Employee
2 answers

Quotename Error

I have the following statement and am getting an error near keyword 'end' Declare @Col Nvarchar(Max)= '' Select @Col +=Quotename(CAST(Datepart(Year, CAST([STARTDATE] AS DATE)) AS NVARCHAR(10)) + ' - Q' + (CAST(Datepart(Quarter, CAST([STARTDATE] AS…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T22:23:35.13+00:00
ojmp2001 ojmp2001 121 Reputation points
commented 2023-02-08T07:45:05.23+00:00
Olaf Helper 26,056 Reputation points
7 answers One of the answers was accepted by the question author.

indexes in view

Hi Expert, How to create indexes in view as it is taking more than hour to run alter view view1 as select col1,col2,col3... from table1... total 35 columns

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
Azure SQL Database
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,132 questions
asked 2023-02-02T16:38:54.7266667+00:00
Shambhu Rai 726 Reputation points
accepted 2023-02-08T07:43:55.8+00:00
Shambhu Rai 726 Reputation points
1 answer

SSRS cutoms fonts issue

Dear Team we patched sql server 2016 from sp2 to sp3 including SSRS(SQL server reporting services ) and after the deployment, we found any issues in printing when using custom fonts Microsoft SQL Server 2016 (SP3) (KB5003279) Any support for this…

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,132 questions
asked 2023-02-07T07:56:13.5333333+00:00
Ahmed Semari 1 Reputation point
answered 2023-02-08T07:43:19.0033333+00:00
AniyaTang 2,101 Reputation points Microsoft Employee