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

Is there a way of switching or toggling between monitors while connected to a remote Server 2016 server during a remote desktop connection from a Windows 10 laptop that only has one display?

I have a server connected to six different monitors and need to switch between the monitors to get to particular programs that are set to open on different monitors.

This is something I am able to do while connected to the server using Log Me In or Solar Windows MSP.

I have looked at the remote desktop settings and haven't been able to yet find such a setting. This is something that the "Use all my monitors for the remote session" option won't do.
0
Newly released Acronis True Image 2019
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

I have the following query that executes in SSMS in 1 minute 28 sec. However when I attempt to run it in SSRS it times out. I have increased the Time out to 600 and it still fails. I would use query analyzer to place some indexes however this is our ERP database and each time they work on the DB they restore the database as it was deployed meaning indexes, tables, views, etc. are dropped and I have to rescript them.

The query returns 37557 rows. It began to time out in SSRS when I added the following Join LEFT OUTER JOIN [dbo].[KLL Customer Projections] C ON C.customer = ORD.customer

This is a summary amount that needs added.  Specifically this column C.projection_amt , So at the summary level I have 40 customers. Each with a sales projection amount. So part of my issue is that I'm linking thousands of records to 1

Is there anyway to tweak this query so that it runs more efficiently?
/****** Script for SelectTopNRows command from SSMS  ******/
SELECT  ORD.customer ,
        zzxcustr.cust_name ,
        ORD.Style_Season ,
        zzxseasr.seas_name ,
        ORD.style ,
        ORD.color_code ,
        ORD.lbl_code ,
        ORD.dimension ,
        ORD.MAINLBL ,
        ORD.SCALEFIN ,
        ORD.CLASS ,
        ORD.TYPE ,
        ORD.slsperson1 ,
        SUM(CONVERT(MONEY, CASE WHEN ( ( YEAR(ORD.ship_date_cascaded) = @CurYear
                                         - 2 )
                                       AND ( ORD.line_status = 'I' )
                   

Open in new window

0
In an SSRS report I want to hide the tablix/table when there are no rows appearing. Problem is there are rows, but I hide the rows when column 1 is the same as column2. So my problem is that I don't want the column headers / table to appear when no other row appears. Is this possible I think there are scope issues doing this.

At moment I have two datasets. One retrieves current values, the other dataset retrieves historical data from a specific point in time. So I am using the lookup value '=Lookup(Fields!LabelLookup.Value, Fields!LabelLookup.Value, Fields!Value.Value,"Date2")' to show in one cell what the value was at a specific date and in the other cell what is is now on the same row.  When the two values are the same I hide the row because there was no change. This works fine, but sometimes I am left with just the table header showing no rows. However, there might be lots of rows but are actually duplicate, as the value has not changed between the two dates.

Is there a way to check if there are no rows appearing in the table after the hide rows has been applied? I'm not sure it is possible? If not is there another way I might be able to do this?

Using sql server and SSRS instance 2014
0
A long time ago I set up web / dns hosting for my domain and a bunch of clients.  somewhere I saw the idea of rather than ns1.networksolutionsy.com (just an example, don't think that's the correct URL) , that you could set up ns1.yourdomain.com  for the name servers  - i think it's just a cname in my DNS zone?  Actually looking now, it's an A record resolving to the IP of the web hosts' name server IPs.

But I remember there were some caveats / things to be aware of.  I'm looking to change things and the name server will change.

Anyone know what the caveats are?  Say I want to use godaddy's name servers for the different domains I control instead of networksolutions.  Can i just get the IP addresses of the godaddy name servers and change the A records for ns1 and ns2 in my domain zone and then at least the other domains.  but for my domain iteself?  There was something about trying to resolve ns1.mydomain.com but it has to look up my name servers first.... and that's a vicious cycle?

Anyone know what I'm thinking of / what the resolution was? because it is workingl and has been for years
0
Dear all
        i would like to know how many IIS is running on the server in the world, is there any website for this ?
0
I am attempting to set up a new multiforest ldap instance but am getting stuck with the install of the xml file, followed by a sync. I may be confusing the matter and need some instruction on what steps are correct if I am attempting to pull in and sync all remote domain users to the multiforest partition and how to resolve associated errors.

Steps taken and code used:



XML Code:

<doc> 
<configuration> 
<description>Import domain USers</description> 
<security-mode>object</security-mode> 
<source-ad-name>domain.k12.mn.us</source-ad-name> 
<source-ad-partition>dc=domain,dc=k12,dc=mn,dc=us</source-ad-partition>
<source-ad-account></source-ad-account> 
<account-domain></account-domain>
<target-dn>dc=multiforest,dc=local</target-dn> 
<query> 
<base-dn>domain.k12.mn.us</base-dn>

Open in new window


Adamsync /install Command: (no creds)



ADAMSync /install localhost:52512 c:\windows\ADAM\MS-AdamSyncConfdomain.xml /log c:\windows\adam\logs\install.log



Establishing connection to target server localhost:52512.
Updating configuration file on c:\windows\ADAM\MS-AdamSyncConfdomain.xml.
Reading Configuration File from c:\windows\ADAM\MS-AdamSyncConfdomain.xml
Saving Configuration File on dc=multiforest,dc=local
Saved configuration file.
Done.
Done.

ADAMsync /install (with creds)

ADAMSync /install localhost:52512 c:\windows\ADAM\MS-AdamSyncConfNLS.xml /creds domain.k12.mn.us administrator password /log c:\windows\adam\logs\install.log

Establishing …
1
I have written a procedure to update SSRS subscription schedules. The procedure appears to work because the values are updated in ReportServer.dbo.Schedule. However when I view the schedule through SSRS Report Manager, the dates are not updated.

The code I am using is below -

declare 
--@SubscriptionID varchar(100) = 'E65E6D4A-A631-4C17-A8DB-001FB0AD0855'
@Path varchar(max) = '/QTS Internal/RTM/Service Disruption Report'
, @SPLC varchar(max) = '123456'
, @State varchar(max) = 'VA,NC'
, @Country varchar(max) = NULL
, @Carrier varchar(max) = NULL
, @Location varchar(max) = NULL
, @CustomerID varchar(max) = '1'
, @Disruption varchar(max) = 'Hurricane Florence'
, @StartDate datetime = '20180914 04:19:00'
, @EndDate datetime = '20181002'

create table #subs (SubscriptionID varchar(200), [Path] varchar(200))

insert into #subs

select s.SubscriptionID, c.Path

from Catalog c
join subscriptions s on c.ItemID = s.Report_OID
where c.Path = @Path

-----------------------------------------------------update schedule dates

UPDATE ReportServer.dbo.Schedule
SET StartDate = @StartDate, EndDate = @EndDate
from Catalog c
LEFT OUTER JOIN Subscriptions s WITH (NOLOCK) ON s.Report_OID = c.ItemID
LEFT OUTER JOIN ReportServer.dbo.[ReportSchedule] RS WITH (NOLOCK) ON s.[SubscriptionID] = RS.[SubscriptionID] 
LEFT OUTER JOIN ReportServer.dbo.[Schedule] SC WITH (NOLOCK) ON RS.[ScheduleID] = SC.[ScheduleID]
JOIN #subs subs on s.SubscriptionID = subs.SubscriptionID

Open in new window


Does anybody have experience with this?
0
XenApp 6.5 - Published applications disappears during launch.
Environment:
Citrix XenApp 6.5
Windows 2008 R2
https://support.citrix.com/article/CTX213389
Checked all Registry setting as per above Citrix article.
Other Apps on the same server launching, but only one app not launching. It disappears during launch.
i.e While launching, all GPOs and Profile steps are completing, app screen almost visible, then after disappearing.
Please suggest.
0
I have been tasked with creating some reports out of VS and SSRS from an Oracle 12c database.  I am an Oracle developer but I don't know much about VS or SSRS.  I have both VS 2015 (14.0.25431.01 Update 3) and 2017 (15.7.5) installed and I have installed ODTwithODAC for 12c.  I have also installed SSDT for both VS 2015 and VS 2017.  

Using VS 2017, i have created a new project but I am unable to create a shared data source.  As soon as I select Oracle Database in the Type drop-down, the Edit button next to the connection string becomes grayed out.  

Using VS 2015, I have cloned an existing project that works fine for my colleague.  However, when I first tried to load the project I received a message that the version of the report server project is not supported and the project must be upgraded.  If I say no, then the project won't load.  If I say yes, the project loads and everything seems to be ok. However, when I try to Preview an existing report from the project, I receive the following error:
"An error has occurred during local report processing.  An error has occurred during report processing.  An attempt has been been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services."  There is nothing in the Error List when this happens.  

The only difference between my colleague's setup and mine is that he has SQL Server Reporting Services 14.0.806.134 and I have …
1
Please help with writing a query to get aggregated OrderAmount for each SalesPerson for the last month (last 28-31 days). For example, if today is 09/13/2018, we need sum from 08/13/2018 to 09/12/2018.

TableOrders
----------------
SalesPerson
OrderAmount
OrderDate


Thank you in advance.
0
10 Tips to Protect Your Business from Ransomware
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Logon Process Initialization Failure / Server 2012 R2

Newly formatted and reloaded server 2012 R2.  Has been working fine for the last week.  This morning, we are getting the Logon Process Initialization Failure error.  Have seen some solutions posted for Win 10 and MS has a hotfix for Server 2008, but I can't find anything for 2012 R2.

Have tried Alt-Tab to bring the focus to the error window, but it just flashes and still will not clear.  Anyone have any other ideas?  I would prefer not to have to reload the server again.

Thanks in advance.
0
RADIUS VPN fails to connect due to NPS error.

We have a router doing Radius passthrough to Server 2012 R2 using NPS.

The policies have been created via a wizard and appear correct.
I have a security group in AD that I am testing with a test account.

When initiating the connection externally it times out and returns the following from the NPS event logs:

Network Policy Server denied access to a user.

Contact the Network Policy Server administrator for more information.

User:
      Security ID:                  dc.local\testing123
      Account Name:                  dc.local\Testing123
      Account Domain:                  RSCdc.local\Testing123

Client Machine:
      Security ID:                  NULL SID
      Account Name:                  -
      Fully Qualified Account Name:      -
      OS-Version:                  -
      Called Station Identifier:            -
      Calling Station Identifier:            -

NAS:
      NAS IPv4 Address:            192.168.23.5
      NAS IPv6 Address:            -
      NAS Identifier:                  -
      NAS Port-Type:                  -
      NAS Port:                  -

RADIUS Client:
      Client Friendly Name:            draytek vigor 2920
      Client IP Address:                  192.168.23.5

Authentication Details:
      Connection Request Policy Name:      Use Windows authentication for all users
      Network Policy Name:            -
      Authentication Provider:            Windows
      Authentication Server:            dc.local
      Authentication Type:            MS-CHAPv2
      EAP Type:                  -
      Account Session Identifier:            -
      Logging Results:                  Accounting information was written to the local log file.
      Reason Code:                  48
      Reason:                        The connection request did not match any configured network policy.


NPS is …
0
My Hyper V VM cannot get out to the internet. I setup a Hyper V lab with multiple server 2012\16 machines. I originally set them up on the private switch because I didnt think I would need the internet. I decided I needed it so I switch it to the external switch and they can still see each other but just not get out to the internet.

One of my VM's which I setup with the external switch when I installed it, still gets out to the internet. Just the ones im changing from a private switch to external wont work. Is there something I am missing?
0
We recently upgraded our SCCM clients (Configuration Manager) to 5.00.8634.1814.

We did this after upgrading the site to 1802.

After the upgrade all of the icons in Software Center are wacked out.  Prior to the upgrade, something was taking different sized icons and make them automatically appear the same.

In the new version, this functionality works in the List View option - all icons appear the same size regardless of their size.  In Tile View, which everyone uses, this is not the case.  The icons are not being adjusted for the view.

Has anyone else noted this issue?  Is there a setting somewhere I can click to resize?

I hope so.  So far it's that or I have to resize them all manually.
0
Hello everybody,
We've a VM with Windows Server 2008 R2 and we want to put this VM into another server. Everytime we try to copy the VHD files, it comes with "Can't Read source file or disk".
A possible solution, as mentioned before in another post (https://www.experts-exchange.com/questions/27661606/Cant-copy-VHD-file-possibly-corrupt.html), "the fix was to mount the vhd as a hard disk, copy everything off, then create a new vhd, copy everything back on. Then rewrite the boot sector".

We gonna try this one, since we've tried everything. But how is this "rewrite the boot sector" works? How can we do that part?

Thank you!
Att, Victor.

Update 1: We are trying to copy the Windows folder from the VHD and we're getting a lot of errors on the way, linked to the permissions.
0
Can someone provide the name of some open source software that can assist with web utilization, os utilization virtualization and security vulnerabilities. It does not have to be all the same software. This is for linux and windows OS.
1
Need an automated way to create Azure Dynamic Security Groups using PowerShell. These groups needs to be created based on an AD attribute i.e employee number. Any thoughts?
0
What device do you recommend that can email me when my server room's SOUND get above a certain decibel level ?
  ** Maybe something like https://serverscheck.com/sensors/sensor_sound.asp, etc ?
0
while exporting my report data to excel it is running 10 -15 minutes after that im getting server Runtime error in  ssrs report .I have 3 lakhs data and 49 columns in excel.
There is no exceeding limitations problem with my excel data and im trying to export it into .xlsx format only.Please suggest what i have to do
0
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Hi,

I am trying to deploy a .msp file. I need to do this as we have migrated from on-Prem Exchange to O365 and we had used MS Office customisation tool in order to configure settings including automatically creating an outlook profile that points to the on-Prem exchange server. Now that we have migrated, it is causing issues with the outlook profile re-configuring.

Office is built into our MDT Image, so removing it from the office installation would be a giant PITA.

I have created a new OCT MSP file and when installing it manually it re-configures office and all works great. My problem is now deploying this file to all workstations. I have created a batch file with the below command.

msiexec.exe /p "\\sbpsfile01\School\School\Apps\Deploy\OfficeCustom\OfficeConfigRemove.MSP" REINSTALL=ALL REINSTALLMODE=omus /qn

I have also tried using DFS path.

The policy is applied under computer configuration and the computers are in the OU that the policy is in.

Any help would be much appreciated.

Thanks,
Warren
0
The following command string exports a PDF to be saved or opened.

start explorer "<http://ServerName/ReportServer$NamedSQLInstance?%2fPurchasing%2fPurchaseOrder&PoNumber=103290&rs:Format=PDF"

Need to NAME and SAVE the file Automatically, from a Delphi desktop application.
0
We have a deployment containing a number of computers that are used by shift workers, and so have chosen to use Microsoft device CALs rather than user CALs.  However, rather than just counting the number of users, we now need to count devices and it's unclear which devices require device CALs.  It's obvious that the computers do, but what about:

  • Printers (including multi-function models)
  • Switches (including smart switches)
  • Routers (that may authenticate VPN users against the Active Directory)
  • Wireless access points (that authenticate users against the AD)

How can we determine whether CALs are required for these devices?
0
Dear Experts ,
Please help in
windows 2012,

ADAM Sync Error logs

Ldap error occured. ldap_modify_sW: Constraint Violation.  
Extended Info: 00002082: AtrErr: DSID-03151768, #1:
0: 00002082: DSID-03151768, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 9ae287ba (title):len 154
0
I have a Server 2016 Hyper-V base server with 6 Server 2016 Hyper-V virtual machines that I need to backup.

What is the best Veritas Backup Exec product and licenses to purchase for performing this kind of backup?

Will purchasing Backup Exec from the URL below allow me to do a complete backup of this server or will I need to purchase additional licenses or options?

https://www.ebay.com/itm/173263815333?ViewItem=&item=173263815333
0
Citrix Receiver 4.1 working fine, but not 4.9 for PS 4.5 IE App (Dual hop) inside Citrix XAXD 7.15 Win7 (XA7.6 VDA) VDI
Citrix Environment: Citrix XD 7.15 LTSR CU1
Provisioning technology:  It is static VDI (Windows 7 using 7.6 LTSR VDA) assignment no PVS/MCS.
Profile type: Microsoft User experience virtualization (UEV)
Hypervisor: VMWARE ESXi 6.5
- are all users affected? Yes
--Problem Statement:
We have VDIs running with VDA 7.6 and Citrix receiver 4.9 cu2.
We have an IE based app which is published on presentation server 4.5 rollup 4, win 2003 R2 sp2 standard edition, web interface 4.5 and running on Citrix secure gateway. I know it is very old and unsupported but that is what we have got, unfortunately..
The user logs in to the VDI using a Citrix SF URL and from the VDI the user then clicks on the PS 4.5 published IE and goes to another Citrix secure gateway URL.
To launch the IE-based app. This is the legacy PS 4.5 farm.
When the user connects to this app user experience poor screen refresh rate and latency in the overall VDI session. If the user closes The IE app the VDI functions normally.
This issue started when we rolled out received 4.9 LTSR cu2 on to the VDIs. The IE-based app works perfectly fine on receiver 4.1. So we definitely know it is the compatibility issue between receiver 4.9 and presentation server/web interface 4.5.
We can’t roll back the receiver from 4.9 to 4.1, because we have to align with LTSR components in 7.15 LTSR environment.
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.