SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,851 questions
3 answers
One of the answers was accepted by the question author.
SQL Server Express versions 2016, 2017 and 2019 installation error code 0x84BB0001
I have tried many times to install different versions of SQL Server Express on Windows 10. All end with the same errorcode: 0x84bb0001 - attempt to perform an unauthorized operation. This happens on my desktop as well as my laptop. I found dozens of…
asked 2021-02-17T13:24:14.423+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 14.000000000000002%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Ruud van der Spoel
21
Reputation points
answered 2021-02-17T20:09:34.267+00:00
Ruud van der Spoel
21
Reputation points
4 answers
SQL server cluster
what are the steps to create a cluster in SQL with a different subnet?
asked 2021-02-15T06:58:09.077+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 15%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hussain Bazzar
21
Reputation points
answered 2021-02-17T19:08:39.83+00:00
Alex Bykovskyi
1,831
Reputation points
2 answers
One of the answers was accepted by the question author.
Report Services support for DAX function ROLLUPADDISSUBTOTAL
I am attempting to create an SSRS report which will query an SSAS Tabular Model. I want to get a table in the report that has a subtotal row with percentages. Unfortunately while the tabular model has measures for the amount (numerator) and another for…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 55.00000000000001%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
SSRS migration SP 2013 to SP 2019
We have on-prem SP 2013 environment (with SQL 2012) which is running hundreds of SSRS reports. We are planning to migrate to on-prem SP 2019 (with SQL 2016) and it says SP 2019 doesn't have SSRS feature now. In this case, how do we get to see our…
asked 2021-02-15T08:54:22.283+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 77%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
shashank
131
Reputation points
commented 2021-02-17T17:42:34.043+00:00
KoprowskiT
236
Reputation points
1 answer
One of the answers was accepted by the question author.
cross forest authenticatoin sql 2016
Have the following: Client AD Forest (non-azure) with an RDS Server. Primary Forest (non-anzure) that houses a SQL 2016 Server. Bi-Directional Trust exists between domains. . I need for users in the Client Forest to be able to use their domain…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 81%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Compare two table columns,
Compare two table column ,if Item_Rate of B_ID against Level_Four_ID exit in #tbl_Assign ,then item_Rate Pick from #tbl_Assign,if Item_Rate does not exit in #tbl_Assign of B_ID, then rate will pick from #tbl_bottles . I Created below condition ,in…
asked 2021-02-17T15:39:13.457+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Analyst_SQL
3,551
Reputation points
accepted 2021-02-17T16:39:42.867+00:00
Analyst_SQL
3,551
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Server 2017 Reporting Services REST API - hide toolbar options
Can SQL Server 2017 Reporting Services REST API be used to generate SSRS report URLs with certain options hidden? If possible, would like to generate URLs that run SSRS reports and only allow Print and Export to PDF.
asked 2021-02-16T20:39:22.303+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 97%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Adrian Hernandez
41
Reputation points
accepted 2021-02-17T14:15:04.87+00:00
Adrian Hernandez
41
Reputation points
1 answer
When adding a parent group to group by project, my data is getting split between two groups with the same project number. What do I need to fix?
I created a nice report with groups and parameters. When I ran it by certain date ranges, I noticed that I would get the same group shown twice but with different data in each group. I assumed I had an issue with a calculated field, parameter, etc., so I…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Making dynamic data masking conditional
My question may not be valid but is there any way to switch off dynamic data masking in runtime. I want to use same user for updating records. I want to use on conditional basis. I need to select unmasked records for update & masked data for…
asked 2021-02-12T07:25:29.103+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 80%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
hriday sharma
21
Reputation points
accepted 2021-02-17T10:26:27.147+00:00
hriday sharma
21
Reputation points
1 answer
One of the answers was accepted by the question author.
SSAS 2017 - Connecting to unencrypted databases in Visual Studio in 1400 compability mode
I setup a new instance of SSAS 2017 on Windows 2012 R2, in Tabular mode. The developer is developing new models. He states all was working well, until last week. Now he cannot connect to unencrypted SQL data sources. If he connects to one without a…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,668 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.
12,851 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,248 questions
asked 2021-02-08T20:19:51.993+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 10%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
alhowarthWF
301
Reputation points
commented 2021-02-17T03:39:43.993+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,816
Reputation points
2 answers
One of the answers was accepted by the question author.
sql audit questions
I have enabled MS SQL audit on a client server. Requirement is to collect audit logs - audit failed, successful logins, permission changes audit. So as a start I created an instance level logging saving to a file. Q1: Upon enabling auditing it…
asked 2021-02-14T23:15:26.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 28.000000000000004%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
shaikh shoaib
171
Reputation points
accepted 2021-02-17T02:47:53.927+00:00
shaikh shoaib
171
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Best Practices
Hi All, Need some advice on the below questions please Is there any best practices to manage shared DB. Just wanted to understand, how patching is managed for shared DB without any downtime. Is there any load balancer used normally
asked 2021-02-16T05:34:33.727+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 15%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
karthik palani
1,016
Reputation points
answered 2021-02-17T02:47:29.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,606
Reputation points
4 answers
How to make query get less time when run to take from 9 second to one second ?
I work on sql server 2012 I have issue when run query it take 9 second to return only one row so it is more because i will display may be 100000 rows so for one row it will be huge time so what I do execution plan …
asked 2021-02-11T22:10:28.373+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ahmed salah
3,216
Reputation points
commented 2021-02-17T02:29:04.857+00:00
MelissaMa-MSFT
24,176
Reputation points
3 answers
One of the answers was accepted by the question author.
data driven subscription owner change permission issue
We are using reporting service 2019 Enterprise. We created a data driver subscription of a report. When we run a subscription, if failed. We found this is because the subscription owner is some other colleague. she runs the subscription fine. We have…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 18%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
6 answers
SSRS Database Configuration Errors
We are trying to upgrade SQL & SSRS from 2012 to 2019. While we were able to restore the 2012 ReportServer and ReportServerTempDB to the new 2019 instance and point SSRS 2019 to them, we can't seem to open them. So we decided to create new SSRS…
asked 2021-02-11T17:11:03.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 30%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
Brandie Tarvin
1
Reputation point
answered 2021-02-16T19:04:18.737+00:00
Brandie Tarvin
1
Reputation point
2 answers
Reference to servers in queries
Is there a way to alias a database in the same way that we can for tables? We have a set of servers, and when we create a test version of the system, all queries need their connections to databases updating. I am wondering if there's a better way to…
asked 2021-02-15T14:01:36.527+00:00
Mark
26
Reputation points
commented 2021-02-16T19:03:04.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips
17,716
Reputation points
3 answers
Upgrading to 'ODBC Driver 17 for SQL Server' from 'SQL Server Native Client 11' for ADO.
1)Im using ADO(msado15.tlb) in C++ to connect to Local/Remote SQL Server. Now changing ODBC driver from 'SQL Server Native Client 11' to 'ODBC Driver 17 for SQL Server'. Is there any thing to be taken care (Multisubnet,XML datatypes,TLS,AD User)?…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,438 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.
12,851 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,553 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 87%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Auto Refresh Tabular Model
Hi All, I need to have my SSAS Tabular Model auto refreshed every day at certain time so that newly added data in tables are pulled in model and subsequently in Power BI reports. Can anyone guide me to have steps to do the needful? Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
4 answers
SQL2019: Python: The process cannot access the file because it is being used by another process
Hi, I have a SQL Server 2017 Developer (14.0.3356.20 (X64)) and a SQL Server 2019 Developer (15.0.4083.2 (X64)) with Machine Learning (R+Python) installed. Both are installed on different machines On both sql-servers is Python 3.7.1 installed On…
asked 2021-01-19T13:50:56.723+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 50%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVH%3C/text%3E%3C/svg%3E)
vom Hau, Marco
21
Reputation points
answered 2021-02-16T16:25:41.057+00:00
vom Hau, Marco
21
Reputation points
2 answers
One of the answers was accepted by the question author.
How to automate Azure Analysis tabular model refresh every hour today in 2021?
We have Azure Analysis service provisioned and have deployed a SSAS Tabular model which has a Star schema in it . Now we want to know how automate the processing . When I look up on the internet ,it seems there are 3 ways not sure how to select which…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)