Content
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…


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…


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…


How to get Existed Key Which is more than 1 count compare to source Table
Hi All, Lets say I have two sets of table which is tb1 and tb2. How can write the SQL query to get entire rows from tb1 if I comparing the keys(CHDRNO and RSKNO) which the tb2 and the count is more than 1. The keys is CHDRNO and RSKNO. Some of the key…


How to show new line in SSAS tabular model attribute
Hello there, I have values in SQL column as "Project Name: MSP \n\n Project Description: Billable \n\n Project Status: In Progress." I am using this field in SSAS tabular model as an attribute and need to show a new line instead of \n. How can…


Sql DB Backup
Hello, As we know from yesterday some azure resources is down for southeast asia region including SQL server. So can we know where azure sql db store the backup? Can we download the backup and attach to sql server onprem version?


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…
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?


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…
Cube processing showing rowcount instead of "Processing in progress"?
I have a few cubes configured in the same way, and when I process them; all of them run ok: While they run it says "Processing in progress" for a minute or two, and then it finishes... But I have a new cube, with all the exact same…
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…


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…


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…


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…


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…


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???
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…


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


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…


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…

