Microsoft Server OS

57K

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.

Hi,

I have an ssrs report which has a cell with value minutes, which I set to days:
=  ( Fields!Total.Value ) \ 1440

I color code this via
=IIF(Me.Value < 10,"LightGreen","Orange")

Now I'd like to set this cell to days:hours:minutes
and also keep same color coding: if days  < 10,"LightGreen","Orange"

Please advise howto
J
0
Hi,

On SSRS, there is a folder SCCM, under that one there are lots of reports.
Inheritance is set on topfolders but on each subfolder inheritance is disabled(!). How can I reset it in bulk (there are like 40 reports) so they all inherite the parent rights?

J.
0
Hi,

In ssrs I get diff from two dates.
How do I get also hours and minutes (now some results show 0 since diff is hours minutes only.

Thanks!
0
Hi,

I have a sql database in which I gather info of other sql databases and use this to do execute some actions.
F.e. I gather which applications are.deployed on sccm, AppV Infra and where they are deployed to, which users requested it etc

Therefore I query different sources  via Powershellandcreate different tables in my database (let's call it MyGatheringDB).
I.also have ssrs which does query my MyGatheringDB to show reports.

Isn't there a way I can make ssrs do the work and query ssrs right away?
In.other words, I d then query select * from sccm on ssrs and query these ssrs items (stored procedure then?) from my MyGtatheringDB without the need to store all the tables on MyGatheringDB?

Thanks
0
Is there a way to determine which SSRS reports are being run, and how frequently?
0
Hello EE,

We are struggling with a solid way to document the systems that are being deployed and we are looking for a template that will cover everything that needs to be included while deploying a new system. From names, IP, Visio diagram, how to screen shots, etc. So can you please share any templates that you use to manage this process? also if you use something a little more dynamic like a software I would like to hear that too, but specially looking forward to see standard templates.

thank you!
0
Hello,

Got a rather odd situation here.

There is three servers and the setup is this -
2019 Domain Controller
2019 Connection broker running RD Gateway and RD licensing server
2019 Remote desktop session host

This is a brand new environment setup from scratch. The 2019 1809.2 ISO was used for all Windows installation.

When I open up RD licensing diagnoser on the RDSH, it thinks that my session host is running 2016 when there are no 2016 servers anywhere (attached screenshot). The same thing happened to all 2019 environments I've come across so far as well. All relevant regkeys, group policies, etc are pointing the session hosts to use the correct RD licensing server. In all cases, the RD licensing servers are issuing 2019 RDS user CALs correctly as well.

We have done hundreds of RD environment setups with 2012 and 2016 before and had never encountered this. Our RDSHs are all domain joined.

I've done some Googling already and looks like I'm not the only one seeing this, but I can't see any solution so far. Is this a new bug with 2019?
0
Hi,

I'm wondering if anyone has experience with migrating multiple primary sites from multiple CAS's to a single CAS.

I've a scenario whereby I will need to take a number of existing Primary Sites that are associated to several different CAS sites currently and migrating these so they all sit under a single CAS.

From what I have read it is not possible to disassociated a primary site from an existing CAS, I'm thinking that I will need to do the following:

1. Create new Primary Site
2. Backup and migrate existing Primary site to new Primary Site
3. Create CAS, specify new Primary Site at install to bring it into the CAS pool.

4. Repeat steps 1 and 2 for all other Primary Sites
5. Add new Primary Sites as Child sites to new CAS

I know there's going to be a lot more to it than the above but I wanted to make a start. I'm not certain this is the best way to do it so I'm open to any suggestions or ideas.

Thanks.
0
Windows FTP on IIS experiencing weird disconnects. VM Runs on AZURE

The FTP is working but if I hit refresh fast a few times, it will eventually say cant connect. Then refresh again and its back.
The real issue is when uploading files and folders, the same result happens and the upload is very slow and logs show a lot of disconnects.


The FTP is setup with local usernames, and has a SSL certificate

We even reconfigured the FTP site in IIS from scratch
Im running out of ideas to check.

Thanks
0
SQL code runs fine in Management Studio but when used in a SSRS report,  the Group By and Having statements in the query blinks (it displays and 1 second later is gone and then displays and is gone).  This is using visual studio 19 community.  If I try the report in Visual Studio 13 it doesn't blink but it also doesn't pull up any data.  The report itself runs fine in both versions, but I need to make some changes to the report so need to access the query.  

Note I just migrated from SQL 2008 R2 - I don't know if this has anything to do with it?
Fund-code-that-doesn-t-work.txt
0
Hi Experts, need to secure connection to a RDS server from users accessing it via RDP. I was thinking of going the SSL route. This is a one server 2019 RDS environment with all roles on it - RD Gateway, Host session etc. What I needed to know is which role will require the SSL cert? Do I need to generate CSR from IIS? Users will be accessing the server via domain name - remote.domain.com and then click on RDP to access. There is no chance of having VPN since all users are remote and client does not want to setup a VPN solution

Local domain matches external domain - abc.com
DFL and FFL - 2019

Thanks in advance
0
The dataset exists... I wish to add a field. Not sure how to do this. Don't you add a field and refresh the query (this option is disabled)?
The dataset is embedded (I think).
Query is disabledSQL Report Builder
0
Using SSRS, is it possible to have summary and details page on same page in SSRS and to be able to highlight a row in the summary section and have the detail section display data related to that highlighted row? This is for SSRS 2017.
0
currently trying to upgrade from Windows server 2008 r2 to windows server 2012 r2 can this be performed with OEM version cd.  I don't want to perform a clean install only upgrade
0
Hi,

I am looking to find software that can Monitor, Management, and document view for printer and can be installed on windows server 2019 and work on cluster printer server. Also, I want to monitor local printer

Any software that can do that? I googled that and found many applications such as Print Limit that can do the job. However, I do not know which one are good. Any suggestion?

Thanks
0
Is there a way to setup a network folder to be available offline and the sync when connected by VPN or when in the office?

Currently building a new 2019 server as a file server and the business is asking for this capability. Our production file server does not offer this and is a major gripe among users.
0
I've worked in the IT security sector for the past few years and I wanted to take a stab at servicing small to medium size business within this realm.   I was told that Fortinet has their own SIEM that I can take advantage of and wanted to hear the pros/cons with this product as well as costs.  I wanted to also create a SOC as some point and wanted to know my options as far as to starting this adventure.  I have a friend who is already helping small business with the day-to-day IT for the business and wanted to add value by doing the cyber security side of IT.  I know I have many considerations, but wanted to get some insight as to what softwares/ideas I should be considering.  This would also include any budget softwares I can try or start working with while on a low budget.  Might be over my head here, but I always wanted such a business and would welcome all I can learn from the experts.
0
Is it possible to print to a local printer when connected remotely to a server or workstation via the Windows Server Essentials Remote Web Access (aka Anywhere Access) system?  We would like to be able to print locally to a printer in the same location as the remote computer (rather than on the Essentials network).  Is this possible?  If so, what is the simplest method to redirect printed output to the local printer?  Thanks very much.
0
windows 2012 r2  TS using, we are facing problem i printing
1. RD  user can print with easy print but after some time print stops working then we have to logoff and prints start
0
Exchange 2016 CU15 DAG  2 Nodes
Windows 2016 Server

Getting event Id 1033

Log Name:      Application
Source:        MSExchange ActiveSync
Date:          12/27/2019 2:51:00 PM
Event ID:      1033
Task Category: Configuration
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      TGCS021-N1.our.network.tgcsnet.com
Description:
The setting SupportedIPMTypes in the Web.Config file was missing.  Using default value of System.Collections.Generic.List`1[System.String].
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSExchange ActiveSync" />
    <EventID Qualifiers="32772">1033</EventID>
    <Level>3</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2019-12-27T19:51:00.378696600Z" />
    <EventRecordID>7734153</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TGCS021-N1.our.network.tgcsnet.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data>SupportedIPMTypes</Data>
    <Data>System.Collections.Generic.List`1[System.String]</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        MSExchange ActiveSync
Date:          12/27/2019 2:51:00 PM
Event ID:      1033
Task Category: Configuration
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      TGCS021-N1.our.network.tgcsnet.com
Description:
The setting LiveIdBasicAuthModule.ApplicationName in the Web.Config file was 

Open in new window

0
Issue joining a domain

I am having the following problem adding a fileserver to a domain.

Background:  Server is a member server, able to see the DC via nslookup, and ping it. Firewall is also disabled on member server, and I have correct permissions to add server to domain (unfortunately, I do not have the rights to log into the DC itself).

Here is the Netsetup logs:

12/24/2019 18:29:37:218 NetpDoDomainJoin
12/24/2019 18:29:37:218 NetpDoDomainJoin: using current computer names
12/24/2019 18:29:37:218 NetpDoDomainJoin: NetpGetComputerNameEx(NetBios) returned 0x0
12/24/2019 18:29:37:218 NetpDoDomainJoin: NetpGetComputerNameEx(DnsHostName) returned 0x0
12/24/2019 18:29:37:218 NetpMachineValidToJoin: 'Servername'
12/24/2019 18:29:37:218 NetpMachineValidToJoin: status: 0x0
12/24/2019 18:29:37:218 NetpJoinDomain
12/24/2019 18:29:37:218       HostName: Servername
12/24/2019 18:29:37:218       NetbiosName: Servername
12/24/2019 18:29:37:218       Domain: xxx.yyy.zzz.com
12/24/2019 18:29:37:218       MachineAccountOU: (NULL)
12/24/2019 18:29:37:218       Account: @@BR7fmEJmblZSrrdbzB8sjUn236WJ
12/24/2019 18:29:37:218       Options: 0x27
12/24/2019 18:29:37:218 NetpValidateName: checking to see if 'xxx.yyy.zzz.com' is valid as type 3 name
12/24/2019 18:29:37:218 NetpValidateName: 'xxx.yyy.zzz.com' is not a valid NetBIOS domain name: 0x7b
12/24/2019 18:29:37:812 NetpCheckDomainNameIsValid [ Exists ] for 'xxx.yyy.zzz.com' returned 0x0
12/24/2019 18:29:37:812 NetpValidateName: name …
0
  1. Error doing inplace upgrade from Win2008r2 to Win2012r2

Hello! I am running into the following problem trying to do an inplace upgrade from 2008r2 to 2012r2

Setuperr.log in the source files (C:\$WINDOWS.~BT\Sources\Panther) shows:

 Error [0x0808fe] MIG   Plugin {050ed09e-a530-41e6-8ac9-a9a96e74a2c1}: [schmig] User Tile: SHCopyUserTile Failed (0x800703ee)

I have done the following:
•Ran sfc /scannow
•Cannot uninstall antivirus (unfortunately...)
•Server is running 2008 R2, service pack 1 and is virtual machine (vmware, and the SCSI controller is LSI Logic SAS)
•Confirmed enough free space (over 100 Gb provisioned free for OS partition), plenty of Ram
•Ran windows update readiness tool

Have Ran with 2012r2 Iso the following commands:
(ISO location )setup.exe /HideWelcome /uilanguage:en-GB /targetlanguage:en-GB /runlocal /noreboot    with CMD and admin permissions
I have copied ISO setup files to local drive, and ran this command from local temp folder
During the upgrade, the servers reboot, and gets the wpeinit cmd screen on the X:\ drive (which doesn't exist). I can't go anywhere from there but choose to boot 2008 again.


And Yes, I know I should be doing a clean install but unfortunately that is not an option for me as I am trying to keep the server on the domain (that I do not control, which is another issue I am having).

Any ideas? I browsed similar topics here, and I was not able to find the solution. Trying to…
0
I observed during this month patch window, 1 out of 21 sites I have is not patching. The status remain unknown eventhough the systems has been validated.

See the attached.

Kindly advise.
SUP.jpg
0
Hi Team,

There is an application SCAD which configured on several servers OS (Windows 2012 R2), Users are taking application access through RDP on their local system, all users are local users on server not domain users.

During the RDP session, sessions should not be locked. We have already taken the below course of action.

1>      Disabled the local screen saver policy on servers.
2>      If I login to server using local user ,it doesn’t lock and under screen saver properties also it shows wait 0 minutes
3>      But when users login to server using application RDP ,RDP Sessions are getting locked

Is there any additional setting need to be changed ?
0
We have a DFS file share that starting a few months ago users started having issues with folder contents taking a very long time to be displayed in file explorer.  The issue is not consistent at all, some times the folders will display very quickly and a few minutes later it may take upwards of 3 minutes to display the same folder on the same client.  This behavior is occurring across all 9 of our DFS servers across our WAN, and seems to be only on this 1 share and not any of the other shares on the same servers.  All of our clients are Windows 10.  The servers are a mix of 2012 R2 and 2019.  We have been trying to resolve this for weeks, trying many different 'solutions' we have found in the web for very similar issues with no luck.
0

Microsoft Server OS

57K

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.