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

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.

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, …

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.

The 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

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 - …

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?

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

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

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??

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?

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.

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.