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.

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

Sign up to Post

I am using this data set query that is generating error , The dated diff function requires 3 arguments(s). Incorrect syntax near Label 1. Incorrect syntax near 'Group Order'. The Query generates data for a DemographicsPar2(parameter. I am building a ssrs has board that uses this parameter.

SELECT DISTINCT 
                  'Age' DemographicGroup, 
CASE 
WHEN DATEDIFF(YY, DOB, @ReportDate) < 25 THEN '<=25'

 WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 25 AND 35 THEN '26-35' 
WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 36 AND   45 THEN '36-45' 
WHEN DATEDIFF(YY, DOB, @ReportDate) > 45 THEN '46+' END Label, CASE 
WHEN DATEDIFF(YY, DOB, @ReportDate) < 25 THEN 1 
WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 25 AND 35 THEN 2 
WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 36 AND 45 THEN 3 
WHEN DATEDIFF(YY, DOB, @ReportDate) > 45 THEN 4
END GroupOrder

INTO        #Demo2
FROM     [dbo].[Dim_Borrower]
UNION
SELECT DISTINCT 'Marital Status', MaritalStatus, 1
FROM     [dbo].[Dim_Borrower]
UNION
SELECT DISTINCT 'Race', Race, 1
FROM     [dbo].[Dim_Borrower]
UNION
SELECT DISTINCT 'Sex', Sex, 1
FROM     [dbo].[Dim_Borrower]
                      SELECT *, DemographicGroup + ' - ' + Label RealLabel
                      FROM     #Demo2
                      WHERE  DemographicGroup IN (@Demographics1)
                      ORDER BY DemographicGroup

Open in new window



When I run this query on the SSRS query Designer, the output shows Three columns. DemographicGroup / Label / GroupOrder/ Real Label ..
0
Hi,

I have an ssrs report which I would like to make dynamical (like a Powershell Crusties): when you click ok a column of sorts, when you search, it filters, ideally have also search filters and some nice formatting too (now it is a boring formatting).
One more thing: can I link to another ssrs report (clickable link)?

J
0
Hi,

I have a GUI which talks to a sql db backend via powershell and sql queries.

I execute queries remotely but now discovered stored procedures and views.
Created some views and a stored procedure.

What is the specific purpose of each item, the difference and what should I use for my gui?
Also, can I use the view for ssrs report?

J
0
Hi,

I have been asked to evaluate/review approximately 150 servers on our network, ranging from Server 2008 to Server 2019 list in  a spreadsheet with very limited information.   Just primary roles. (e.g. DC, DNS, RODC, SCCM Distribution Point, File and Print server, etc.)   It also lists Hyper-V, Hyper-V on workstation, etc.  

I don't have the owner information so I can't reach out to each and ask "what is this and what's it for?  The objective is to go through this giant list and label each with a "priority #" to either decommission it, upgrade the existing OS, determining the utilization of each server, apps installed, roles installed, etc.   I then need to be able to share my findings with the rest of my team so we can then determine the effort necessary to migrate, upgrade or decommission the server(s) as we look forward to our newest 2016 functional level infrastructure.  Fro example, there are 14 RODCs at branch sites, but Sites and Services is not configured properly, so that could be a priority #1 (through 5) for us.   How do you experts approach these types of tasks and projects?   What do you break things down to and label it as to what should happen to each server and where it should reside, e..g Azure.

Thanks for any information you can provide.
0
Hi all,
How can set group policy for wallpaper for all client PC.
I have configured but some time it is going to black screen. because I kept wallpaper in shared folder.
please suggest how we can avoid this issue and suggest me.
Any other group policy suggestion.
0
I am proposing a major upgrade for one of my clients.

Up till now, we have been using a 3rd party registrar for business emails. Lately my client continues to ask for additional emails accounts to be setup - exceeding our purchased quota. I have also been pressed for synchronization on inboxes with iphones. For the time I have been configuring via IMAP.  Needless to say, they have out grown this basic email package.

Yes I have considered Office 365 Business, and Premium w/ Exchange, but, I want to investigate my options in-house. I can't seem to get past that reoccurring annual charge.

We currently have a 1 Dell PE R320 running Windows Server 2012 R2 Standard. There are 13 users in the office environment, 10 out in the field.  We have a 3rd party business application running off of SQL on this same server. Our system comes with the ability to created 2 VM'S, running the Server 2012 R2 Standard. I'm thinking great, I don't have to spend another 2,500 on a server, I'll use what I already have. Then I read the following on Microsoft:

•      Only management software (for example, antivirus software, backup software, or virtual machine management software) can be deployed on the physical host machine. No other server-based applications (for example, Exchange, SQL Server, Active Directory, or SAP) should be installed on the host machine. The host machine should be dedicated to running guest virtual machines.

So, that is the warning. Has anybody actually tried to do this, …
0
Hi, is there anyway to Stop SSRS from Building ALL reports when Previewing in Visual Studio ?

Many Thanks
0
I have a situation where I have incorrectly added a 2nd Domain Controller certificate ( for server, and client authentication purposes), and i think this is causing me problems with LDAPS authentication ( from some external java applications - using LDP locally works fine, and can bind to SSL on port 636)

See attached picture.

certificatesThe Certificate with the expiry date 04/02/2021 is the one is have just created ( and would like to keep )
The Certificate with the expiry date 05/06/2020 is the certificate that was originally installed.

The only other relevant information is that this domain controller was migrated from SBS2008, and the CA root certificate was migrated over.

So - is it safe simply to delete the expiry date 05/06/2020 certificate in Certificates MMC, or is there anything else i need to do / not do !
Thanks
0
My organization is currently using SCCM version 1902.

We have some Windows 7 machines and Windows 10 initial install machines that both need to be upgraded to the latest version of Windows 10 using SCCM.

All of these computers are joined to the Active Directory domain and have the SCCM client installed.

SCCM is currently configured to load the latest Windows 10 operating system to computers and virtual machines using PXE boot. Now we need to upgrade these existing Windows operating systems to Windows 10.

What are the steps to upgrading these existing operating systems to the most current version of Windows 10?

SCCM Operating Systems
0
I recently moved SSRS to a new server.  The migration went fairly well and most of the reports are running fine on the web server.  I've been going through each project to point the project  to the new report server location and then updating the connection string on shared data sources to again point to the new server.  Almost all of my data sources point to one of 2 catalogs (one for finances and one for fundraising) and I have successfully updated many of the projects without an issue for both catalogs.  However, I have a folder that uses both data sources.  I've made all the changes to point to the new server and when I test the connection string, it is successful.  However, if I try and run the query for the financial data source, it errors out with the following error (last paragraph).  If I turn on the old SSRS server, it works fine.  I've checked and double checked that everything points to the new server and it does.  Again, this data source is used in other projects and works fine there - just not in this one project.  I've even deleted and recreated the data source and it still won't work.  I can't figure out what the problem is... and feel the error is misleading.  

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - …
0
I am setting up a new Windows 2019 Server for a customer.  The way I was taught in the past was to add the role of DNS server to the DC and use the router for the DHCP to the PCs.  I have done it successfully on several servers but it seems convoluted and possibly not correct and efficient.  I do have one customer where the DC is both the DHCP server and DNS server and have not had any issues.  The DNS is configured properly with the interfaces and forwarders and DHCP turned off in the SonicWall.  DHCP is configured with the scope and all of the correct parameters.  I would like to get some opinions as to which way to go.  It seems to me it would be best practice to allow the DC to do both.  What are the pros and cons (if any) using this method?
Thank you in advance,
Phil
0
New HP Proliant ML350 Gen10 server - doesn't have a dvd reader
Obtained ROK with Windows Server 2016 Essentials it came on DVD.
HP suggested using their USB key utility - but it wouldn't work with the DVD -even though the dvd is readable / tried multiple computers.
Copied DVD contents to local folder, then created ISO using freeware.
Used Rufus to make a bootable USB flash using the ISO.
HP intelligent provisioning won't recognize the flash, or the same iso on another flash.
Started to boot direct from the flash but errors with  'windows could not collect information for [OSImage] since the specified image file [install.wim] does not exist.
Hours spent on this and multiple calls to HP have yielded no success.
Is there a foolproof way to create a USB flash from this ROK that will work?
0
I would like to create a Virtual Directory that points to a PDF or Image file on our active directly drive which is mapped on the IIS server. So when someone follows the link it will pull up that PDF or Image.

Example:
G:\Image\Maps.jpg
G:\PDF\MyFile.pdf

Thanks

Here is the error I currently get:  Capture.JPG
0
I was having a heck of a time trying to create a report in Visual Studio 2017.  I removed references to version 9 and installed 150.1400 from nuget and added the references back.  I was never able to get a report viewer onto a form.  It always ended up at the bottom as a component like the timer or backgroundworker.  I uninstalled 2017 and installed 2019 after hours of unsuccessful google fu trying to fix it.  2019 allows me to drop a report viewer onto a form but I am missing the add new item - report option.  So now I can drop a report viewer onto a form but I can't add an RDLC to my winforms project.  I may go back to VS 2010 where things just worked...This is crazy frustrating.

Any ideas on getting the report creation option into the menu?

Thanks
screen shot references
0
What other "microsoft.com" website do you recommend besides the below to get a patch HISTORY list ?

https://portal.msrc.microsoft.com/en-us/security-guidance
0
Hi,

I d like to have a daily or weekly sql ssrs report of ALL software users have on their pc (add/remove programs?) by querying our sccm 2012 server (latest version) plus number of installs per item/preferably also clickable that it shows the list of pcs per software.
Nice would also be to map it to sccm.itself: do.we have it in sccm (or was it installed nu user manually).

I d like to be able to exctact the data in Powershell so I can work with it. F.e. $alllsoft | get top 10 foreach ...

Thanks!
J
0
I have 2 windows servers that are part of a workgroup and sitting on a VLAN behind a ferewall. I want to sync time on these 2 servers to a domain controller sitting on another VLAN on the other side of the firewall. Is this possible and if so how do I do it? Or are there better alternatives??
0
I moved my SSRS application to a new server.  My last step was to get my SSL certificate working for the new server.  I’ve done quite a few, but cannot get this one to work. It is through Godaddy and I’ve talked to them several times.  Today I was told that they aren’t training in certificates for IIS so they can’t help me.

I’ve followed the instructions in this article:  
https://www.godaddy.com/help/manually-install-an-ssl-certificate-on-my-iis-8-server-4951

But there is some misleading steps and I don’t know if that is why it isn’t working?  Step 14 says to upload the intermediate (.p7b) to MMC.  I’ve done that.  The next steps are in IIS and on step 22 it says to find your primary certificate that you previously uploaded.  There aren’t any steps that say to import it on MMC so I’m not quite sure what that means.  I complete the install of the primary certificate (.crt) on IIS and then do the bindings.  I then restart the services.  But the website never works.  On IIS everything looks ok.  I’ve actually started the old server and compared what I see in the 2 servers and they look the same.  I’m not sure what to do?  Any thoughts??
0
I have a SQL 2017 SSRS report that is grouped by state by month. There are two lines per state with the 12 months spread across each line. The first line is total invoice amount and the second line is total sales tax amount. I am now trying to configure the footer to show the total for all states with one being the total for the sales amount and the other being the total for the sales tax amounts. I do have a column called Type where Sales = sales amount and Tax = sales tax amount. I tried creating two groups at the bottom based on Type with filters but both lines keep giving me to total of both. Underneath this report is a SQL query with a union between the sales amounts and the sales tax amounts. How should I structure the totals to present the two separate totals?
0
I recently moved my Windows 2008 R2 / SQL 2008 R  SSRS install to a new server (Windows 2016) and SQL (2014).  I thought everything was working fine - we are getting subscriptions emailed internally every day and all of the reports are running fine.  However I just discovered that subscriptions to external emails are not being sent out.  I'm getting one of two errors:
    unable to send to a recipient (happens when I have both an internal email and an external email)
      failure sending email – mailbox unavailable with a server response of 5.7.54 unable to relay recipient in a non-accepted domain (happens if it is just external email)

      Our exchange server does not have relay/connectors set up for the old SSRS server so I didn't set up relay/connectors for the new one.  The SSRS configuration app has the same settings for email on the old and new server.   The config file is also identical for email.  I'm using the same login to send reports on both servers.  I've run a trace on the email from that account and it shows all of the reports sent to internal emails addresses but doesn't show a thing for those sent to external email addresses.  I have no clue what is causing the error and don't know if it is because of a difference in Windows versions or SQL versions or ??  

      Our email is 365 but we have a local exchange server that syncs active directory with 365.  

      Can anyone help?
      0
      Dear all,

      we are trying to publish Adobe Acrobat DC 2015 into a Citrix Session. Environment is:

      - Windows Server 2016, all updates applied
      - Citrix Virtual Apps and Desktops, 1903
      - Citrix Workspace, 1907

      So far, this is working fine, except one thing:
      If you try to open a document from a network drive, Adobe Acrobat will state: " Error opening Document".

      In Detail:
      If you access a network drive using Windows Explorer, this error will display and the PDF won't open.
      If you open up the same location in Windows Explorer using UNC path, double clicking the PDF will open it.
      If you open the same document from the published App it doesn't matter if you access it by UNC path or network drive.

      EDIT
      Same applies also to TXT Files. Error message is a little bit more detailed: " Network drive could not be found".
      I guess this will apply to all other file typs as well, i fwe would extend out testing.

      Any help on this is appriciated.

      Best Regards, Brummelbart
      0
      In SSRS report showing pending invoices, in the last column I have a hyperlink that marks the invoice as sent. This is accomplished by setting Action to the following:

      ="javascript:w=window.open('http://myserver/MarkInvoiceAsSent/?invoice_id=12345');w.close();document.location.reload(true);"

      "MarkInvoiceAsSent" is an asp page that quietly performs the requested database transaction, with no output. "12345" is for this example only, in fact it substitutes the correct value from this row.

      The problem is that w.close closes the page before it has opened, so the transaction is not performed.

      Is there a way to modify javascript so that it would wait until the page is complete before closing it? Or perhaps some other way to accomplish this.
      0
      Hi,

      I am looking into azure for possible migration solution to move my on-premise file server.

      I currently have office 365 so I have our on prem AD synced to azure via AD Connect. We also have a site to site vpn with azure.  i know there is an issue with givng file permissions to users based on windows AD credentials.  I also know Azure now has Azure AD DS.

      My question is if I create a azure domain joined VM file server (Azure AD DS enabled) will I be able to have this file server mapped to everyone windows explorer (just like they are currently doing) and use it the same way with their on-prem file server.  Their machines are regular on prem domain joined. If I make a change to the ACL rules in a folder will it have to be done directly from the azure vm file server? Will the ACL permissions carry over when this file server is mapped to on prem domain joined machines?

      If no, then I guess I would just use azure file sync although the storage there is more expensive.

      Thank you.
      0
      Office 365 and Work controlled computers.  Have a support call for a Non-Domain server, running Remote Desktop.  Server has no virtual OS either.  They bought new laptops and attempted to connect to their network during the holiday shutdown, but they hired IT students to do the work.  The students setup the computer as Company owned using a newly created Office 365 account with individual users.  I was not part of the Office 365 configuration, so I don't know many details.  They are having trouble mapping network drives because of the MS online account, and the 2019 Server doesn't use online accounts.  I have shown them connecting with different credentials for mapping the drives, but figure a better solution must exist.  The company owned setup changes several items in the administration of the laptop.  Can anyone give me the crash course on MS online accounts in Business?  I am old school and have avoided online accounts in the business environment.
      0
      Does anyone have pre-designed powershell scripts I can run on Server 2012 R2 to do AD cleanup?  I would like to cleanup old accounts machines OU's and groups.   I found some power shell scripts on Microsofts site but they just open prompt a message really quick that I cant read and close.  I just need a general cleanup Thank you.
      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.