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

Visual Studio 2015, SSRS

I am having a problem working on RDL files locally.  I was sent some RDL file to review.   When I use  "Add Existing"  to add the reports to a report project, I can see the report design when I right-click and select "View Designer"

However, when I select "View Code", I only see XML.  What am I doing wrong?

Thanks
0
Learn SQL Server Core 2016
LVL 12
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Experts,

I have an SSRS server setup and we are currently scheduling nightly delivery (via EMAIL) of reports to clients.

The issue is that I would like to "dynamically" change the "FROM EMAIL" address for the out-going emails that contain the reports to a "Special EMAIL Address" for certain CLIENTS.
So for example, if I schedule a nightly report delivery via email for Customer "A", then I want EMAIL ADDRESS "A" to be included within the body of the email as the FROM email.

If I schedule a nightly report delivery via email for Customer "B", then I would like EMAIL ADDRESS "B" to be included within the body of the email as the FROM EMAIL.

Can someone help with HOW TO DO THIS?

Let me know if you have any questions.

Thanks
M
0
Hi, Just dropping this question again with some more detail to see if i can get a work around.

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. we have over 25 reports that need to been converted but they all have a running total as a grand total, typically evaluating on group, outside of the group. In some cases these running values are used in other calculations. It is a nightmare.

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.

I have read through many links but i can't see how they will work, but i might just have a skill gap, none of them cover where the running total evaluating on group are used as a total only.

I have attached an example of one of the reports that has a running total, it is only one of the possible layouts and ways the previous reports used the running totals. but does highlight the issue i am hitting. If possible i would rather do this within the ssrs report but i am at a loss on how to get it to work.

We are on SQL 2014 but are about to migrate to 2016

Any ideas on a way to get this to work?

Example-of-Running-total-in-Report.JPG
0
I am doing a server refresh soon. Plan is to get replacement RDS servers running Server 2019, to replace our aging 2008R2 boxes.

Since we have a heap of software in use, I am going through the testing process, checking that everything works, and figuring what to do with apps that do not. Will then pilot with a few users for a week for acceptance testing. I have downloaded and installed a  copy of Server 2019 for this purpose.

Problem I am having now is with obtaining a key for the 2019 180day demo. The Microsoft Evaluation Centre originally had the ISO and keys on 2-Oct, but this was pulled a few days later.  Now it just says "Following the launch of Windows Server 2019, we started the process of publishing the media for the 180-day evaluation media. In the process, we found an issue with the Eval media and are in the process of fixing it." Apparently the product can be purchased, and it available to volume licensing and MSDN users, but plebs still cannot obtain a key.  The actual "issue" referred to was remedied weeks ago, and is irrelevant to us.  

Any ideas where I can obtain a 180 day key for Server 2019?

I am NOT trying to do anything dodgy, illegal or unethical here, I just want to run a demo version and see what does not work.
0
I'm a system administrator for Report Manager.  I can see the users my folders, but cannot see the reports in the folder.  I need to be able to see all the reports created in report builder in the user's my folder.
0
I need to create a report based on a sharepoint online list. When our sharepoint server was in house, this was not a problem but I cannot get the connection string to work for sharepoint online. I do not know power BI and frankly don't have time to learn it. If I can get SSRS to connect and I can get my report done in 1/2 hour. Anyone know the connection string to make this work?
0
I am trying to write a ssrs report based on a sharepoint online list. I have tried about 100 different variations of the connection string with no luck. Can anyone point me in the right direction?
0
Hi,

I have a Windows 2012 R2 Hyper-V server with 3 VMs.  One of the VMs is setup for Remote Desktop Services and we have about 13 users connect into this server to work.  Most of them connect to it from within the office.  Some of the users connect from outside of the office.  The managers asked me if there's a way that I can restrict remote access for some of the users.  They would be able to work at their computer within the office but if they go home and feel like they want to remote into their session, they would be restricted from logging into their session when they're out of the office.  What's the best and most simple way to accomplish this?  Thanks in advance for your help!
0
We currently use ADFS for authentication with some 3rd party hosted applications (i.e. Qualtrics).  When our users hit the 3rd party site, they are redirected to our ADFS site where they are prompted to enter their AD credentials.

Is it possible to get those 3rd party sites to automatically login from domain joined computers using the credentials of the logged in user instead of having the user re-enter their credentials on the ADFS site?  If so, how do we go about doing this?  Is it something we can change on the ADFS setup, or do we need the 3rd party application vendor to support it and make some changes on their end?
0
Hi Experts,

I am using SSRS and I want to create a subtotal on based on the first 7 character of the AccountID field.

So the example attached, I would have a subtotal for the account 101-002-xx,  101-007-xx and 102-002-xx.

Screenshot_1.png
0
10 Holiday Gifts Perfect for Your Favorite Geeks
LVL 1
10 Holiday Gifts Perfect for Your Favorite Geeks

Still have some holiday shopping to do for the geeks in your life? While toys, clothing, games, and gift cards are still viable options for your friends and family, there’s more reason than ever to consider gadgets and software.

How can we deploy the ssrs report to Share point?
0
Hi Team,

Please help me to resolve this issue.


Please Check attached .jpg diagram of my infoblox environment.


Working:-
1)      Earlier they had Microsoft server in all their location all individually working as primary and in sync with each other using Replica feature
2)      Now After infoblox when we make Microsoft role as secondary then only zone sync happens
3)      So traffic flows from Microsoft to infoblox, then from infoblox to DNS Proxy Forwarding and then to cloud
4)      We have told to install DNS Proxy Forwarding to get visibility of user based logs
5)      Also we have installed Reporting VM


Issues:-
1)      They are using infoblox just for DNS purpose only and not for DHCP
2)      They have individual DHCP servers on their different locations and their Microsoft DNS servers are acting as AD as well
3)      So whenever a new PC is added in domain or any PC changes its IP address a record is added in Microsoft but not on infoblox
4)      So for that we configured Updates on infoblox as suggested by TAC support
5)      Now the issue happening is that, when PC changes IP its earlier record is also present in infoblox and new records is also present, due to which when client connects to RDP he is redirected to another PC.

 For eg: - If A had ip-1.1.1.1 and after new lease allocated he has now ip as 2.2.2.2 and 1.1.1.1 is allocated to B, then there are four records present in infoblox
A-1.1.1.1 as static
A-2.2.2.2 as dynamic
B-1.1.1.1 as dynamic
B-earlier IP of B as static

So…
0
I have an old Dell PE2950 server with Perc 6 hardware raid controller in place. I'm setting it up as a storage for backup location. I would like to install 2012R2 on it and use Storage Space. But my question is, do I need to use or configure hardware RAID if I want to use Storage Space? I understand Storage Space does provide RAID feature already.  Appreciate if you can give me some suggestions. Thanks.
0
Hello

I have run into an issue I can not figure out. I am running a 2014 sql express server that is connected to and importing data from a 2008 R2 sql server.  Each server is Hosted within the same Virtual Machine host using the same data storage but on individual VMs. When trying an import the from the express machine the script runs well but hangs because of some type of temp disk space utilization that that fills the drive with over 40GB. On reboot the disk space returns to normal. The script is pulling only about 6000 records from the other data base and when complete the dtabase file is less than 50MB.

We copied the data from the remote server and placed it on the 2014 express server changed the script to look remotely and the import happened as it should.

My questions are why and how does the fail happen?  Why would a large temp file of some type be written when importing between VMs. How do I over come this?  

I will provide any other information you may need and thank you for your help.
0
We have a SMALL domain with 2 2008R2 DCs running at a 2008 AD level. It's time to upgrade. One is a physical machine and the other is a VM. We are replacing the physical machine with new hardware that has Server 2019 on it. We want to upgrade the VM instead of creating a new one. Our thinking would be to:

1) raise domain level to 2008R2 from 2008
2) join new 2019 Server to domain and promote it to a DC (so there would be 3 DCs for a little bit)
3) demote VM DC and upgrade the OS to 2019 and promote it back to a DC
4) demote old physical DC
5) raise domain level to 2016 since both DCs are Server 2019

Is this a sound plan or would we be better creating a new VM, making it a DC then just demoting the old VM and deleting it? This is the first time we've done anything with the DCs since they were setup,

Are there any potential issues for the workstations/servers (all workstations are Win 7 current updates or Win 10, Exchange server 2010, CRM 2013, Sharepoint 2010) bringing the AD from 2008 to 2016?
1
I would like to know how to manage patch management (eg. a group of servers with different flavours of operating system).
Also how to re-check updates after the first patch of updates have been installed.
Also how to force check back to reporting services to gain accurate result if they are compliant or not.
0
We create VMs with the latest build of our code on. One VM has a weird ASYNC_NETWORK_IO error when running a SQL SELECT statement. It isn't on any other VM.

I have tried googling for the error - clearly something failed to start or get set when this VM was created.

Just for peace of mind it would be really useful to know what might be the cause of this and if there is some setting I can adjust to fix it.

The symptom is that a SQL SELECT statement just seems to time out with this ASYNC_NETWORK_IO error, but the strange thing is that it must have somehow returned some results because it then blocks an INSERT statement that has used the results of the SELECT statement.

Everything necessary for the application is on the VM - the ASP.NET application and the SQL Server database so there is no actual network access outside of the VM.

There is no antivirus running on the VM either which is one possibly cause I came across.

The server is Windows Server 2016 and the SQL Server is 2016 also.

I've attached a picture of what is happening.

Just to repeat this doesn't occur on any other VMs with the same software on.

I have tried restarting IIS and restarting the VM.

The VM is Hyper-V.

ASYNC_NETWORK_IO error
0
Hi,

I have found the following code to render an SSRS via a SSIS script. This script works as it is intended, e.g. saves the rendered report to disk.

But I would like to send the rendered report as an email attachment, without saving it to disk. Please could someone help? I have tried to render it to a memory stream but I can't quite get it to work.

Thanks, Greg

 Protected Sub SaveFile(ByVal url As String, ByVal localpath As String)
        Dim loRequest As System.Net.HttpWebRequest
        Dim loResponse As System.Net.HttpWebResponse
        Dim loResponseStream As System.IO.Stream
        Dim loFileStream As New System.IO.FileStream(localpath, System.IO.FileMode.Create, System.IO.FileAccess.Write)
        Dim laBytes(256) As Byte
        Dim liCount As Integer = 1
        Try
            loRequest = CType(System.Net.WebRequest.Create(url), System.Net.HttpWebRequest)
            loRequest.Credentials = System.Net.CredentialCache.DefaultCredentials
            loRequest.Timeout = 600000
            loRequest.Method = "GET"
            loResponse = CType(loRequest.GetResponse, System.Net.HttpWebResponse)
            loResponseStream = loResponse.GetResponseStream
            Do While liCount > 0
                liCount = loResponseStream.Read(laBytes, 0, 256)
                loFileStream.Write(laBytes, 0, liCount)
            Loop
            loFileStream.Flush()
            loFileStream.Close()
        Catch ex As Exception
        End Try
    End Sub
    

Open in new window

0
Hi,

We have MS SSRS 2016 configured on Windows Server 2012 R2. Quite frequently we have to end the "ReportingServicesService.exe" process via the task manager and then restart the service because the reports just show the loading circle when rendering. The SSRS portal itself is OK and the end users can browse through folders and see all of the reports but when they select ANY report it just hangs at rendering.

If we try to stop the "SQL Server Reporting Services" service via the SQL Server Configuration Manager it does not stop. We have to end the process via the task manager and then restart the service. Normal service then resumes for a few days.

I have had a look through the logs in "C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles" but I cannot find anything useful, but then I do not really know what I am looking for.

Has anyone come across this issue before?

Thanks, Greg
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.

I need some best practice help cleaning up domains with minimal user impact.  This is my second job where I've come in with a mess around domains.  Usually the main domain isn't one they want to use, but changing it is perceived as too impacting to make any changes so they live with it.  Here are my objectives if there's any advice on best practices, tips, and or suggestions for navigating these waters.
1.  We have a domain, domain.lan that nobody wants to use.  We want to switch the main login domain to newdomain.com for the corporate offices.  We actually only recently acquired this new domain name.
2.  We currently sync domain.lan as domain.com with Office 365.  Need to minimize impact to email functions.
3.  We have several other domains, like otherdomain1.com, otherdomain1.org, otherdomain2.com, etc.  Can I have these users utilize these other domain names for login?  Is it possible to have a forrest with multiple domains under it, or does that get messy?  Is it better to have the main domain, newdomain.com for all domain joined machines and logins?  Problem is we have multiple companies acting independently, but I don't think I want multiple domain controllers with multiple Forrests.  Maybe newdomain.com is what everybody uses, and I just manage different organizations by OU.

Any suggestions for converting to newdomain.com from domain.lan and converting our AD sync with Office365 to newdomain.com instead of the currently used domain.com?  It's not even syncing …
0
I have a folder redirection GPO setup that redirects users’ desktops and my documents folders.
It redirects to a hidden share.  Share path is \\<servername>\RedirectedFolders$\<username>
‘everyone’ has full access to this hidden share.
The server is Server 2016.  The client pc is Windows 7 Professional.

Since the GPO took effect, doing a search in the redirected folders/subfolders on the clients machine immediately returns no results found.
A search conducted on the server itself returns results.
Offline folders are enabled.  I have deleted and rebuilt the indexes.  I made sure the user has ‘full control’ over the folder and subfolders.
Only the redirected folders return no results.  Non-redirected folders work fine.
How can I get the redirected folders to be searchable from the client pc?
0
I want sum of Count column, can you please share expression for this or how to do this? the number of rows of date and count column is not fixed, it will vary every day.Untitled.png
0
Hello,

How to add multiple user of different domain in single Forest in One Universal Group

I have with me SAM account name

Group is in Root domain and users are from all child domain

like root domain and child domain is below

abc.com
  xyz.abc.com
  asd.abc.com

Group name is : contoso-adGroup


Please suggest a script

Thanks
Addy
0
Hi Experts,

Periodically our PDC issues EventID 4 "The Kerberos client received a KRB_AP_ERR_MODIFIED error from the server **** The target name used was ldap/****.***.com.au/***.com.au@***.COM.AU. This indicates that the target server failed to decrypt the ticket provided by the client. This can occur when the target server principal name (SPN) is registered on an account other than the account the target service is using. Ensure that the target SPN is only registered on the account used by the server. This error can also happen if the target service account password is different than what is configured on the Kerberos Key Distribution Center for that target service. Ensure that the service on the server and the KDC are both configured to use the same password. If the server name is not fully qualified, and the target domain (***.COM.AU) is different from the client domain (***.COM.AU), check if there are identically named server accounts in these two domains, or use the fully-qualified name to identify the server."

We can then see this error replicated on the other domain controllers and more importantly to our Exchange Servers. At that point we can no longer authenitcate Outlook clients and email essentially stops working. From what I've read this is related to the machine password being updated and not replicating properly. I've done some digging as to why that would be and checked all DNS settings which seem to be fine. No issues reported with AD replication …
0
Looking for Script to find current page file Size/ status on windows 2008 and 2012 Server
and can we automate the Pagefile setup for servers in domain according to  Memory assigned on different Boxes
Will there be any Reboot required or if we can do it without reboot
1

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.