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

I have had very disappointing results with Microsoft Report Builder and SSRS.  Neither have even printed a simple results of a query.  Report Builder 3 was a sad experience. So I just downloaded Crystal Reports 2016 trial and DevExpress Reports trial.  I was told that the learning curve for DevX is extremely difficult, so I will delete that one.  I don't need complex reporting, just results of stored procs, some complex with as many as 7 tables in a series of joins.

What reporting software do you guys recommend?

Barry D
0
Hi experts ,
we have windows servers 2012 R2 running SQL cluster my problem is how to check that MPIO is properly configured or not? is there any way to find that is working fine?
0
I have updated Visual Studio 2015 with SP 3 and added SSDT.  Task Mgr shows Reporting Services - SQL Server Reporting Services.  In VS 2015, I don't see SSRS.  How can a report be made part of a Windows Form app?  Or is the only way to do reporting is by using SQL Server Express?  But, I don't see how to use SSRS from SQL Server.
Need a lot of instruction here.

Barry
0
What are the steps to patch a Windows Server CORE only system using SCCM?

Since this server is core it doesn't have a GUI and the administration can only be done through the PowerShell and Command Line.

The updates have already been approved and staged through the SCCM server console now we just need to install them using the proper PowerShell or command line commands.

Please provide me with the process on how to do this.
0
In SSRS report, I have a 3-column subreport that is supposed to have fixed height. However, instead of opening 2nd column, it grows in height, breaking the layout. Is there a way to prevent that?
0
We have an RODC in a DMZ that is unable to request a KerberosAuthentication certificate.  The request is made, but denied :

	Log Name:      Application
	Source:        Microsoft-Windows-CertificationAuthority
	Date:          5/20/2019 4:14:45 PM
	Event ID:      53
	Task Category: None
	Level:         Warning
	Keywords:      
	User:          SYSTEM
	Computer:      CA-ISSUE.<domain>.com
	Description:
Active Directory Certificate Services denied request 46875 because The RPC server is unavailable. 0x800706ba (WIN32: 1722 RPC_S_SERVER_UNAVAILABLE).  The request was for <domain>\RODC$.  Additional information: Denied by Policy Module

Open in new window


Our issuing CA is a member server inside the domain.  Everyone is running W2K12 R2.

Our DC's on the internal network have been issued KerberosAuthentication certificates.  It's only the RODC's on the DMZ that are getting "Denied by Policy Module".

Our RODC's do have two other certificates (that have both auto-renewed since originally issued from this same CA).  So I don't "think" it's a firewall issue.

I've found some discussions where it was recommended to update the membership of "CERTSVC_DCOM_ACCESS" on the CA .  I've not changed anything yet, since none of our DC's are in that local group.  It's only member is "NT AUTHORITY\Authenticated Users".

In those same discussions, there was a suggestion to check DCOM permissions on the CA.  Our permissions match what was described.  So strike #2.

Does anyone have any other suggestions of where things could be amiss?

I'm waiting to hear from our network engineer to make sure there's not a firewall issue I'm not aware of.
0
I have two 2012 R2 Servers joined to a domain and running HyperV. Both Servers are connected to a SAN via iSCSI and so there are about 8 mapped drives on each server using iSCSI initiators. The previous admin had replication going from Server A to Server B. The VM's have their storage in multiple mapped drives. We upgraded the Backup SAN with bigger drives. The previous Admin setup Replication between the two and then quit.

We failed the HyperV Replication over to the Backup Server and SAN. Everything came up fine, however when we upgraded the Primary SAN and went to set the Replication back up I can't figure out how he did it. When you set the Replication it has a field that says "Specify the default location to store the Replica Files:" under the Authorization and storage section. All of the iSCSI connections have different drive letters.

If I start a replication of VM1 and use it's storage drive letter of H, it comes over fine. But when I try to replicate VM2 with drive letter G, it goes to H as well and the VM's fill up one drive instead of going to their own drive letters and shares.

How can I set this up so they all replicate to their own storage on the iSCSI of the backup Host?
0
SBS 2011 - Can I delete the contents of c:\windows\softwaredistibution\download to free up some space on the 'C' drive?

If this is possible without any negative consequences, what is the best way?

I've ran Disk Cleanup etc. but need to free up some more space.

I look forward to hearing from you
0
Team ,

I have a scenario , where i have an enterprise client having three main offices ( of 500 users each ), hence three DC's present . This client has around 400 branches , where each branch there are 40 - 50 users each .

Related with MS AD and Authentication as AAA , is it advisable to have Servers(AD) in each branch and DC or only on DC with some branches

Regards
Sid
0
I just did a test installation of windows 2019 standard. After the initial install was done once the computer restarted it was in command prompt mode. There is no GUI interface. What did I do wrong?
0
We are loosing Internet access when our Small Business Server 2011 Standard is down or rebooting for updates.  I have a backup domain controller, yet internet access still goes down. Whats the best option to configure my backup domain controller to maintain the connection?
0
I'm having an issue with what I think is my group by.   Below is my script and results.  What I'm needing is one line.

my script
select inv_mast_uid ,unit_price, max(date_created ) as max_date
from po_line 
where inv_mast_uid = '2319'
group by inv_mast_uid, unit_price

Open in new window


my results
inv_mast_uid	    unit_price	    max_date
2319	            12.990000	        2004-04-28 12:45:07.000
2319	            14.700000	        2008-09-05 14:53:38.000
2319	            18.900000	        2009-11-20 10:22:49.000
2319	            19.450000	        2004-04-15 10:20:51.000
2319	            26.580000	        2005-06-03 18:17:30.000

Open in new window


what I'm looking for is this.
inv_mast_uid	    unit_price	    max_date
2319	           18.900000	       2009-11-20 10:22:49.000

Open in new window

0
I'm having some issues with a left outer join.  The problem is I'm only getting results if they exit in Table B but I need all results from Table A with the addition of it they are taxed.  

SELECT A.customer_id,
       A.customer_name,
       B.tax
FROM   A
       LEFT OUTER JOIN B
                    ON A.customer_id = B.customer_id 

Open in new window


Table A
customer_id	customer_name
1	                    Bob
2	                    Alex
3	                    Joe
4	                    Bill
5	                    Sue
6	                    Mike
7	                     Jill
8	                     Peg
9	                     Kip
10	                     Tony

Open in new window


Table B
customer_id	tax      shipping
1	        Y
2	        N
6	        N
7                       Y
9	        Y
10	        N

Open in new window


Results I'm getting
customer_id	customer_name	tax
1	       Bob	         Y
2	       Alex	         N
6	       Mike       	 N
7          Jill              NULL
9	       Kip	         Y
10	      Tony	         N

Open in new window



Results I'm looking for
customer_id	customer_name	tax
1	                Bob	        Y
2	                Alex	        N
3	                Joe	        NULL
4	                Bill	        NULL
5	                Sue	        NULL
6	                Mike	        N
7	                Jill	        NULL
8	                Peg	        NULL
9	                Kip	        Y
10	                Tony	        N

Open in new window

0
I set up a computer “not domain joined” “windows 10 home (does not have local GP)” for a remote employee, she will connect with remote desktop to the office, I restricted saving any documents locally.
The way I did it, I removed the users write permission from document/desktop/pictures/music. In addition, took ownership so the user cannot change the permission.
Any other quicker or more efficient way to accomplish the above?
0
Question regarding Microsoft server / terminal server licences (CAL licences).

We would like to host a terminal server setup on a dedicated server, and would like to know what exactly to look for in terms of licencing.  We would like to have separate practices (with their own virtual server with a dedicated sql server to them) and a few users to be able to access their server. Our program will be on the terminal server connection, so each user will connect via remote desktop.

We could be looking at up to 8 practices with 50 users.

Which server and which license should we be looking at, as this is new territory for us.

Being Windows partners, do we get any discount or services cheaper?
0
Hi,
I have a Bar Chart in SSRS but I cannot get the Y axis items(Name values) to sort alphabetically.
Below is my Bar Chart in Design Mode
sort issueThe Query that creates the Dataset is sorted  by name and returns the sort order as expected.
I have also set the [name] value to sort A-Z in the Category Groups  Properties.

However, when the report runs, the Names are not sorting  as expected.
Any guidance appreciated.
Thanks
0
I came across an issue while trying to do Always On VPN. I noticed my DC for the organization is Server 2012 (I have never looked into this, I was told everything was 2012r2 already)

I have verified it is 2012, and now I am at the point I need it 2012r2 at bare standard. I have license for 2016 and 2019 server editions.

Should I run the upgrade or migrate over. Any thoughts
0
Hi,
I have created an SSRS report in Visual studio.
Using a chart, see below,
for some reason  not all the labels for each bar are displayed on the Y axis.
I've checked the vertical axis properties and all seems ok there.
axis issueI am using SQL Server 2014

Any guidance appreciated,
Thanks
0
I am working on a SSRS report and I am trying to create an expression to sum the results of the same column in two different datasets (DataSet1 and DataSet2). This is based on the Activity column value being "C" in DataSet1.

=sum(iif(Fields!ActivitySort.Value = "C","DataSet1"),sum(Fields!CumulativeCapitalInvested.Value,"DataSet1")+sum(Fields!CumulativeCapitalInvested.Value,"DataSet2"),0))

I have rewritten the expression a number of times but I cannot get it right.

Error I get with above expression:

The Value expression for the textrun ‘Textbox195.Paragraphs[0].TextRuns[0]’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.

Would someone be able to help me with this expression?

Thanks!

Rob M.
0
This seems like a simple IIF statement in SSRS but it doesn't work.  Either part works if I only include one test (example 1 and 2), but neither works if I try and combine them (example 3 & 4).  Essentially if the anonymous code is true or the restricted record is "restricted" then I want a blank otherwise I want the address line to print.

example 1 works         = IIF (Fields!RestrictedRecord.Value = "No" ,  Fields!Address.Value," ")
example 2 works        = IIF (Fields!IsAnonymous.Value = "False",  Fields!Address.Value," ")

example 3 doesn't work        = IIF (Fields!RestrictedRecord.Value = "No" or Fields!IsAnonymous.Value = "False",  Fields!Address.Value," ")
example 4 doesn't work        = IIF (Fields!RestrictedRecord.Value = "No",  Fields!Address.Value, IIF (Fields!IsAnonymous.Value = "False",  Fields!Address.Value," "))
0
I would like to see who is working and who is not.

Is it possible to use software or a certain command to find all Windows 7/10 computers and notate which have the screen locked versus actively used?

Even better would be to log the information.

We run server 2012r2 with a single domain.

Thanks!
0
Hi,
I run a query in SSMS and get the following results.
ssms output
I use the exact Query in Visual Studio to create  a Report.
When I deploy the report and run it in Report Manager
I get differences underlined below in the format
 rs outputIt seems strange that some of the formatting is correct.
Any guidance appreciated,
I am using SQL Server 2014
Thanks
0
I have downloaded a trial version of Windows server 2019 standard edition. I have then ordered the OEM version.

Am I going to be able to use this OEM licence to convert the trial into the full working version?
0
Hi Expert,
I installed SQL Server 2014 SP3 Standard edition and it is default instance.I have migrated seemsdb for Symantec endpoint encryption management server and it was side by side migration. using SSMS seemsdb can be connected but could not save connection from symantech endpoint wizard. Here is the following error:--
“Incompatible Symantec Endpoint Encryption Management Server database version – 9.9.3.  

Please help.
0
Hi I need to migrate our SSRS 2014 reports to SSRS 2016 server.can anyone tell me the easiest and safest
way to do this ?

Many Thanks
0