[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Microsoft Server OS

56K

Solutions

41K

Contributors

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Share tech news, updates, or what's on your mind.

Sign up to Post

I create SSRS report with 2 series. One is the number of tests, another is the number of tests that passed on the first try. I want to show it as stacked bar report. When I create the report with 2 series, both numbers are in the same bar, but they are one above the other, while I want the bar colored according to the percentage. For example, if in given month there were 100 tests, of which 90 passed on the 1st try, I want the bar filled with the 2nd color at 90% - instead of the current 100 and 90 on top of each other. Is it possible?
screenshot
0
JavaScript Best Practices
LVL 12
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Does anyone know Azure licenses features EMS E5 vs. P1 license.  Seems they are offering same options.

Also, would it make sense to have a chunk of users of one license and the rest on another.  It would be hard to manage I think.  

Thoughts?
0
Hi, we plan to deploy bit locker in various 10 and 20 user environments.  Should we use Acronis or something similar prior to utilizing BitLocker on workstations?  What are you feelings towards utilizing it on servers? Are there any other deployment ProTips ?   Is encryption already on the iOS ?  What should we use for encryption on these mobile devices ?
0
Hi

We have installed  MDT  6.3.8450 on Windows 2012 server and there are few issues  and would like to uninstall Windows Assessment and deployment Kit - Windows 10 and reinstall.

On the control panel when i click Uninstall , it says uninstalling features and  and hangs on 0%  and there is no progress on uninstall..
Please let me know as how to uninstall this  and reinstall successfully.

Is there any uninstall utility?

Any help will be great and thanks in advance
Thanks
0
Unable to install SSDT for 2017, SSMS for 2017 or SSRS for  2017 due to language mismatch.  I have a W10 Professional with SQL2017 and VS Community 2017 installed. In the log files there are messages about language mismatch and on the screen there are messages about unknown registry key. The language is English and I have been using the English version of the OS and the tools. Does anyone have any ideas on how to get past this? The few notes I have been able to find say it cannot be done.
0
in excel how to represent below date and time stamp as it is like in database cell

2018-11-13 06:13:15.891


when i copy past it shows as 13 or something

how to import sql server results value including heading to excel without loosing date formatting etc
any tips or tutorial videoes around this?

Please advise
0
I have an SSRS project that was built with VS2010, and I need to upgrade this solution to VS2017.

I have installed VS2017 along with SSDT and msSQL 2017 on my workstation.  I have made sure that I can access the BI Templets for SSIS, SSRS, and SSAS. But when I try to open up the ssrs sln file I keep getting this message that says the load failed, but when I try to reload the project, I get the error message that the project has been moved.

How do I go about upgrading my old SSRS project to VS2017?

Thanks,

Rich
0
DNS issue

so i am new to DNS, here is my problem

we have a marketing site hosted, externally the site works perfect however lately internally when we hit the url we get page cannot be displayed, the fix is to go to our DNS servers and clear cache which works for about 30 minutes then it breaks again
0
I've got a SSRS report which currently filters a dataset on "[ProgramID] = @ProgramID" and the report parameter is set to only allow a single selection.  This is currently done in the dataset which looks something like:

SELECT * FROM myTable WHERE ProgramID = @ProgramID

My client wants to change this to allow the user to select multiple Programs from the Program dropdown.

How do I modify the SQL query in my data set to accommodate this multi-select parameter?  I've tried a number of things and cannot seem to get it to work by modifying the SQL or by removing the criteria from the query and adding a filter to the tablix which uses the dataset.  I've searched and tried a number of "solutions" from here in EE and other web-sites and just cannot get this right.

Thanks
0
SSRS Subscription and Daylight Saving Time

What is the best way to handle  Daylight Saving Time in SSRS subscription


Can that be updated in DB ?

thanks
0
Acronis True Image 2019 just released!
LVL 1
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

This problem used to happen once or twice a year, but it's happening with higher frequency now, and I'm at a loss how to troubleshoot it - because the normal troubleshooting method I'd use is the temporary and unintended "fix" itself.

I have an SSRS 2012 report deployed in SharePoint (2013) mode on a Windows Server 2012. The report is configured to use a dynamic data source, such that it can be run against 1 of 5 similar sites (databases). When the problem arises, whether I run the report from IE or within SSDT itself, I get this red-herring message:

The error message
Here are some important outcomes from my troubleshooting so far:
  • My normal troubleshooting strategy is to gather the list of inputs the SP behind the report would use, and run the SP manually from SSMS. As soon as I run this query, the problem disappears
  • The date range on the report makes no difference. Even if the report ran last week on last week's data, setting the date range to last week when the problem arises this week still results in this message
  • The problem typically happens on 1 or 2 sites at any given time, but not all sites. The "fix" is to connect to each site's DB and run the query once in SSMS
  • I use the term "red-herring" because if it were a data issue, the problem wouldn't disappear simply by running the query in SSMS. One would expect to find a bad piece of data that would require correction
0
I would like to know if it's possible to retrieve an hashed password from ADAM with Python?

I've seen that DSInternals could allow that, but wouldn't work with ADAM.  Plus we don't need the password in clear text, just the hashed version.

(Using Windows Server 2012 R2, ADAM, Python 3.7)

Thanks
0
Hi,

I have something somewhat similar to the Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS) with the Expression-based Connection Strings. This is with SSRS 2014.

But when I go to publish it's asking for datasources on the Report Server -> Report Manager. How would/could I do the Expression-based Connection Strings with that?

Any information on that would be greatly appreciated.

Thanks
0
I'm trying to set up remote Desktop services on our Windows 2016 server and the licences (User CALS) aren't being used by users when they log in via RDP (as viewed in RD Licensing Manager).

I've been through the instructions on several sites namely this one at www.lemonbits.com but am getting the following error in Server Manager > Remote Desktop Services > Servers:

Error ID: 85
Source: Microsoft-Windows-TerminalServices-Licensing
The Remote Desktop license server could not be registered as a service connection point in Active Directory Domain Services (AD DS). Ensure that there is network connectivity between the license server and AD DS. To register the license server as a service connection point in AD DS, use Review Configuration in the RD Licensing Manager tool.

When I Review the Configuration All I get is green ticks and no actions to take.

Looking for advice on where to go from here. It's all changed since I last set this up in 2008 when, if I remember correctly,  it was much simpler (good old days?)

Review Configuration
RD Licensing Manager
RD Licensing Manager
RD Gateway Manager
RD Gateway Manager
Server Manager
Server Manager
0
For no particular reason at all, we are now receiving the following error when printing from a remote desktop session on Windows Server 2012 R2. We are running Parallels Remote Desktop Application server, with 3 Win Svr 2012 R2's in the pool.  Users CANNOT Print from their windows remote sessions to network printers.

The document Print Document, owned by XXXXXXX, failed to print on printer {C092F33B-0674-436D-995C-B2E3B5E66090}. Try to print the document again, or restart the print spooler.
Data type: RAW. Size of the spool file in bytes: 55421. Number of bytes printed: 0. Total number of pages in the document: 1. Number of pages printed: 0. Client computer: \\PAR1. Win32 error code returned by the print processor: 87. The parameter is incorrect.
0
Have been getting this on all workstations.

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{9BA05972-F6A8-11CF-A442-00A0C90A8F39}
 and APPID
{9BA05972-F6A8-11CF-A442-00A0C90A8F39}
 to the user 92NDSTY\lkrotman SID (S-1-5-21-1946247470-735590240-313593124-13693) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

the APP ID is Rutimenbroker but the error pops up every time the user uses Chrome (web browser)

I have taken ownership of the registry keys - gone into DCOM -
Launch and activation
- gave local / remove activation access to local administrators, domain administrators, the user, myself, network service, local service, system. authenticated users, even the everyone group and nothing.

Problem still continues. I'm at a loss to what can be done now to stop this error from happening
0
A couple years ago I found a Windows utility that was able to search for a filename or filename extension on multiple servers (as long as the user doing the search was an administrator or domain administrator).

This utility would then list the exact path \\server\drive letter\folder path to the file.

I am now looking for utilities that are able to do this.

What utilities are able to do this?
1
Hello,
I was wondering if there is an easy way to find out which one of our servers are running TLS version 1.0?
We have about 75 servers and I was not sure the best way to find out what servers are running TLS and then which ones need upgraded or at least add the latest TLS version.
0
Dear experts

Our company would like to setup open source OT management system that allows us to do following:

1. When employ wants to do OT, Start time must be submitted first and then it will only be reflected to system once administrator approved.
2. Later when employee finish job, he or she can set the end time, and there should be something that allows emplyee to upload service report that contains start and end time signed by our customers.
3. After setting end time, it should show total OT - hours and we should be able to generate monthly OT for each employee.

Plz advise something that is opensource or even if need to pay, it should be something not very expensive.
0
The 7 Worst Nightmares of a Sysadmin
LVL 1
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Hi,
We have a DB driven application where all the business logic written in Microsoft SQL.
We need to create a bunch of dynamic PDFs (Fillable PDFs) as a result of the calculations. We are now creating the PDF using .Net API and PHP.
Is there any easy way to create the PDF using SQL Reporting Services or any other ways?
Once the PDF is generated, we will use Angular ng pdf viewer to show the preview in browser.
Please help?

Thanks in advance :)
0
Our business just got a new copier.  The old copier drivers work on the new copier, but I want to update workstations to the new driver.  So, I added a 2nd printer GPO (users/policy/windows/deploy printer) and (computers/policy/windows/deploy printer), so the transition would be seemless to the end user.  In a couple weeks, I want to remove the old printer driver gpo (gpo setup the same way).  If I simply delete the old gpo, will the printers disappear from the users device & printers?  If not, what do I have to do to remove the old printer install?
0
I had this question after viewing Displaying group data from a table in a textbox outside the table in SSRS 2008.

I followed the steps, and I'm at the point where I have a text box named Textbox52 in the header and it has the value I want, but when when I try to use Textbox52 to display the Value using the expression ReportItems!Textbox52.value  somewhere else in the report (I have several rectangles in the report), I get the error "Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope. Letters in the names of report items.
0
I am in the process of converting a large number of Crystal Reports to SSRS. I have hit a snag with a number of Running Total issues.

In a number of reports, A running total evaluating on change group is used as a grand total outside of the group. As you can imagine I can not get this to work as if I write a running value expression on group it is outside of the group scope and does not work, and if i set the scope to "dataset1" the value is not correct as it needs to evaluate on group.

Any ideas on a way to get this to work?
0
Hello All:

I need help in figuring out how to print a subreport on the last page of it's main report with one parameter passed between them in SSRS.

I need to print a purchase order and every time it prints a follow up terms sheet prints after the main PO prints with the purchase order number printed on both the main and sub report.

I need assistance on the best approach for this.

Any ideas on the best approach for this would be very helpful.

Thank You

Rm103
0
Hi,

We have Ahsay Offsite Backup Server v6 installed on our Windows 2003 server and use this to backup data for our users.

We are no longer backing up data for some of our users and wish to remove their licenses from our Ahsay backup.

What is the best way to disconnect a user and remove their user license from our Ahsay backup?

Thanks,
Robbie
0

Microsoft Server OS

56K

Solutions

41K

Contributors

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.